[Plugin: WP-Table Reloaded] csv import accent

  • Resolved rcavalli

    (@rcavalli)


    13 years, 11 months 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

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

  • 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”.

    Plugin Author TobiasBg

    (@tobiasbg)

    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

    Thread Starter rcavalli

    (@rcavalli)

    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!!

    Thread Starter rcavalli

    (@rcavalli)

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[Plugin: WP-Table Reloaded] csv import accent’ is closed to new replies.