my problem is that the resulted Excel sheet(result database ) is not
supported Arabic m so how can I solve this problem?
Azza,
Until you can provide step by step directions for the community to
reproduce the problem, it'll be hard for us to help. For example, you
do not mention what ODK tools you are using. XLSForm, Aggregate,
Briefcase, and Tables all use Excel.
Yaw
···
-- Need ODK help? Go to http://nafundi.com for custom features, form design, implementation support, and user training for ODK.On Sun, Jun 30, 2013 at 11:47 AM, Azza Hayek hardluck14@gmail.com wrote:
my problem is that the resulted Excel sheet(result database ) is not
supported Arabic m so how can I solve this problem?--
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/groups/opt_out.
Hi Yaw,
first of all , i use XLSForm to build the form ,then convert it to XForm
,and then upload it to the aggregate server(Google appengine), get the form
to data collect app.
Then send the finalized form to the server ,then export it as xls file .
بتاريخ الأحد، 30 يونيو، 2013 UTC+3 9:47:12 م، كتب Azza Hayek:
···
> > my problem is that the resulted Excel sheet(result database ) is not > supported Arabic m so how can I solve this problem? > > >بتاريخ الاثنين، 1 يوليو، 2013 UTC+3 3:37:00 م، كتب Azza Hayek:
Hi Yaw,
first of all , i use XLSForm to build the form ,then convert it to XForm
,and then upload it to the aggregate server(Google appengine), get the form
to data collect app.
Then send the finalized form to the server ,then export it as xls file .
the data entry will be in arabic so we fill the form in arabic language ,
so in the result xls file the arabic text apears like this(????????)
so how can i solve that problem?
بتاريخ الأحد، 30 يونيو، 2013 UTC+3 9:47:12 م، كتب Azza Hayek:
my problem is that the resulted Excel sheet(result database ) is not
supported Arabic m so how can I solve this problem?
بتاريخ الأحد، 30 يونيو، 2013 UTC+3 9:47:12 م، كتب Azza Hayek:
···
> > my problem is that the resulted Excel sheet(result database ) is not > supported Arabic m so how can I solve this problem? > > >بتاريخ الأحد، 30 يونيو، 2013 UTC+3 9:47:12 م، كتب Azza Hayek:
need_ass_odk_results (3).csv (855 Bytes)
···
> > my problem is that the resulted Excel sheet(result database ) is not > supported Arabic m so how can I solve this problem? > > >hi mitch
i can share my form and dataset m i hop u can fine the solution
بتاريخ الأحد، 30 يونيو، 2013 UTC+3 9:47:12 م، كتب Azza Hayek:
hasan.xml (9.21 KB)
hasan_results.csv (1.1 KB)
···
> > my problem is that the resulted Excel sheet(result database ) is not > supported Arabic m so how can I solve this problem? > > >Azza,
Does the data show up in in Arabic when you view it in ODK Aggregate?
And what happens if you open the CSV in a modern text editor at that
supports UTF-8? Does that work?
Yaw
···
-- Need ODK help? Go to http://nafundi.com for custom features, form design, implementation support, and user training for ODK.On Mon, Jul 1, 2013 at 5:45 AM, Azza Hayek hardluck14@gmail.com wrote:
بتاريخ الاثنين، 1 يوليو، 2013 UTC+3 3:37:00 م، كتب Azza Hayek:
Hi Yaw,
first of all , i use XLSForm to build the form ,then convert it to XForm
,and then upload it to the aggregate server(Google appengine), get the form
to data collect app.
Then send the finalized form to the server ,then export it as xls file .the data entry will be in arabic so we fill the form in arabic language , so
in the result xls file the arabic text apears like this(????????)so how can i solve that problem?
بتاريخ الأحد، 30 يونيو، 2013 UTC+3 9:47:12 م، كتب Azza Hayek:
my problem is that the resulted Excel sheet(result database ) is not
supported Arabic m so how can I solve this problem?بتاريخ الأحد، 30 يونيو، 2013 UTC+3 9:47:12 م، كتب Azza Hayek:
my problem is that the resulted Excel sheet(result database ) is not
supported Arabic m so how can I solve this problem?--
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/groups/opt_out.
Azza,
I'm assuming you are using the ODK Aggregate VM? If so, there might be
an issue with non-ASCII characters. Have you tried exporting your
Arabic form on a copy of Aggregate running on Google App Engine?
Yaw
···
-- Need ODK help? Go to http://nafundi.com for custom features, form design, implementation support, and user training for ODK.On Mon, Jul 1, 2013 at 9:58 AM, Azza Hayek hardluck14@gmail.com wrote:
بتاريخ الأحد، 30 يونيو، 2013 UTC+3 9:47:12 م، كتب Azza Hayek:
my problem is that the resulted Excel sheet(result database ) is not
supported Arabic m so how can I solve this problem?--
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/groups/opt_out.
Hi Azza,
Can you provide me with a ZIP of the contents of the /odk directory on your
phone.
Alternatively, if you have an ODK Aggregate instance set up, can you invite
me ( mitchellsundt@gmail.com ) as a developer and add me with Form Manager
permissions on that instance?
http://code.google.com/p/opendatakit/wiki/AppEngineTroubleshooting
Mitch
···
On Tue, Jul 2, 2013 at 2:40 PM, Azza Hayek wrote:hi mitch
i can share my form and dataset m i hop u can fine the solutionبتاريخ الأحد، 30 يونيو، 2013 UTC+3 9:47:12 م، كتب Azza Hayek:
my problem is that the resulted Excel sheet(result database ) is not
supported Arabic m so how can I solve this problem?--
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/groups/opt_out.
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com
Yaw..
yes in the ODK Aggregate it appears normally arabic letters , and i tried
to open it by notepad++ which i think it support UTF-8 but it didn't work
بتاريخ الاثنين، 1 يوليو، 2013 UTC+3 4:46:54 م، كتب Yaw Anokwa:
···
> > Azza, > > Does the data show up in in Arabic when you view it in ODK Aggregate? > And what happens if you open the CSV in a modern text editor at that > supports UTF-8? Does that work? > > Yaw > -- > Need ODK help? Go to http://nafundi.com for custom features, form > design, implementation support, and user training for ODK. > > On Mon, Jul 1, 2013 at 5:45 AM, Azza Hayek <hardl...@gmail.com> wrote: > > > > > > بتاريخ الاثنين، 1 يوليو، 2013 UTC+3 3:37:00 م، كتب Azza Hayek: > >> > >> Hi Yaw, > >> first of all , i use XLSForm to build the form ,then convert it to > XForm > >> ,and then upload it to the aggregate server(Google appengine), get the > form > >> to data collect app. > >> Then send the finalized form to the server ,then export it as xls file > . > > > > the data entry will be in arabic so we fill the form in arabic language > , so > > in the result xls file the arabic text apears like this(????????) > > > > so how can i solve that problem? > >> > >> بتاريخ الأحد، 30 يونيو، 2013 UTC+3 9:47:12 م، كتب Azza Hayek: > >>> > >>> my problem is that the resulted Excel sheet(result database ) is not > >>> supported Arabic m so how can I solve this problem? > >>> > >>> > > > > > > بتاريخ الأحد، 30 يونيو، 2013 UTC+3 9:47:12 م، كتب Azza Hayek: > >> > >> my problem is that the resulted Excel sheet(result database ) is not > >> supported Arabic m so how can I solve this problem? > >> > >> > > > > -- > > -- > > Post: opend...@googlegroups.com > > Unsubscribe: opendatakit...@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...@googlegroups.com . > > For more options, visit https://groups.google.com/groups/opt_out. > > > > >i am already working on Google App Engine , not ODK Aggregate VM, do you
think if i use the VM may the problem be solved?
بتاريخ الثلاثاء، 2 يوليو، 2013 UTC+3 1:14:15 ص، كتب Yaw Anokwa:
···
> > Azza, > > I'm assuming you are using the ODK Aggregate VM? If so, there might be > an issue with non-ASCII characters. Have you tried exporting your > Arabic form on a copy of Aggregate running on Google App Engine? > > Yaw > -- > Need ODK help? Go to http://nafundi.com for custom features, form > design, implementation support, and user training for ODK. > > On Mon, Jul 1, 2013 at 9:58 AM, Azza Hayek <hardl...@gmail.com> wrote: > > > > > > بتاريخ الأحد، 30 يونيو، 2013 UTC+3 9:47:12 م، كتب Azza Hayek: > >> > >> my problem is that the resulted Excel sheet(result database ) is not > >> supported Arabic m so how can I solve this problem? > >> > >> > > > > -- > > -- > > Post: opend...@googlegroups.com > > Unsubscribe: opendatakit...@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...@googlegroups.com . > > For more options, visit https://groups.google.com/groups/opt_out. > > > > >(I suspect the csv file has been corrupted by Microsoft Excel.)
···
On Mon, Jul 15, 2013 at 4:21 PM, Mitch Sundt wrote:Hi Azza,
Can you provide me with a ZIP of the contents of the /odk directory on
your phone.Alternatively, if you have an ODK Aggregate instance set up, can you
invite me ( mitchellsundt@gmail.com ) as a developer and add me with Form
Manager permissions on that instance?
http://code.google.com/p/opendatakit/wiki/AppEngineTroubleshootingMitch
On Tue, Jul 2, 2013 at 2:40 PM, Azza Hayek hardluck14@gmail.com wrote:
hi mitch
i can share my form and dataset m i hop u can fine the solutionبتاريخ الأحد، 30 يونيو، 2013 UTC+3 9:47:12 م، كتب Azza Hayek:
my problem is that the resulted Excel sheet(result database ) is not
supported Arabic m so how can I solve this problem?--
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/groups/opt_out.--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com
Azza,
Send me a copy of the CSV directly and I can take a look.
Yaw
···
-- Need ODK help? Go to http://nafundi.com for custom features, form design, implementation support, and user training for ODK.On Mon, Jul 1, 2013 at 9:44 AM, Azza Hayek hardluck14@gmail.com wrote:
Yaw..
yes in the ODK Aggregate it appears normally arabic letters , and i tried to
open it by notepad++ which i think it support UTF-8 but it didn't workبتاريخ الاثنين، 1 يوليو، 2013 UTC+3 4:46:54 م، كتب Yaw Anokwa:
Azza,
Does the data show up in in Arabic when you view it in ODK Aggregate?
And what happens if you open the CSV in a modern text editor at that
supports UTF-8? Does that work?Yaw
Need ODK help? Go to http://nafundi.com for custom features, form
design, implementation support, and user training for ODK.On Mon, Jul 1, 2013 at 5:45 AM, Azza Hayek hardl...@gmail.com wrote:
بتاريخ الاثنين، 1 يوليو، 2013 UTC+3 3:37:00 م، كتب Azza Hayek:
Hi Yaw,
first of all , i use XLSForm to build the form ,then convert it to
XForm
,and then upload it to the aggregate server(Google appengine), get the
form
to data collect app.
Then send the finalized form to the server ,then export it as xls file
.the data entry will be in arabic so we fill the form in arabic language
, so
in the result xls file the arabic text apears like this(????????)so how can i solve that problem?
بتاريخ الأحد، 30 يونيو، 2013 UTC+3 9:47:12 م، كتب Azza Hayek:
my problem is that the resulted Excel sheet(result database ) is not
supported Arabic m so how can I solve this problem?بتاريخ الأحد، 30 يونيو، 2013 UTC+3 9:47:12 م، كتب Azza Hayek:
my problem is that the resulted Excel sheet(result database ) is not
supported Arabic m so how can I solve this problem?--
Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@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...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.--
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/groups/opt_out.
Azza,
If it's not working on GAE, then it's a bug in Aggregate. I've filed a
report at https://code.google.com/p/opendatakit/issues/detail?id=863.
Please star that issue to get updates.
Yaw
···
-- Need ODK help? Go to http://nafundi.com for custom features, form design, implementation support, and user training for ODK.On Mon, Jul 1, 2013 at 10:08 PM, Azza Hayek hardluck14@gmail.com wrote:
i am already working on Google App Engine , not ODK Aggregate VM, do you
think if i use the VM may the problem be solved?بتاريخ الثلاثاء، 2 يوليو، 2013 UTC+3 1:14:15 ص، كتب Yaw Anokwa:
Azza,
I'm assuming you are using the ODK Aggregate VM? If so, there might be
an issue with non-ASCII characters. Have you tried exporting your
Arabic form on a copy of Aggregate running on Google App Engine?Yaw
Need ODK help? Go to http://nafundi.com for custom features, form
design, implementation support, and user training for ODK.On Mon, Jul 1, 2013 at 9:58 AM, Azza Hayek hardl...@gmail.com wrote:
بتاريخ الأحد، 30 يونيو، 2013 UTC+3 9:47:12 م، كتب Azza Hayek:
my problem is that the resulted Excel sheet(result database ) is not
supported Arabic m so how can I solve this problem?--
Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@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...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.--
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/groups/opt_out.
Hi Mitch, how did you manage to resolve this issue? I'm experiencing the same thing with some input Arabic text displaying as "راىؤلةؤلىؤلىؤلى" in Excel once the data is exported.
I need a dataset to work with.
If your form and collected data cannot be shared with me, please create a
simple sample form with arabic, download, fill out a few submissions, and
submit them to your ODK Aggregate instance.
Then, please use ODK Briefcase to pull your form (or the simple sample form
with arabic) to your PC (be sure to specify a new ODK Briefcase Storage
location if the original data cannot be shared with me), then zip up the
ODK Briefcase Storage location directory tree and send that to me (
mitchellsundt@gmail.com ).
Thanks,
Mitch
···
On Mon, Jul 1, 2013 at 10:49 PM, Yaw Anokwa wrote:Azza,
If it's not working on GAE, then it's a bug in Aggregate. I've filed a
report at https://code.google.com/p/opendatakit/issues/detail?id=863.
Please star that issue to get updates.Yaw
Need ODK help? Go to http://nafundi.com for custom features, form
design, implementation support, and user training for ODK.On Mon, Jul 1, 2013 at 10:08 PM, Azza Hayek hardluck14@gmail.com wrote:
i am already working on Google App Engine , not ODK Aggregate VM, do you
think if i use the VM may the problem be solved?بتاريخ الثلاثاء، 2 يوليو، 2013 UTC+3 1:14:15 ص، كتب Yaw Anokwa:
Azza,
I'm assuming you are using the ODK Aggregate VM? If so, there might be
an issue with non-ASCII characters. Have you tried exporting your
Arabic form on a copy of Aggregate running on Google App Engine?Yaw
Need ODK help? Go to http://nafundi.com for custom features, form
design, implementation support, and user training for ODK.On Mon, Jul 1, 2013 at 9:58 AM, Azza Hayek hardl...@gmail.com wrote:
بتاريخ الأحد، 30 يونيو، 2013 UTC+3 9:47:12 م، كتب Azza Hayek:
my problem is that the resulted Excel sheet(result database ) is not
supported Arabic m so how can I solve this problem?--
Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@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...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.--
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/groups/opt_out.--
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/groups/opt_out.
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com
Excel is terrible at importing CSVs with Unicode characters. Try the
following...
- Open Excel
- Import the data using Data-->Import External Data --> Import Data
- Select the file type of "csv" and browse to your file
- In the import wizard change the File_Origin to "65001 UTF" (or
choose correct language character identifier) - Change the Delimiter to comma
More at http://stackoverflow.com/a/6488070 and
http://office.microsoft.com/en-us/outlook-help/choose-text-encoding-when-you-open-and-save-files-HA010121249.aspx
Yaw
···
-- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.On Sun, Mar 9, 2014 at 7:18 AM, sabreen.alikhan@gmail.com wrote:
Hi Mitch, how did you manage to resolve this issue? I'm experiencing the same thing with some input Arabic text displaying as "راىؤلةؤلىؤلىؤلى" in Excel once the data is exported.
--
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.
1 Like
thanks
it work good for me .
Thank you very yanokwa, your instruction worked for me and it already supports the Arabic language.
2 Likes