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

User Support Form Building
, , , ,
1

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?

2

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

3

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

4

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

5

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

6

@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:

image
image885×209 11.9 KB

In the choices tab of XLSForm:

image
image268×153 3.37 KB

In the CSV File:

image
image341×272 5.12 KB

So when collecting data, this is what I see:

Data entry screen as seen in Enketo: Unicode not supported

Enketo
Enketo588×632 17.1 KB

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

Collect Android App
Collect Android App720×1443 44.1 KB

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.

7

Thank you so much.