Issue translating language from Aggregate to .CSV

Hello,

I’m working to collect information related to water points in Cambodia and
was hoping to use ODK but have run into a language issue. The majority of
the field staff which will be collecting the data only read and write in
Khmer so, I’ve setup my ODK survey such that it can be filled out in both
English or Khmer. Both languages work fine when creating the survey in
excel and using ODK XLSForm tool to convert the form, both languages work
fine when collecting the data in the field on smart phones, both languages
work fine when viewing them on the ODK Aggregate, my issue comes when I try
to export from ODK Aggregate back into a .csv file. Basically the answers
which were given in Khmer come out as ????? (see attached file for
examples). Has anyone else experienced this issue and if so any tips for
how to work around this would be greatly appreciated.

Cheers,

Paul

ODK_Aggre_CSV.docx (189 KB)

Paul.

Excel is bad at Unicode.

See https://groups.google.com/d/msg/opendatakit/Xh4r6ibFKlE/RZz2E0N-mTQJ
for an answer.

Yaw

··· -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Thu, Mar 27, 2014 at 12:36 AM, Paul Conrad conradpn@gmail.com wrote:

Hello,

I'm working to collect information related to water points in Cambodia and
was hoping to use ODK but have run into a language issue. The majority of
the field staff which will be collecting the data only read and write in
Khmer so, I've setup my ODK survey such that it can be filled out in both
English or Khmer. Both languages work fine when creating the survey in
excel and using ODK XLSForm tool to convert the form, both languages work
fine when collecting the data in the field on smart phones, both languages
work fine when viewing them on the ODK Aggregate, my issue comes when I try
to export from ODK Aggregate back into a .csv file. Basically the answers
which were given in Khmer come out as ????? (see attached file for
examples). Has anyone else experienced this issue and if so any tips for
how to work around this would be greatly appreciated.

Cheers,

Paul

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Paul,
I think one way would be to use numeric code other than text to measure
administrative divisions. In your case, I actually strongly recommend you
do that way. You don't want to spend lots of time after survey trying to
correct text inputs.

You can make use of cascading select to facilitate the process.

Trung.

··· On Thursday, March 27, 2014 2:36:41 PM UTC+7, Paul Conrad wrote: > > Hello, > > I’m working to collect information related to water points in Cambodia and > was hoping to use ODK but have run into a language issue. The majority of > the field staff which will be collecting the data only read and write in > Khmer so, I’ve setup my ODK survey such that it can be filled out in both > English or Khmer. Both languages work fine when creating the survey in > excel and using ODK XLSForm tool to convert the form, both languages work > fine when collecting the data in the field on smart phones, both languages > work fine when viewing them on the ODK Aggregate, my issue comes when I try > to export from ODK Aggregate back into a .csv file. Basically the answers > which were given in Khmer come out as ????? (see attached file for > examples). Has anyone else experienced this issue and if so any tips for > how to work around this would be greatly appreciated. > > > > Cheers, > > Paul >

Hello,

I’m working to collect information related to water points
in Cambodia and was hoping to use ODK but have run into a language
issue. The majority of the field staff
which will be collecting the data only read and write in Khmer so, I’ve setup
my ODK survey such that it can be filled out in both English or Khmer. Both languages work fine when creating the
survey in excel and using ODK XLSForm tool to convert the form, both languages
work fine when collecting the data in the field on smart phones, both languages
work fine when viewing them on the ODK Aggregate, my issue comes when I try to export from ODK
Aggregate back into a .csv file.
Basically the answers which were given in Khmer come out as ????? (see attached file for examples). Has anyone else experienced this issue and if so any tips
for how to work around this would be greatly appreciated.

Cheers,

Paul

··· On Thursday, March 27, 2014 2:36:41 PM UTC+7, Paul Conrad wrote: