I can’t open the exported Excel files in Excel anymor

  • Resolved webspatz

    (@webspatz)


    4 years, 5 months ago

    Hi

    I can’t open the exported Excel files from Gravity Forms Entries in Excel anymore. All Plugins and WordPress should be up to date.

    May I ask for your help?

    Regards,
    Greg

    —-

    ### Gravity Forms ###

    Registration: Site registered ( 200b810b-9154-404f-a020-acfd780f525b ) ?
    Version: 2.4.18 ?
    Upload folder: /home/httpd/vhosts/j4fun.ch/httpdocs/wp-content/uploads/gravity_forms/
    Upload folder permissions: Writable ?
    Output CSS: Yes
    Output HTML5: No
    No-Conflict Mode: Yes
    Currency: CHF
    Background updates: Yes
    Locale: de_DE

    ### Add-Ons ###

    Mad Mimi: by Gravity Forms – 1.3 ?

    ### Database ###

    Database Version: 2.4.18 ? Your database is up-to-date.
    ixFI2e7_gf_form_view: ?
    ixFI2e7_gf_form_meta: ?
    ixFI2e7_gf_form: ?
    ixFI2e7_gf_form_revisions: ?
    ixFI2e7_gf_entry: ?
    ixFI2e7_gf_entry_meta: ?
    ixFI2e7_gf_entry_notes: ?
    ixFI2e7_gf_draft_submissions: ?
    ixFI2e7_gf_addon_feed: ?

    ### WordPress ###

    Home URL: https://j4fun.ch
    Site URL: https://j4fun.ch
    WordPress Version: 5.4.2 ?
    WordPress Multisite: No
    WordPress Memory Limit: 96M
    WordPress Debug Mode: No
    WordPress Debug Log: No
    WordPress Script Debug Mode: No
    WordPress Cron: Yes
    WordPress Alternate Cron: No
    Background tasks: No ? cURL error 28: Operation timed out after 2001 milliseconds with 0 out of -1 bytes received

    ### Active Theme ###

    j4fun: by Undsgn? (https://www.undsgn.com) – 1.0.0 ?
    Uncode (Parent): by Undsgn (https://www.undsgn.com) – 2.2.8.1 ?

    ### Active Plugins ###

    Antispam Bee: by pluginkollektiv – 2.9.2 ?
    Category Order and Taxonomy Terms Order: by Nsp-Code – 1.5.7.2 ?
    Classic Editor: by WordPress Contributors – 1.5 ?
    Custom Functions von WEBSPATZ: by Gregor Altenburger – 0.1.0 ?
    Duplicate Menu: by Jonathan Christopher – 0.2.2 ?
    Duplicate Page: by mndpsingh287 – 4.2 ?
    Email Encoder – Protect Email Addresses: by Ironikus – 2.0.7 ?
    EventON: by AshanJay – 2.6.17 ?
    Extensive VC Addons: by Nenad Obradovic – 1.8.1 ?
    Full Screen Background Images Pro: by Scott DeLuzio – 2.3.5 ?
    Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 7.10.4 ?
    Google Analytics Opt-Out: by WP-Buddy – 2.3.2 ?
    Gravity Forms Email Verification Addon: by Albert Brueckmann – 1.7.5 ?
    Gravity Forms Entries in Excel: by Doeke Norg – 1.7.5 ?
    Head, Footer and Post Injections: by Stefano Lissa – 3.1.6 ?
    Imagify: by WP Media – 1.9.10 ?
    Invisible reCaptcha: by Mihai Chelaru – 1.2.3 ?
    Limit Login Attempts Reloaded: by WPChef – 2.13.0 ?
    Marvelous Hover for Visual Composer: by Themelego – 2.0.8 ?
    Menu Icons: by ThemeIsle – 0.12.2 ?
    Real Media Library: by devowl.io – 4.8.5 ?
    Redirection: by John Godley – 4.8 ?
    Related Posts for WordPress: by Never5 – 2.0.3 ?
    Reveal IDs: by Oliver Schl?be – 1.5.4 ?
    SeedProd 404 Page Pro: by SeedProd – 2.0.10 ?
    SeedProd Coming Soon Page Pro: by SeedProd – 5.12.5 ?
    SeedProd Login Page Pro: by SeedProd – 1.1.13 ?
    Slick Slide Menu for WPBakery Page Builder: by ThemeofWP.com – 1.0.8 ?
    Slider Revolution: by ThemePunch – 6.2.2 ?
    Slider Revolution Holiday Snow: by ThemePunch – 2.0.0 ?
    Social Icons Widget & Block by WPZOOM: by WPZOOM – 4.0.2 ?
    Styler for Gravity Forms: by IdeaBox Creations – 1.2.0 ?
    TablePress: by Tobias B?thge – 1.11 ?
    Uncode Core: by Undsgn – 2.2.8 ?
    Uncode Dave’s WordPress Live Search (4.4.1): by Dave Ross – 1.0.3 ?
    Uncode Wireframes: by Uncode – 1.1.0 ?
    Uncode WPBakery Page Builder: by Michael M – WPBakery.com – 6.1.0 ?
    UpdraftPlus – Backup/Restore: by UpdraftPlus.Com, DavidAnderson – 2.16.26.24 ?
    VC Particles Background: by Boom-Apps – 1.3 ?
    WPBakery Page Builder (Visual Composer) Clipboard: by bitorbit – 4.5.5.1 ?
    Yoast SEO: by Team Yoast – 14.3 ?

    ### Web Server ###

    Software: Apache
    Port: 443
    Document Root: /home/httpd/vhosts/j4fun.ch/httpdocs

    ### PHP ###

    Version: 7.2.31 ?
    Memory Limit: 256M
    Maximum Execution Time: 120
    Maximum File Upload Size: 256M
    Maximum File Uploads: 100
    Maximum Post Size: 256M
    Maximum Input Variables: 200000
    cURL Enabled: Yes (Version 7.29.0)
    OpenSSL: OpenSSL 1.0.2k 26 Jan 2017 (268443839)
    Mcrypt Enabled: No
    Mbstring Enabled: Yes
    Loaded Extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, pcntl, readline, Reflection, SPL, session, standard, cgi-fcgi, bcmath, bz2, calendar, ctype, curl, dba, dom, mbstring, fileinfo, ftp, gd, gettext, gmp, iconv, imap, intl, json, ldap, exif, mysqlnd, odbc, PDO, Phar, posix, pspell, shmop, SimpleXML, soap, sockets, sodium, sqlite3, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, xml, xmlwriter, xsl, mysqli, pdo_mysql, PDO_ODBC, pdo_sqlite, wddx, xmlreader, xmlrpc, imagick, zip, ionCube Loader, Zend OPcache

    ### MySQL ###

    Version: 5.5.5 ?
    Database Character Set: utf8
    Database Collation: utf8_general_ci

    ### Date and Time ###

    WordPress (Local) Timezone: Europe/Zurich
    MySQL (UTC): 2020-06-16 11:20:49
    MySQL (Local): 16. Juni 2020 um 13:20
    PHP (UTC): 2020-06-16 11:20:49
    PHP (Local): 16. Juni 2020 um 13:20

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Doeke Norg

    (@doekenorg)

    Hi @webspatz,

    Sure no problem. So you don’t get an error, but the file us not readable. Could you send me one of those corrupted files? You can send it to [email protected]. I’ll take a look if anything else is a miss.

    Usually this is because another plugin or template is returning a notice or warning, that corrupts the output of the excel. If you have WP_DEBUG enabled it could help to disable that. (Usually a good idea in production to avoid leaking info).

    Thread Starter webspatz

    (@webspatz)

    Hi Doeke
    thank you for your help. I tried to send you the file several time, but the e-mail is coming back all the time. Do you have an alternate e-mail? You can also contact me on [email protected]

    Regards
    Gregor

    Plugin Author Doeke Norg

    (@doekenorg)

    @webspatz I’ve send you an email. Perhaps you can reply to that.

    Thread Starter webspatz

    (@webspatz)

    Hi Doeke

    unfortunately I didn’t get your email yet. That’s strange.

    This ist the Excel File with the error:
    https://we.tl/t-eEb2DoyZ5j

    Plugin Author Doeke Norg

    (@doekenorg)

    @webspatz Very strange. Perhaps it ended up in your spam folder. Anyways, I’ve checked the file and it is corrupted. And probably by your theme. Somewhere your theme is outputting empty lines.

    Try to locate php-files that end with ?> and remove that. You don’t need to close PHP files, and more than often this is the issue.

    If you can’t figure this out, try to mail me at [email protected]. Perhaps that works. I might be able to help debug on the server.

    (I’ve removed 2 empty lines from beginning of the file source and now it works).

    Thread Starter webspatz

    (@webspatz)

    Hi Doeke

    thank you so much for your help. You’ve been right. There was a ?>in the function.php file of the child theme.

    All the best for you
    Gregor

    Plugin Author Doeke Norg

    (@doekenorg)

    Cool. Glad I could help. Enjoy the plugin.

    Plugin Author Doeke Norg

    (@doekenorg)

    @webspatz A little heads up; you might want to invalidate the wetransfer link as there is some personal data in there for the world to see now. GDPR and all ??

    Kind regards.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘I can’t open the exported Excel files in Excel anymor’ is closed to new replies.