A question about using a lookup values in Arabic language in kobo form

I had created a form that includes a select question that lookup data from an excel file depending on the value of another field. the CSV file includes data in Arabic language , I saved the csv excel file using UTF8 format, csv comma…
while I saved it as UTF8, in the form the choices that comes through the lookup from the excel file appeared as question marks "?? ??? " .
Is their a solution for this?

Welcome to the community, @safaa_alhourany! Did you try using the Arabic language in Unicode in your CSV file to see how it behaves?

1 Like

Could you test, please, if it would work well if you put the csv values in English.

1 Like

Thank you.
I saved the file as UTF 8 CSV, but it didn’t work.

Thank you, but the form is in Arabic. and the users are not English speakers.

@safaa_alhourany, I tested this at my end with the following:

  • XLSForm (normal)
  • CSV File (saved as CSV UTF-8 (Comma delimited) format)

In the survey tab of XLSForm:

In the choices tab of XLSForm:


In the CSV File:


So when collecting data, this is what I see:

Data entry screen as seen in Enketo: Unicode not supported

Data entry screen as seen in Collect Android App: Unicode supported

Reference XLSForm:

Pull Data (Multiple Condition) Cloned with Unocode CSV File.xlsx (9.6 KB)

Reference CSV File:

Codes.csv (419 Bytes)

So the conclusion at this point is that Enketo does not support Unicodes from the CSV file while the Collect Android App does support the same.

1 Like

Thank you so much.

1 Like