Bitrix24 Community

Support » Forum » CRM » Importing CSV not reading Portuguese Accents
Pages: 1
RSS
Importing CSV not reading Portuguese Accents, When I upload my CSV files, it reads the words without accents, but the accented ones doesn´t work.
Hey there guys,

I´ve been trying to upload my Excel files to the CRM, everything works fine, but the accented words (são paulo, brasília, etc.) doesn´t work.

Searching for solutions online, I´ve seen about chaning my Codification to UTF-8 and everything else. I´ve already done it, my Excel CSV is saved as UTF-8 and when I upload, I also choose UTF-8 on Bitrix CRM, but still doesn´t work.

I´m realy sad about this, everything was working so fine...

Thanks in advance, Lucas.
Lucas, there are probably other ways to do it, but I know this one works (see the pics).

1, use a ANSI encoded CSV text file (Notepad++ will show you the encoding)
2. configure lead import to use ISO-8859-1

Have fun!
Ronaldo
---
Ronaldo Radünz

Bitrix24 Gold Partner
http://www.radsolucoes.com.br
Quick and Easy, worked perfectly!

Thank you sir!
Pages: 1
2,000,000+
organizations
are already using Bitrix24