Title: CSV Export Problem with Characterset Last modified: May 9, 2017 --- # CSV Export Problem with Characterset * Resolved [gustavoo](https://wordpress.org/support/users/gustavoo/) * (@gustavoo) * [9 years ago](https://wordpress.org/support/topic/csv-export-problem-with-characterset/) * 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](https://wordpress.org/support/users/jasongreen/) * (@jasongreen) * [9 years ago](https://wordpress.org/support/topic/csv-export-problem-with-characterset/#post-9122985) * Hi * In the plugin folder can you replace Admin.php with this updated version. * [https://drive.google.com/open?id=0Bwy8G0Xiy9l_Y2hqWDRmemVZaDA](https://drive.google.com/open?id=0Bwy8G0Xiy9l_Y2hqWDRmemVZaDA) * I’ve changed the character encoding so this should work. * Regards * Jason * [larissaleeper](https://wordpress.org/support/users/larissaleeper/) * (@larissaleeper) * [9 years ago](https://wordpress.org/support/topic/csv-export-problem-with-characterset/#post-9134165) * 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 `
Fatal error: 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 /home/truefoun/public_html/wp-includes/class-wp-query.php on line 1043
* Plugin Author [jasongreen](https://wordpress.org/support/users/jasongreen/) * (@jasongreen) * [9 years ago](https://wordpress.org/support/topic/csv-export-problem-with-characterset/#post-9134750) * [@larissaleeper](https://wordpress.org/support/users/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. * [larissaleeper](https://wordpress.org/support/users/larissaleeper/) * (@larissaleeper) * [9 years ago](https://wordpress.org/support/topic/csv-export-problem-with-characterset/#post-9134894) * 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 * [larissaleeper](https://wordpress.org/support/users/larissaleeper/) * (@larissaleeper) * [9 years ago](https://wordpress.org/support/topic/csv-export-problem-with-characterset/#post-9143338) * Just wondering if you saw this response? Any further help??? 🙁 THANKS! * [pablodonosor](https://wordpress.org/support/users/pablodonosor/) * (@pablodonosor) * [8 years, 11 months ago](https://wordpress.org/support/topic/csv-export-problem-with-characterset/#post-9238208) * 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](https://wordpress.org/support/users/gustavoo/) * (@gustavoo) * [8 years, 11 months ago](https://wordpress.org/support/topic/csv-export-problem-with-characterset/#post-9251265) * Hi, Same problem for me 😀 File does not exist. would you please re-upload it? Thanks in advance. * [David Seveloff](https://wordpress.org/support/users/davsev/) * (@davsev) * [8 years, 10 months ago](https://wordpress.org/support/topic/csv-export-problem-with-characterset/#post-9349618) * 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⌉⌊2017-07-25_1527⌉[ * [larissaleeper](https://wordpress.org/support/users/larissaleeper/) * (@larissaleeper) * [8 years, 10 months ago](https://wordpress.org/support/topic/csv-export-problem-with-characterset/#post-9349797) * I never got it solved, I had to use a different plugin, Flamingo. * Plugin Author [jasongreen](https://wordpress.org/support/users/jasongreen/) * (@jasongreen) * [8 years, 10 months ago](https://wordpress.org/support/topic/csv-export-problem-with-characterset/#post-9355326) * 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. * [David Seveloff](https://wordpress.org/support/users/davsev/) * (@davsev) * [8 years, 10 months ago](https://wordpress.org/support/topic/csv-export-problem-with-characterset/#post-9356039) * 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. * ![](https://s.w.org/plugins/geopattern-icon/contact-form-submissions_181c39.svg) * [Contact Form Submissions](https://wordpress.org/plugins/contact-form-submissions/) * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-submissions/#faq) * [Support Threads](https://wordpress.org/support/plugin/contact-form-submissions/) * [Active Topics](https://wordpress.org/support/plugin/contact-form-submissions/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-submissions/unresolved/) * [Reviews](https://wordpress.org/support/plugin/contact-form-submissions/reviews/) * 12 replies * 5 participants * Last reply from: [David Seveloff](https://wordpress.org/support/users/davsev/) * Last activity: [8 years, 10 months ago](https://wordpress.org/support/topic/csv-export-problem-with-characterset/#post-9356039) * Status: resolved