• Resolved kerrydesigner

    (@kerrydesigner)


    Hello, I’m having an issue with the downloaded file being unable to open? This happens for both CSV and XLSX file formats.

    When trying to open the file I get this error:

    “Excel cannot open the file because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.”

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

    (@doekenorg)

    Hi @kerrydesigner!

    This happens often when the theme itself causes a warning or notice to be shown. Make sure your WP_DEBUG is set to false.

    If at all possible; please share a broken file with us at [email protected]. We’ll take a look if the error can be found inside the file.

    Kind regards,

    Doeke

    Thread Starter kerrydesigner

    (@kerrydesigner)

    Thanks for the prompt response!

    An example file is here: https://docs.google.com/spreadsheets/d/1_cSttbAtetcJSd1DuMjQxveBVYJsYznd/edit?usp=drive_link&ouid=114816826250083238451&rtpof=true&sd=true

    WP_DEBUG is set to false.

    This did work up until recently, so I don’t know if it’s the theme. But I may have updated the theme since it last worked. I will have to schedule in a time to test this. If it is the theme is there anything I can do?

    Plugin Author Doeke Norg

    (@doekenorg)

    @kerrydesigner If it is the theme; than we can possibly help you debug where the problem is. It might even help to activate WP_DEBUG to see what problems might arise during the export.

    From your file I cannot see an error inside. So please let me know if another theme fixes the issues.

    kind regards.

    Thread Starter kerrydesigner

    (@kerrydesigner)

    Yes it worked after I swapped themes! This is the theme I’m using https://themeforest.net/item/salient-responsive-multipurpose-theme/4363266

    I can give you access to my WP if needed?

    Plugin Author Doeke Norg

    (@doekenorg)

    Do you have any custom hooks in the themes functions.php? Perhaps a space before the <?php open tag. Or after a ?> Close tag? Those can cause problems.

    Please connect with us through [email protected] to safely share your credentials if this isn’t the case. We have a secure method to be able to login to your site. Then please mention my name and this ticket, so I can find it easily in our support system. Thank you.

    Thread Starter kerrydesigner

    (@kerrydesigner)

    This is my functions file, I did add in the second one recently to tweak a WPMembers setting so it could be the issue?

    <?php
    
    add_action( 'wp_enqueue_scripts', 'salient_child_enqueue_styles', 100);
    
    function salient_child_enqueue_styles() {
    
        $nectar_theme_version = nectar_get_theme_version();
    
        wp_enqueue_style( 'salient-child-style', get_stylesheet_directory_uri() . '/style.css', '', $nectar_theme_version );
    
        if ( is_rtl() ) {
    
          wp_enqueue_style(  'salient-rtl',  get_template_directory_uri(). '/rtl.css', array(), '1', 'screen' );
    
        }
    
    }
    
    add_filter( 'wpmem_notify_addr', 'my_admin_email' );
    
    function my_admin_email( $email ) {
    
        // single email example
    
        $email = '[email protected]';
    
        // multiple emails example
    
        // $email = '[email protected], [email protected]';
    
        // take the default and append a second address to it example:
    
        // $email = $email . ', [email protected]';
    
        // return the result
    
        return $email;
    
    }
    
    ?>
    Plugin Author Doeke Norg

    (@doekenorg)

    Could you try removing the ?> From the file? That’s no longer needed for PHP and can cause problems.

    Thread Starter kerrydesigner

    (@kerrydesigner)

    That worked! Thanks so much

    Plugin Author Doeke Norg

    (@doekenorg)

    Awesome! Nice work!

    ringringhello

    (@ringringhello)

    Is anybody else experiencing the same issue? I’ve already checked the theme’s functions file and ensured that debug is false, but I’m still experiencing an issue with the Excel file. The CSV version is fine.

    Plugin Author Doeke Norg

    (@doekenorg)

    @ringringhello can you share a corrupted file with us?

    ringringhello

    (@ringringhello)

    Plugin Author Doeke Norg

    (@doekenorg)

    @ringringhello could you send the file to [email protected]? I cannot download the file from this URL, as it forces me to read it online ??

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Can’t open exported file – “corrupted”?’ is closed to new replies.