[Plugin: Contact Form 7 to Database Extension] Exporting Excel Data in Japanese Language

Resolved Mami
(@mami-inoue)

11 years, 10 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/

Viewing 6 replies - 1 through 6 (of 6 total)

ShunichiHONDA
(@shunichihonda)

11 years, 6 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.

kimipooh
(@kimipooh)

11 years, 6 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 .. (^^;

Plugin Author Michael Simpson
(@msimpson)

11 years, 6 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

kimipooh
(@kimipooh)

11 years, 6 months ago

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

kimipooh
(@kimipooh)

11 years, 5 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.

Plugin Author Michael Simpson
(@msimpson)

11 years, 5 months ago

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