Mongodb does not accept text with accents when importing from CSV

[Richard_Navarro]

Mongodb (Compass) does not detect the data type when a text has an accent and the CSV import stops.

If the accent is removed from “Vacío” in row 2, the import proceeds without any problem.

If the accented text is created on the database, there is no problem.

Is there any way to import a CSV file that even has an accent or special character in text or column names?

[Massimiliano_Marcon]

@Richard_Navarro could you please share the file you are trying to import?

[Richard_Navarro]

@Massimiliano_Marcon :PruebaMongo2.csv - Google Drive

Thank you

[Le_Roux_Bodenstein]

Thank you Richard

That file is not valid utf8. The error is supposed to show up in the UI and it doesn’t. I’ll file a ticket for that.

But import only supports files encoded as utf8 which would be why it doesn’t work.

[Richard_Navarro]

Thank you, i will check how to change this in the excel.

It worked!