ODK Briefcase non-latin or arabic letters parsed as symbols

Hello All!

Thank you in advance, please find below the answers to the questions you asked

  1. What is the problem? Be very detailed: I designed a survey but accidentally put a "note" as mandatory and therefore it will not save and therefore will not upload to the KOBO server. Instead I used ODK Briefcase to extract the data but as there are responses in Arabic (i.e. non latin letters) the result is symbols (for example: غربي جامع عمر بن الخطاب) How can I extract the correct format for the Arabic input?

  2. What app or server are you using and on what device and operating system? Include version numbers: KOBO Collect, ODK Briefcase 1.14.0 On Windows OS.

  3. What you have you tried to fix the problem?: Looking into new versions of ODK Briefcase and other posts on this thread

  4. What steps can we take to reproduce the problem?: Any arabic text input in surveys inputed on KOBO Collect extracted on ODK Briefcase 1.14.0 On windows.

Best regards,
Anwar

Solution found.

Use these steps to open the CSV. File in excel to get the non latin letters right :slight_smile:
https://www.itg.ias.edu/content/how-import-csv-file-uses-utf-8-character-encoding-0

Note that when asked, use "delimited" and then "comma".

Best,
Your friendly Neighborhood MEAL Manager

2 Likes