Problem Encoding German Language (Survey Import) | XM Community
Skip to main content
Michael_Cooksey
Administrator
25 days ago
Solved

Problem Encoding German Language (Survey Import)

  • September 17, 2019
  • 2 replies
  • 21 views
P
Dear Community, currently we are migrating our surveys into Qualtrics. Therefore we mostly use the "import" function via txt file. Unfortunately, when we upload the txt files into Qualtrics, it has a problem encoding the German language. Instead of many German letters, you get Chinese (?) characters (e.g. "舅" for "än" or "ﾜ" for "Ü"). Did anyone already face that kind of problem and has a solution for it? It is very annoying and error-prone to go through the Survey again and fix these mistakes all manually. Thanks in advance for your help!

Best answer by KendraR

Hi, @PatX! It looks like you were able to reach out to our Support Team and they were able to offer you the following workflow to avoid misrepresented characters: 1. Download the translation from Qualtrics as a CSV or TSV file 2. Plug in the translations 3. Select All > Copy All 4. Go to Google Sheets and open an Excel sheet 5. Paste All 6. Save the Excel sheet as a TSV 7. Upload the TSV into Qualtrics (without opening it first) For anyone else who needs assistance with this, please reach out to our Support Team! 😃
View original

    2 replies

    KendraR
    Qualtrics Employee
    Forum|alt.badge.img+11
    • KendraR
    • Qualtrics Employee
    • 167 replies
    • Answer
    • September 24, 2019
    Hi, @PatX! It looks like you were able to reach out to our Support Team and they were able to offer you the following workflow to avoid misrepresented characters: 1. Download the translation from Qualtrics as a CSV or TSV file 2. Plug in the translations 3. Select All > Copy All 4. Go to Google Sheets and open an Excel sheet 5. Paste All 6. Save the Excel sheet as a TSV 7. Upload the TSV into Qualtrics (without opening it first) For anyone else who needs assistance with this, please reach out to our Support Team! 😃
    JenCX
    P
    2 people like this
    • JenCX
      JenCX
    • P
      PatX
    P
    • PatX
    • Author
    • 1 reply
    • September 26, 2019
    Hello KendraR, you are right, this is exactly what the support team offered me as a solution. Unfortunately, this solution is less practicable for us. Since we are uploading surveys which are only in German, downloading the translation again, correcting all language mistakes and upload them again would be exactly as much work as just going through the survey and correcting all mistakes by hand. Nevertheless thanks again for your help.

    Leave a Reply


    Terms & Conditions