CSV Export Problem with Characterset

  • Resolved gustavoo

    (@gustavoo)


    7 years, 10 months ago

    Hi,

    First of thank you for such an easy to use plugin. I have a little problem with export CSV. When I export, the file that I get has a wrong characterset so the file is not read able. I think export is not set to UTF-8 characterset. Because the submissions are shown ok in dashbord but the export has problems.

    Cheers.

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author jasongreen

    (@jasongreen)

    Hi

    In the plugin folder can you replace Admin.php with this updated version.

    https://drive.google.com/open?id=0Bwy8G0Xiy9l_Y2hqWDRmemVZaDA

    I’ve changed the character encoding so this should work.

    Regards

    Jason

    I am having the same weird output issues. This client has had 180 submissions and I need to export!!!

    I replaced the Admin.php with the one you provided above and no change. Please help, I sincerely appreciate it!

    Output exaample below
    `<br />
    <b>Fatal error</b>: Uncaught exception ‘Exception’ with message ‘Serialization of ‘Closure’ is not allowed’ in /home/truefoun/public_html/wp-includes/class-wp-query.php:1043
    Stack trace:
    #0 [internal function]: SplDoublyLinkedList->serialize()
    #1 /home/truefoun/public_html/wp-includes/class-wp-query.php(1043): serialize(Array)
    #2 /home/truefoun/public_html/wp-includes/class-wp-query.php(1668): WP_Query->parse_query()
    #3 /home/truefoun/public_html/wp-includes/class-wp-query.php(3238): WP_Query->get_posts()
    #4 /home/truefoun/public_html/wp-includes/post.php(1689): WP_Query->query(Array)
    #5 /home/truefoun/public_html/wp-content/plugins/contact-form-submissions/Admin.php(449): get_posts(Array)
    #6 [internal function]: WPCF7SAdmin->export_request(Object(WP))
    #7 /home/truefoun/public_html/wp-includes/class-wp-hook.php(298): call_user_func_array(Array Array)
    #8 /home/truefoun/public_html/wp-includes/class-wp-hook.php(323): WP_Hook->apply_filters(” Array)
    #9 /home/truefoun/public_html/wp-includes/plugin.php(515): WP_Hook->do_action(Ar in <b>/home/truefoun/public_html/wp-includes/class-wp-query.php</b> on line <b>1043</b><br />

    Plugin Author jasongreen

    (@jasongreen)

    @larissaleeper – This is a different issue. What king of data do you have in your contact forms? Looks like there might be some characters which are breaking.

    I have html surrounding the CF7 elements. so the form would look nice. But, when I look at the submissions they are in there separated by form field, so it is reading it right. it is just the export that’s weird.

    do u think recaptcha is the problem maybe?

    Thanks

    Just wondering if you saw this response? Any further help??? ?? THANKS!

    Please, Jason could you please put again the Admin.php link with the updated version? The one you posted earlier is not working. Thanks a lot!

    Pablo

    Thread Starter gustavoo

    (@gustavoo)

    Hi,
    Same problem for me ??
    File does not exist. would you please re-upload it?
    Thanks in advance.

    Same problem here, the answers are in hebrew, when I export the data to a csv file I get gibrish… you can see print screen here, I downloaded the plugin two days ago so I am pretty sure it is up to date (ver 1.5.6 ).

    2017-07-25_1527

    I never got it solved, I had to use a different plugin, Flamingo.

    Plugin Author jasongreen

    (@jasongreen)

    Hi All

    Sorry I missed this thread.

    I’m currently working on a fix for character encoding and hope to have a new version out with a fix in the next couple of days.

    I changed the encoding from utf-16le to utf-8 in the three instances at the admin.php file. than opened the file via google sheets and I see the Hebrew text as it should be.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘CSV Export Problem with Characterset’ is closed to new replies.