importing data UTF-8 problem

  • Resolved adriana1

    (@adriana1)


    6 years, 11 months ago

    Hi,

    I’ve tried to import csv table and if the data is in English, it’s ok. However when entities are in Cyrilic the imported data is only characters and symbols.
    What’s more if I don’t put check in front of Convert to UTF-8, no data is imported.
    Would you help me with that?

    PS I’ve checked the web options while saving the csv document and choose Unicode UTF-8 in Encoding section. however it didn’t help.

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Contributor WPManageNinja

    (@wpmanageninja)

    6 years, 11 months ago

    Hello @adriana1
    Did you tried to save the csv as MS-DOS format from excel / export as UTF-8 from your excel software. If your csv is Unicode format then it should work fine.

    Thanks

    Thread Starter adriana1

    (@adriana1)

    6 years, 11 months ago

    No, it dosn’t. I’ve already tried this and I’ve test it one more time but it’s the same problem.

    Plugin Contributor WPManageNinja

    (@wpmanageninja)

    6 years, 11 months ago

    Would you please email me the CSV at support [at] wpmanageninja.com

    So I can take a look

    smacksupport

    (@smacksupport)

    6 years, 11 months ago

    Hi @adriana1
    Try converting encode UTF-8 without BOM
    – Open the file you want to verify/fix in Notepad++
    – In the top menu select Encoding > Convert to UTF-8 (option without BOM)
    – Save the file.
    Post the results here

    Thread Starter adriana1

    (@adriana1)

    6 years, 11 months ago

    It works ok after encoding with Notepad ++. Thanks a lot!

    b17879

    (@b17879)

    6 years, 7 months ago

    I have been loading the csv files into the database with no problems.
    After the last ninjatables update I got problems with portuguese characteres. I am not able to import the data into the database already created.

    My file is a utf-8 file created by phyton and It is not working during de update into ninjatables.

    When I tried to load the data into the ninja database(clicking the bottom import) , the application tried to load with no success. (replace data)
    When I tried to create a new table with the same data, I receive the message undefined,
    att,
    Joao

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

The topic ‘importing data UTF-8 problem’ is closed to new replies.