French characters (accent) displaying as symbols

Khaleelah
Khaleelah Customer
10 Comments Name Dropper Level 200: Building A Planning Solution in Board
in Platform

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

Answers

  • Dorra Ben Hmida
    Dorra Ben Hmida Employee
    10 Comments Level 300: Expanding Board in Your Organization Photogenic First Anniversary

    Hi @Khaleelah, are you using Board in french ?

  • Khaleelah
    Khaleelah Customer
    10 Comments Name Dropper Level 200: Building A Planning Solution in Board

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

  • Bettina Clausen
    Bettina Clausen Employee
    Fourth Anniversary 25 Up Votes 25 Likes 5 Answers

    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
    Dorra Ben Hmida Employee
    10 Comments Level 300: Expanding Board in Your Organization Photogenic First Anniversary
    edited September 3

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

  • Khaleelah
    Khaleelah Customer
    10 Comments Name Dropper Level 200: Building A Planning Solution in Board
    edited September 3

    Hi Friends,

    Uploading csv / json file through data reader

  • Dorra Ben Hmida
    Dorra Ben Hmida Employee
    10 Comments Level 300: Expanding Board in Your Organization Photogenic First Anniversary

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

    image.png

    here is my csv file type:

    image.png

    and the the file options of my Data Reader :

    image.png

    Could you please check these details ?

    Thanks.

  • Khaleelah
    Khaleelah Customer
    10 Comments Name Dropper Level 200: Building A Planning Solution in Board

    what if it is a json file?

  • Dorra Ben Hmida
    Dorra Ben Hmida Employee
    10 Comments Level 300: Expanding Board in Your Organization Photogenic First Anniversary

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

  • Khaleelah
    Khaleelah Customer
    10 Comments Name Dropper Level 200: Building A Planning Solution in Board

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

    image.png

  • Lucas Charello
    Lucas Charello Active Partner, Community Captain
    25 Likes 10 Comments 25 Up Votes Year 2 Community Captain

    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
    Khaleelah Customer
    10 Comments Name Dropper Level 200: Building A Planning Solution in Board

    Hi Lucas,

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

    Thanks for your reply.

    Rgds

    Khaleelah

Categories