WordPress.org

Ready to get started?Download WordPress

Forums

Contact Form DB
[resolved] [Plugin: Contact Form 7 to Database Extension] Exporting Excel Data in Japanese Language (7 posts)

  1. Mami
    Member
    Posted 2 years 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 1 year 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 1 year 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 1 year 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 1 year ago #

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

  6. kimipooh
    Member
    Posted 1 year 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 1 year ago #

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

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic