Import problem with utf8 CSV file

[PGI]

Hello,

I have a problem when I import a CSV file encoded in utf8.

I checked the encoding, everything is ok. However, when I import this file, the accented characters are wrong and the import does not work.

In images you will see that during the first two steps, the characters are displayed correctly in the preview but after that the import does not create any record ... and the result file does not conform to the initial data .

Do you have an idea to solve my problem please?

Thank you very much !

[tanya]

Hello
Check also the file by break row symbol (\r, \n, \r\n)

[PGI]

Hello,

After many tests, I found the solution to my problem.

My original file is a file created with Excel in utf8. To import it into EspoCRM, it is necessary to open the CSV file in an text editor and delete the unicode byte order mark (BOM).

EspoCRM could not do it automatically?

Thank you

PGI