Mautic Community Forums

Not importing foreign characters

Having trouble importing Contacts with non US characters, i.e. German Umlauts öäü etc. via a csv file. Result is it cuts off Umlaut and every letter thereafter. Any advice?

Having trouble importing Contacts with non US characters, i.e. German Umlauts öäü etc. via a csv file. Result is it cuts off Umlaut and every letter thereafter. Any advice?

Make sure that the CSV file is in UTF8 encoding. Open Office Calc is great for setting the encoding.

Using Open Office to save in UTF8 worked and the import is now fine. I tried saving it in Excel on a Mac and Windows PC as a UTF8 CSV but nothing seemed to work. Open Office indeed did the job. Thanks.