WordPress.org

Ready to get started?Download WordPress

Forums

WP-Table Reloaded
[resolved] csv import accent (5 posts)

  1. rcavalli
    Member
    Posted 3 years ago #

    Hi,
    I'm here from Brazil, sorry my english is the translator.

    I am importing a table from csv, but our language uses accent. Thus the words with accents are so "�" (question mark)

    I wonder how the form of import you use, what function does this import, and if you give me a hint how to solve this.

    Att

    Rafael Cavalli

  2. e-sushi
    Member
    Posted 3 years ago #

    The "�" (question mark) you are seeing means that some file you are using along the way does not support UTF-8 correctly.

    You would have to open up the plugin files and make sure they are saved UTF-8 and - if possible - without the BOM (Byte Order Mark) so PHP doesn't get confused.

    If you don't know what I mean, contact the plugin developer directly... he should be able to "correct the issue".

  3. TobiasBg
    Member
    Plugin Author

    Posted 3 years ago #

    Hi,

    thanks for your question, Rafael, and thanks for the explanation, e-sushi.

    Yes indeed, this is a problem with different character encodings. Unfortunately, however, I have not yet been able to resolve this satisfactorily.
    It seems that somewhere between the import process of the CSV file (for which I use an external PHP library) and the saving to the database (which happens in a "serialized" string), the character encoding gets broken, so that special characters (like accents) are not shown correctly.

    The only workarounds that I'm currently aware of are to manually save the file again in different character encodings and try with those (this is what e-sushi describes, and you can for example do it with Notepad and "Save as" there).
    A different solution (which requires more work) is to manually fix all characters that are broken after the import.

    If someone knows a permanent solution (or can even find the necessary steps to fix this in the plugin code), I'd really be happy to hear it!

    Best wishes,
    Tobias

  4. rcavalli
    Member
    Posted 3 years ago #

    I saved the csv file manually to UTF8 encoding, and thus the problem did not occur.
    anyway thanks and congratulations for the plugin ... is great!!

  5. rcavalli
    Member
    Posted 3 years ago #

    I think the editor I was saving the file to use with other encoding and did not realize it.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic