WordPress.org

1. Mami
   Member
   Posted 11 months ago #
   

   Hello. I'm trying to export our clients' data that has been collected through Contact Form 7 into Excel. However, when I go to "database" and tried to export as "Excel CVS (UTF-BOM)", "Excel TSV (UTF16LE-BOM)" or "Excel CVS (UTF-8), all the excel sheets exported have incorrect, unreadable characters due to character encoding issue.

   Is there any way to fix this?
   Any help is much appreciated!

   http://wordpress.org/extend/plugins/contact-form-7-to-database-extension/

2. ShunichiHONDA
   Member
   Posted 7 months ago #
   

   Japanese Excel tries to read it in Shift-JIS.
   So, you need to change your CSV file to Shift-JIS encoding or other types that can be read in Japanese Excel.

   This link might be helpful (it in Japanese)
   http://d.hatena.ne.jp/replication/20100211/1266232291

   This reply must be way too late.. though, I write for forum archives.
   I hope you have solved the case.

3. kimipooh
   Member
   Posted 7 months ago #
   

   I could actualize by customizing this plugin.

   * How to customize this plugin:
   - http://kitaney.jp/~kitani/tools/wordpress/sources/contact-form-7-to-database-extension-japanese-contomized.txt

   * Code
   http://kitaney.jp/~kitani/tools/wordpress/index.html#3 (Sorry in Japanese)
   1. Install contact-form-7-to-database-extension-with-japanese-encoding
   2. Deactivate contact-form-7-to-database-extension
   3. Activate contact-form-7-to-database-extension-with-japanese-encoding

   When the plugin is updated, the customized plugin needs to be re-customized.
   Therefor, I hope that it will be embed to this plugin .. (^^;

4. Michael Simpson
   Member
   Plugin Author
   Posted 7 months ago #
   

   Nice work. I incorporated your changes with slight modification in my code but I have not released it. If I send you a copy of this version, would you mind testing it for me to ensure it works properly?

   Email me at info@simpson-software-studio.com

5. kimipooh
   Member
   Posted 7 months ago #
   

   Hi. Michael.
   Yes, I can test it. I sent the e-mail message.

6. kimipooh
   Member
   Posted 6 months ago #
   

   Basically, this issue was resolved by version 2.4.3 released on Nov 4, 2012.
   Thank you for responding my request, Michael-san.

7. Michael Simpson
   Member
   Plugin Author
   Posted 6 months ago #
   

   Thank you for giving me the code to make it work.

Reply

You must log in to post.