I have a list of items saved into CSV file like this:
barcode english_item arabic_item
I have an odk form which reads the barcode and shows the list of associated
items from CSV file, it works well for english items, but when I tried to
translate them into arabic, it didn't work at all, I opened the file in
notepad and saved it as UTF file. Afterwords, it shows the arabic letters,
but the odk couldn't read from csv file for both English and Arabic. I felt
that the csv file is corrupted when I converted to UTF using notepad. I
undo the changes, and left it as-is, but now it works for English, but for
arabic, it shows ????
I tried this way, I used notepad++, and got to show arabic words in CSV
file, but unfortunately the file didn't get recognized by ODK form, when it
tried to pull data from, it showed nothing, it must be something happened
to this file after this process.
···
On Sunday, October 11, 2015 at 2:02:15 PM UTC+3, Hanan Aqilan wrote:
>
> Hi,
>
> I have a list of items saved into CSV file like this:
>
> barcode english_item arabic_item
>
>
> I have an odk form which reads the barcode and shows the list of
> associated items from CSV file, it works well for english items, but when I
> tried to translate them into arabic, it didn't work at all, I opened the
> file in notepad and saved it as UTF file. Afterwords, it shows the arabic
> letters, but the odk couldn't read from csv file for both English and
> Arabic. I felt that the csv file is corrupted when I converted to UTF using
> notepad. I undo the changes, and left it as-is, but now it works for
> English, but for arabic, it shows ????
>
>
> Any thoughts on this.
>
>
> Regards, -Hanan
>
Your .csv file must be in UTF-8 format. I think that ODK Briefcase has a
converter that you can use to help you convert your existing file into that
format.
Best,
Chris
···
---
Christopher Robert
Dobility, Inc. (SurveyCTO)
http://www.surveycto.com/
http://blog.surveycto.com/
I have a list of items saved into CSV file like this:
barcode english_item arabic_item
I have an odk form which reads the barcode and shows the list of
associated items from CSV file, it works well for english items, but when I
tried to translate them into arabic, it didn't work at all, I opened the
file in notepad and saved it as UTF file. Afterwords, it shows the arabic
letters, but the odk couldn't read from csv file for both English and
Arabic. I felt that the csv file is corrupted when I converted to UTF using
notepad. I undo the changes, and left it as-is, but now it works for
English, but for arabic, it shows ????
The tool helps convert .csv files from one encoding to another, so it's
helpful for encoding in UTF-8, the format required on the Android side. As
for how well Arabic text is supported, that will depend on the device.
Best,
Chris
···
On Sun, Oct 11, 2015 at 8:43 AM Hanan Aqilan wrote:
Hi Chris,
Will this tool convert csv to make it recognize arabic letters? It has to
be in csv to be able to pull data from and connect it to the odk form.
1- Save your Excel as Unicode text(.txt) type
2- Open the Unicode text file
3- Replace the tab delimiter with comma (copy the space between two fields,
open replace window, paste the copied data and replace with ,)
4- Click save as
5- In the file name text box, Replace .txt extension with .csv
6- In save as window, you can see encoding type, change it to UTF-8
7- click save.
if you want to edit anything, apply it on the original Excel format and
then repeat the above steps again.
···
On 11 October 2015 at 14:10, Christopher Robert wrote:
Hanan,
Your .csv file must be in UTF-8 format. I think that ODK Briefcase has a
converter that you can use to help you convert your existing file into that
format.
I have a list of items saved into CSV file like this:
barcode english_item arabic_item
I have an odk form which reads the barcode and shows the list of
associated items from CSV file, it works well for english items, but when I
tried to translate them into arabic, it didn't work at all, I opened the
file in notepad and saved it as UTF file. Afterwords, it shows the arabic
letters, but the odk couldn't read from csv file for both English and
Arabic. I felt that the csv file is corrupted when I converted to UTF using
notepad. I undo the changes, and left it as-is, but now it works for
English, but for arabic, it shows ????
please see the attached files..I have no barcode or item to test, so i
created that simulation, go throught it slowly and test....ODK is very
sensitive ..so be carefull how to call function and name your fields. it is
compulsory that u add _key to your id in CSV. and always try to avoid use
name same as types...I m sorry i have to leave...good luck
···
On 11 October 2015 at 15:53, Christopher Robert wrote:
The tool helps convert .csv files from one encoding to another, so it's
helpful for encoding in UTF-8, the format required on the Android side. As
for how well Arabic text is supported, that will depend on the device.
···
On Sun, Oct 11, 2015 at 5:26 PM, Rofand K wrote:
please see the attached files..I have no barcode or item to test, so i
created that simulation, go throught it slowly and test....ODK is very
sensitive ..so be carefull how to call function and name your fields. it is
compulsory that u add _key to your id in CSV. and always try to avoid use
name same as types...I m sorry i have to leave...good luck
The tool helps convert .csv files from one encoding to another, so it's
helpful for encoding in UTF-8, the format required on the Android side. As
for how well Arabic text is supported, that will depend on the device.
