French characters (accent) displaying as symbols

Khaleelah

Hello Friends,

We are currently facing issues with uploading of data which french accent caracters

1. Cedilla (ç)
2. Acute accent (é)
3. Circumflex (â, ê, î, ô, û)
4. Grave accent (à, è, ù)
5. Trema (ë, ï, ü)

The accents are converted into strange symbols which should not be the case.

How do we overcome this issue.

Thanks

Dorra Ben Hmida

Hi @Khaleelah, are you using Board in french ?

Khaleelah

No we are not but we have both data french and english

Bettina Clausen

Hi,

are you loading from txt files? If so did you check the encoding of the file itself and the setting in the datareader?

Kind regards,
Bettina

Dorra Ben Hmida

Hi @Khaleelah, how are you uploading your data ? is it by the smart import feature ?

Khaleelah

Hi Friends,

Uploading csv / json file through data reader

Dorra Ben Hmida

Hi @Khaleelah , I've tested with the example below and it works correctly :

here is my csv file type:

and the the file options of my Data Reader :

Could you please check these details ?

Thanks.

Khaleelah

what if it is a json file?

Dorra Ben Hmida

as far as I know, json file can not be read

Khaleelah

Its a call from an API, so the response is Json. But the result is being saved in CSV format.

Lucas Charello

Hello Khaleelah, I also work in French. You may try to modify the data encoding from utf-8 to Windows-1252 and see what you get. It already helped me a lot!

I hope that helps.

Best regards,

Lucas Charello

Khaleelah

Hi Lucas,

Exactly the problem was with the encoding. Now its working.

Thanks for your reply.

Rgds

Khaleelah