Can't convert from xls to xform

Hi there,

I try to convert from XLS to XFORM in http://opendatakit.org/xiframe/, but
I got the error like this.

Environment:

Request Method: POST
Request URL: http://23.21.114.69/xlsform/

Django Version: 1.4
Python Version: 2.6.5
Installed Applications:
('pyxform_interface',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.sites',
'django.contrib.messages',
'django.contrib.staticfiles')
Installed Middleware:
('django.middleware.common.CommonMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware')

Traceback:
File "/usr/local/lib/python2.6/dist-packages/django/core/handlers/base.py"
in get_response
111. response = callback(request, *callback_args,
**callback_kwargs)
File "/home/ubuntu/django/xlsform/xlsform/pyxform_interface/views.py" in
index
77. error = 'Error: ' + str(e)

Exception Type: UnicodeEncodeError at /
Exception Value: 'ascii' codec can't encode character u'\u200b' in position
36: ordinal not in range(128)

Is there any problem? Please see the attached file of my XLS form. Thanks
so much for your support.

Best regards,
Chan Choth

Program_Indicators_MS_Final.xls (48 KB)

Somehow, you have special characters in your Excel spreadsheet that look
like an underscore, but are not.

Attached is a corrected version of the spreadsheet.

This had a fascinating failure report. The error referred to a problem near
"e] HP_message" in the text, so I searched for HP_message, and the
'underscores' near there were not findable by searching for _, so I copied
their value into the Find box, and put _ in the replace box, and did a
global replace, causing about 4-5 of replacements. After that, everything
worked.

Program_Indicators_MS_Final.xls (48 KB)

··· On Sun, Jan 4, 2015 at 8:07 PM, Chan Choth wrote:

Hi there,

I try to convert from XLS to XFORM in http://opendatakit.org/xiframe/,
but I got the error like this.

Environment:

Request Method: POST
Request URL: http://23.21.114.69/xlsform/

Django Version: 1.4
Python Version: 2.6.5
Installed Applications:
('pyxform_interface',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.sites',
'django.contrib.messages',
'django.contrib.staticfiles')
Installed Middleware:
('django.middleware.common.CommonMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware')

Traceback:
File "/usr/local/lib/python2.6/dist-packages/django/core/handlers/base.py"
in get_response
111. response = callback(request,
*callback_args, **callback_kwargs)
File "/home/ubuntu/django/xlsform/xlsform/pyxform_interface/views.py" in
index
77. error = 'Error: ' + str(e)

Exception Type: UnicodeEncodeError at /
Exception Value: 'ascii' codec can't encode character u'\u200b' in
position 36: ordinal not in range(128)

Is there any problem? Please see the attached file of my XLS form. Thanks
so much for your support.

Best regards,
Chan Choth

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

-To be able to use a form on the android, it has to be uploaded on the server first
-After designing the questionnaire in excel document, convert it to XML format
-You can either download a file converter, or use an online converter (e.g zamzar.com) or convert in the ODK website by clicking on "XLSForm", then under the "Using the Application" heading, click the "on this page" link
-So, develop your questionnaire in excel, upload to server and then convert.

Sorry to resurrect such an old thread, but I wanted to see if there has
been any work on this. I know in this particular case it was a weird
underscore that could be replaced, but I'm getting similar errors:

'ascii' codec can't encode character u'\xc0' in position 0: ordinal not in
range (128)

when processing the external_choices tab using the xlsform.exe or pyxform
converters. This is character À, not a particularly unusual character. I
can process external csv files with the csv converter, but with this issue
I can't get the csv created when it comes from the external_choices tab.

We can work around this issue so it isn't an emergency or anything, but I
just wanted to check in on encoding the external_choices itemsets.csv file
as utf-8 instead of ascii in the converters.

Thanks
Jason

··· On Monday, January 5, 2015 at 3:12:04 PM UTC-5, Mitch Sundt wrote: > > Somehow, you have special characters in your Excel spreadsheet that look > like an underscore, but are not. > > Attached is a corrected version of the spreadsheet. > > This had a fascinating failure report. The error referred to a problem > near "e] HP_message" in the text, so I searched for HP_message, and the > 'underscores' near there were not findable by searching for _, so I copied > their value into the Find box, and put _ in the replace box, and did a > global replace, causing about 4-5 of replacements. After that, everything > worked. > > > On Sun, Jan 4, 2015 at 8:07 PM, Chan Choth <chan...@gmail.com > wrote: > >> Hi there, >> >> I try to convert from XLS to XFORM in http://opendatakit.org/xiframe/, >> but I got the error like this. >> >> Environment: >> >> >> Request Method: POST >> Request URL: http://23.21.114.69/xlsform/ >> >> Django Version: 1.4 >> Python Version: 2.6.5 >> Installed Applications: >> ('pyxform_interface', >> 'django.contrib.auth', >> 'django.contrib.contenttypes', >> 'django.contrib.sessions', >> 'django.contrib.sites', >> 'django.contrib.messages', >> 'django.contrib.staticfiles') >> Installed Middleware: >> ('django.middleware.common.CommonMiddleware', >> 'django.contrib.sessions.middleware.SessionMiddleware', >> 'django.contrib.auth.middleware.AuthenticationMiddleware', >> 'django.contrib.messages.middleware.MessageMiddleware') >> >> >> Traceback: >> File >> "/usr/local/lib/python2.6/dist-packages/django/core/handlers/base.py" in >> get_response >> 111. response = callback(request, >> *callback_args, **callback_kwargs) >> File "/home/ubuntu/django/xlsform/xlsform/pyxform_interface/views.py" in >> index >> 77. error = 'Error: ' + str(e) >> >> Exception Type: UnicodeEncodeError at / >> Exception Value: 'ascii' codec can't encode character u'\u200b' in >> position 36: ordinal not in range(128) >> >> Is there any problem? Please see the attached file of my XLS form. Thanks >> so much for your support. >> >> Best regards, >> Chan Choth >> >> -- >> -- >> 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/d/optout. >> > > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitche...@gmail.com >

This is generally correct, but zamzar.com will definitely NOT convert
from XLS to XForm.

https://opendatakit.org/use/xlsform/ lists the XLSForm converters you
should use.

Yaw

··· On Wed, Apr 26, 2017 at 3:04 AM, wrote: > -To be able to use a form on the android, it has to be uploaded on the server first > -After designing the questionnaire in excel document, convert it to XML format > -You can either download a file converter, or use an online converter (e.g zamzar.com) or convert in the ODK website by clicking on "XLSForm", then under the "Using the Application" heading, click the "on this page" link > -So, develop your questionnaire in excel, upload to server and then convert. > > > > -- > -- > 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.

Hi Jason,

I usually get this problem when there is a bug in my calculate.
Usually a missing bracket.

Can you reduce the problem to a single question from and a single row
CSV that we can take a look at?

Thanks,

Yaw

··· On Wed, Apr 5, 2017 at 9:20 AM, Jason Ives wrote: > Sorry to resurrect such an old thread, but I wanted to see if there has been > any work on this. I know in this particular case it was a weird underscore > that could be replaced, but I'm getting similar errors: > > 'ascii' codec can't encode character u'\xc0' in position 0: ordinal not in > range (128) > > when processing the external_choices tab using the xlsform.exe or pyxform > converters. This is character À, not a particularly unusual character. I > can process external csv files with the csv converter, but with this issue I > can't get the csv created when it comes from the external_choices tab. > > We can work around this issue so it isn't an emergency or anything, but I > just wanted to check in on encoding the external_choices itemsets.csv file > as utf-8 instead of ascii in the converters. > > Thanks > Jason > > On Monday, January 5, 2015 at 3:12:04 PM UTC-5, Mitch Sundt wrote: >> >> Somehow, you have special characters in your Excel spreadsheet that look >> like an underscore, but are not. >> >> Attached is a corrected version of the spreadsheet. >> >> This had a fascinating failure report. The error referred to a problem >> near "e] HP_message" in the text, so I searched for HP_message, and the >> 'underscores' near there were not findable by searching for _, so I copied >> their value into the Find box, and put _ in the replace box, and did a >> global replace, causing about 4-5 of replacements. After that, everything >> worked. >> >> >> On Sun, Jan 4, 2015 at 8:07 PM, Chan Choth wrote: >>> >>> Hi there, >>> >>> I try to convert from XLS to XFORM in http://opendatakit.org/xiframe/, >>> but I got the error like this. >>> >>> Environment: >>> >>> >>> Request Method: POST >>> Request URL: http://23.21.114.69/xlsform/ >>> >>> Django Version: 1.4 >>> Python Version: 2.6.5 >>> Installed Applications: >>> ('pyxform_interface', >>> 'django.contrib.auth', >>> 'django.contrib.contenttypes', >>> 'django.contrib.sessions', >>> 'django.contrib.sites', >>> 'django.contrib.messages', >>> 'django.contrib.staticfiles') >>> Installed Middleware: >>> ('django.middleware.common.CommonMiddleware', >>> 'django.contrib.sessions.middleware.SessionMiddleware', >>> 'django.contrib.auth.middleware.AuthenticationMiddleware', >>> 'django.contrib.messages.middleware.MessageMiddleware') >>> >>> >>> Traceback: >>> File >>> "/usr/local/lib/python2.6/dist-packages/django/core/handlers/base.py" in >>> get_response >>> 111. response = callback(request, >>> *callback_args, **callback_kwargs) >>> File "/home/ubuntu/django/xlsform/xlsform/pyxform_interface/views.py" in >>> index >>> 77. error = 'Error: ' + str(e) >>> >>> Exception Type: UnicodeEncodeError at / >>> Exception Value: 'ascii' codec can't encode character u'\u200b' in >>> position 36: ordinal not in range(128) >>> >>> Is there any problem? Please see the attached file of my XLS form. Thanks >>> so much for your support. >>> >>> Best regards, >>> Chan Choth >>> >>> -- >>> -- >>> 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/d/optout. >> >> >> >> >> -- >> Mitch Sundt >> Software Engineer >> University of Washington >> mitche...@gmail.com > > -- > -- > 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.

Try converting on ODK website

··· On Fri, Apr 28, 2017 at 12:35 AM, Yaw Anokwa wrote:

This is generally correct, but zamzar.com will definitely NOT convert
from XLS to XForm.

https://opendatakit.org/use/xlsform/ lists the XLSForm converters you
should use.

Yaw

On Wed, Apr 26, 2017 at 3:04 AM, bamikoleayedun@gmail.com wrote:

-To be able to use a form on the android, it has to be uploaded on the
server first
-After designing the questionnaire in excel document, convert it to XML
format
-You can either download a file converter, or use an online converter
(e.g zamzar.com) or convert in the ODK website by clicking on "XLSForm",
then under the "Using the Application" heading, click the "on this page"
link
-So, develop your questionnaire in excel, upload to server and then
convert.

--

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.

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/opendatakit/u4nPnc7RBjI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Sure, here you go. For what it's worth http://opendatakit.org/xiframe/
handles it fine, spits out the correct csv; but when I run this against
xlsform.exe I get the message above. Let me know if more info is needed.

Jason

char_test.xls (71.5 KB)

··· On Wednesday, April 5, 2017 at 7:48:46 PM UTC-4, Yaw Anokwa wrote: > > Hi Jason, > > I usually get this problem when there is a bug in my calculate. > Usually a missing bracket. > > Can you reduce the problem to a single question from and a single row > CSV that we can take a look at? > > Thanks, > > Yaw > > On Wed, Apr 5, 2017 at 9:20 AM, Jason Ives <jas...@gmail.com > wrote: > > Sorry to resurrect such an old thread, but I wanted to see if there has > been > > any work on this. I know in this particular case it was a weird > underscore > > that could be replaced, but I'm getting similar errors: > > > > 'ascii' codec can't encode character u'\xc0' in position 0: ordinal not > in > > range (128) > > > > when processing the external_choices tab using the xlsform.exe or > pyxform > > converters. This is character À, not a particularly unusual character. > I > > can process external csv files with the csv converter, but with this > issue I > > can't get the csv created when it comes from the external_choices tab. > > > > We can work around this issue so it isn't an emergency or anything, but > I > > just wanted to check in on encoding the external_choices itemsets.csv > file > > as utf-8 instead of ascii in the converters. > > > > Thanks > > Jason > > > > On Monday, January 5, 2015 at 3:12:04 PM UTC-5, Mitch Sundt wrote: > >> > >> Somehow, you have special characters in your Excel spreadsheet that > look > >> like an underscore, but are not. > >> > >> Attached is a corrected version of the spreadsheet. > >> > >> This had a fascinating failure report. The error referred to a problem > >> near "e] HP_message" in the text, so I searched for HP_message, and > the > >> 'underscores' near there were not findable by searching for _, so I > copied > >> their value into the Find box, and put _ in the replace box, and did a > >> global replace, causing about 4-5 of replacements. After that, > everything > >> worked. > >> > >> > >> On Sun, Jan 4, 2015 at 8:07 PM, Chan Choth wrote: > >>> > >>> Hi there, > >>> > >>> I try to convert from XLS to XFORM in http://opendatakit.org/xiframe/, > > >>> but I got the error like this. > >>> > >>> Environment: > >>> > >>> > >>> Request Method: POST > >>> Request URL: http://23.21.114.69/xlsform/ > >>> > >>> Django Version: 1.4 > >>> Python Version: 2.6.5 > >>> Installed Applications: > >>> ('pyxform_interface', > >>> 'django.contrib.auth', > >>> 'django.contrib.contenttypes', > >>> 'django.contrib.sessions', > >>> 'django.contrib.sites', > >>> 'django.contrib.messages', > >>> 'django.contrib.staticfiles') > >>> Installed Middleware: > >>> ('django.middleware.common.CommonMiddleware', > >>> 'django.contrib.sessions.middleware.SessionMiddleware', > >>> 'django.contrib.auth.middleware.AuthenticationMiddleware', > >>> 'django.contrib.messages.middleware.MessageMiddleware') > >>> > >>> > >>> Traceback: > >>> File > >>> "/usr/local/lib/python2.6/dist-packages/django/core/handlers/base.py" > in > >>> get_response > >>> 111. response = callback(request, > >>> *callback_args, **callback_kwargs) > >>> File "/home/ubuntu/django/xlsform/xlsform/pyxform_interface/views.py" > in > >>> index > >>> 77. error = 'Error: ' + str(e) > >>> > >>> Exception Type: UnicodeEncodeError at / > >>> Exception Value: 'ascii' codec can't encode character u'\u200b' in > >>> position 36: ordinal not in range(128) > >>> > >>> Is there any problem? Please see the attached file of my XLS form. > Thanks > >>> so much for your support. > >>> > >>> Best regards, > >>> Chan Choth > >>> > >>> -- > >>> -- > >>> 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/d/optout. > >> > >> > >> > >> > >> -- > >> Mitch Sundt > >> Software Engineer > >> University of Washington > >> mitche...@gmail.com > > > > -- > > -- > > 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/d/optout. >

Thanks for sending this test file, Jason.

The code for xlsform.exe is a little outdated. It lives, unexpectedly,
at https://github.com/uw-ictd/xlsform.exe.

I think what we'll do is try to get that repo moved to the opendatakit
project, then update it with the newest pyxform and then generate a
new build for the community.

Yaw

··· On Thu, Apr 6, 2017 at 9:00 AM, Jason Ives wrote: > Sure, here you go. For what it's worth http://opendatakit.org/xiframe/ > handles it fine, spits out the correct csv; but when I run this against > xlsform.exe I get the message above. Let me know if more info is needed. > > Jason > > > On Wednesday, April 5, 2017 at 7:48:46 PM UTC-4, Yaw Anokwa wrote: >> >> Hi Jason, >> >> I usually get this problem when there is a bug in my calculate. >> Usually a missing bracket. >> >> Can you reduce the problem to a single question from and a single row >> CSV that we can take a look at? >> >> Thanks, >> >> Yaw >> >> On Wed, Apr 5, 2017 at 9:20 AM, Jason Ives wrote: >> > Sorry to resurrect such an old thread, but I wanted to see if there has >> > been >> > any work on this. I know in this particular case it was a weird >> > underscore >> > that could be replaced, but I'm getting similar errors: >> > >> > 'ascii' codec can't encode character u'\xc0' in position 0: ordinal not >> > in >> > range (128) >> > >> > when processing the external_choices tab using the xlsform.exe or >> > pyxform >> > converters. This is character À, not a particularly unusual character. >> > I >> > can process external csv files with the csv converter, but with this >> > issue I >> > can't get the csv created when it comes from the external_choices tab. >> > >> > We can work around this issue so it isn't an emergency or anything, but >> > I >> > just wanted to check in on encoding the external_choices itemsets.csv >> > file >> > as utf-8 instead of ascii in the converters. >> > >> > Thanks >> > Jason >> > >> > On Monday, January 5, 2015 at 3:12:04 PM UTC-5, Mitch Sundt wrote: >> >> >> >> Somehow, you have special characters in your Excel spreadsheet that >> >> look >> >> like an underscore, but are not. >> >> >> >> Attached is a corrected version of the spreadsheet. >> >> >> >> This had a fascinating failure report. The error referred to a problem >> >> near "e] HP_message" in the text, so I searched for HP_message, and >> >> the >> >> 'underscores' near there were not findable by searching for _, so I >> >> copied >> >> their value into the Find box, and put _ in the replace box, and did a >> >> global replace, causing about 4-5 of replacements. After that, >> >> everything >> >> worked. >> >> >> >> >> >> On Sun, Jan 4, 2015 at 8:07 PM, Chan Choth wrote: >> >>> >> >>> Hi there, >> >>> >> >>> I try to convert from XLS to XFORM in http://opendatakit.org/xiframe/, >> >>> but I got the error like this. >> >>> >> >>> Environment: >> >>> >> >>> >> >>> Request Method: POST >> >>> Request URL: http://23.21.114.69/xlsform/ >> >>> >> >>> Django Version: 1.4 >> >>> Python Version: 2.6.5 >> >>> Installed Applications: >> >>> ('pyxform_interface', >> >>> 'django.contrib.auth', >> >>> 'django.contrib.contenttypes', >> >>> 'django.contrib.sessions', >> >>> 'django.contrib.sites', >> >>> 'django.contrib.messages', >> >>> 'django.contrib.staticfiles') >> >>> Installed Middleware: >> >>> ('django.middleware.common.CommonMiddleware', >> >>> 'django.contrib.sessions.middleware.SessionMiddleware', >> >>> 'django.contrib.auth.middleware.AuthenticationMiddleware', >> >>> 'django.contrib.messages.middleware.MessageMiddleware') >> >>> >> >>> >> >>> Traceback: >> >>> File >> >>> "/usr/local/lib/python2.6/dist-packages/django/core/handlers/base.py" >> >>> in >> >>> get_response >> >>> 111. response = callback(request, >> >>> *callback_args, **callback_kwargs) >> >>> File "/home/ubuntu/django/xlsform/xlsform/pyxform_interface/views.py" >> >>> in >> >>> index >> >>> 77. error = 'Error: ' + str(e) >> >>> >> >>> Exception Type: UnicodeEncodeError at / >> >>> Exception Value: 'ascii' codec can't encode character u'\u200b' in >> >>> position 36: ordinal not in range(128) >> >>> >> >>> Is there any problem? Please see the attached file of my XLS form. >> >>> Thanks >> >>> so much for your support. >> >>> >> >>> Best regards, >> >>> Chan Choth >> >>> >> >>> -- >> >>> -- >> >>> 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/d/optout. >> >> >> >> >> >> >> >> >> >> -- >> >> Mitch Sundt >> >> Software Engineer >> >> University of Washington >> >> mitche...@gmail.com >> > >> > -- >> > -- >> > 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/d/optout. > > -- > -- > 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.

Hi all,

The repo has been moved to https://github.com/opendatakit/xlsform.exe
(thanks Jeff!).

I have an updated build ready if anyone is up for testing it.

Yaw

··· On Tue, Apr 18, 2017 at 5:36 PM, Yaw Anokwa wrote: > Thanks for sending this test file, Jason. > > The code for xlsform.exe is a little outdated. It lives, unexpectedly, > at https://github.com/uw-ictd/xlsform.exe. > > I think what we'll do is try to get that repo moved to the opendatakit > project, then update it with the newest pyxform and then generate a > new build for the community. > > Yaw > > > On Thu, Apr 6, 2017 at 9:00 AM, Jason Ives wrote: >> Sure, here you go. For what it's worth http://opendatakit.org/xiframe/ >> handles it fine, spits out the correct csv; but when I run this against >> xlsform.exe I get the message above. Let me know if more info is needed. >> >> Jason >> >> >> On Wednesday, April 5, 2017 at 7:48:46 PM UTC-4, Yaw Anokwa wrote: >>> >>> Hi Jason, >>> >>> I usually get this problem when there is a bug in my calculate. >>> Usually a missing bracket. >>> >>> Can you reduce the problem to a single question from and a single row >>> CSV that we can take a look at? >>> >>> Thanks, >>> >>> Yaw >>> >>> On Wed, Apr 5, 2017 at 9:20 AM, Jason Ives wrote: >>> > Sorry to resurrect such an old thread, but I wanted to see if there has >>> > been >>> > any work on this. I know in this particular case it was a weird >>> > underscore >>> > that could be replaced, but I'm getting similar errors: >>> > >>> > 'ascii' codec can't encode character u'\xc0' in position 0: ordinal not >>> > in >>> > range (128) >>> > >>> > when processing the external_choices tab using the xlsform.exe or >>> > pyxform >>> > converters. This is character À, not a particularly unusual character. >>> > I >>> > can process external csv files with the csv converter, but with this >>> > issue I >>> > can't get the csv created when it comes from the external_choices tab. >>> > >>> > We can work around this issue so it isn't an emergency or anything, but >>> > I >>> > just wanted to check in on encoding the external_choices itemsets.csv >>> > file >>> > as utf-8 instead of ascii in the converters. >>> > >>> > Thanks >>> > Jason >>> > >>> > On Monday, January 5, 2015 at 3:12:04 PM UTC-5, Mitch Sundt wrote: >>> >> >>> >> Somehow, you have special characters in your Excel spreadsheet that >>> >> look >>> >> like an underscore, but are not. >>> >> >>> >> Attached is a corrected version of the spreadsheet. >>> >> >>> >> This had a fascinating failure report. The error referred to a problem >>> >> near "e] HP_message" in the text, so I searched for HP_message, and >>> >> the >>> >> 'underscores' near there were not findable by searching for _, so I >>> >> copied >>> >> their value into the Find box, and put _ in the replace box, and did a >>> >> global replace, causing about 4-5 of replacements. After that, >>> >> everything >>> >> worked. >>> >> >>> >> >>> >> On Sun, Jan 4, 2015 at 8:07 PM, Chan Choth wrote: >>> >>> >>> >>> Hi there, >>> >>> >>> >>> I try to convert from XLS to XFORM in http://opendatakit.org/xiframe/, >>> >>> but I got the error like this. >>> >>> >>> >>> Environment: >>> >>> >>> >>> >>> >>> Request Method: POST >>> >>> Request URL: http://23.21.114.69/xlsform/ >>> >>> >>> >>> Django Version: 1.4 >>> >>> Python Version: 2.6.5 >>> >>> Installed Applications: >>> >>> ('pyxform_interface', >>> >>> 'django.contrib.auth', >>> >>> 'django.contrib.contenttypes', >>> >>> 'django.contrib.sessions', >>> >>> 'django.contrib.sites', >>> >>> 'django.contrib.messages', >>> >>> 'django.contrib.staticfiles') >>> >>> Installed Middleware: >>> >>> ('django.middleware.common.CommonMiddleware', >>> >>> 'django.contrib.sessions.middleware.SessionMiddleware', >>> >>> 'django.contrib.auth.middleware.AuthenticationMiddleware', >>> >>> 'django.contrib.messages.middleware.MessageMiddleware') >>> >>> >>> >>> >>> >>> Traceback: >>> >>> File >>> >>> "/usr/local/lib/python2.6/dist-packages/django/core/handlers/base.py" >>> >>> in >>> >>> get_response >>> >>> 111. response = callback(request, >>> >>> *callback_args, **callback_kwargs) >>> >>> File "/home/ubuntu/django/xlsform/xlsform/pyxform_interface/views.py" >>> >>> in >>> >>> index >>> >>> 77. error = 'Error: ' + str(e) >>> >>> >>> >>> Exception Type: UnicodeEncodeError at / >>> >>> Exception Value: 'ascii' codec can't encode character u'\u200b' in >>> >>> position 36: ordinal not in range(128) >>> >>> >>> >>> Is there any problem? Please see the attached file of my XLS form. >>> >>> Thanks >>> >>> so much for your support. >>> >>> >>> >>> Best regards, >>> >>> Chan Choth >>> >>> >>> >>> -- >>> >>> -- >>> >>> 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/d/optout. >>> >> >>> >> >>> >> >>> >> >>> >> -- >>> >> Mitch Sundt >>> >> Software Engineer >>> >> University of Washington >>> >> mitche...@gmail.com >>> > >>> > -- >>> > -- >>> > 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/d/optout. >> >> -- >> -- >> 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.

Hi all,

The updated build has been uploaded to

Yaw

··· On Tue, Apr 18, 2017 at 11:12 PM, Yaw Anokwa wrote: > Hi all, > > The repo has been moved to https://github.com/opendatakit/xlsform.exe > (thanks Jeff!). > > I have an updated build ready if anyone is up for testing it. > > Yaw > > On Tue, Apr 18, 2017 at 5:36 PM, Yaw Anokwa wrote: >> Thanks for sending this test file, Jason. >> >> The code for xlsform.exe is a little outdated. It lives, unexpectedly, >> at https://github.com/uw-ictd/xlsform.exe. >> >> I think what we'll do is try to get that repo moved to the opendatakit >> project, then update it with the newest pyxform and then generate a >> new build for the community. >> >> Yaw >> >> >> On Thu, Apr 6, 2017 at 9:00 AM, Jason Ives wrote: >>> Sure, here you go. For what it's worth http://opendatakit.org/xiframe/ >>> handles it fine, spits out the correct csv; but when I run this against >>> xlsform.exe I get the message above. Let me know if more info is needed. >>> >>> Jason >>> >>> >>> On Wednesday, April 5, 2017 at 7:48:46 PM UTC-4, Yaw Anokwa wrote: >>>> >>>> Hi Jason, >>>> >>>> I usually get this problem when there is a bug in my calculate. >>>> Usually a missing bracket. >>>> >>>> Can you reduce the problem to a single question from and a single row >>>> CSV that we can take a look at? >>>> >>>> Thanks, >>>> >>>> Yaw >>>> >>>> On Wed, Apr 5, 2017 at 9:20 AM, Jason Ives wrote: >>>> > Sorry to resurrect such an old thread, but I wanted to see if there has >>>> > been >>>> > any work on this. I know in this particular case it was a weird >>>> > underscore >>>> > that could be replaced, but I'm getting similar errors: >>>> > >>>> > 'ascii' codec can't encode character u'\xc0' in position 0: ordinal not >>>> > in >>>> > range (128) >>>> > >>>> > when processing the external_choices tab using the xlsform.exe or >>>> > pyxform >>>> > converters. This is character À, not a particularly unusual character. >>>> > I >>>> > can process external csv files with the csv converter, but with this >>>> > issue I >>>> > can't get the csv created when it comes from the external_choices tab. >>>> > >>>> > We can work around this issue so it isn't an emergency or anything, but >>>> > I >>>> > just wanted to check in on encoding the external_choices itemsets.csv >>>> > file >>>> > as utf-8 instead of ascii in the converters. >>>> > >>>> > Thanks >>>> > Jason >>>> > >>>> > On Monday, January 5, 2015 at 3:12:04 PM UTC-5, Mitch Sundt wrote: >>>> >> >>>> >> Somehow, you have special characters in your Excel spreadsheet that >>>> >> look >>>> >> like an underscore, but are not. >>>> >> >>>> >> Attached is a corrected version of the spreadsheet. >>>> >> >>>> >> This had a fascinating failure report. The error referred to a problem >>>> >> near "e] HP_message" in the text, so I searched for HP_message, and >>>> >> the >>>> >> 'underscores' near there were not findable by searching for _, so I >>>> >> copied >>>> >> their value into the Find box, and put _ in the replace box, and did a >>>> >> global replace, causing about 4-5 of replacements. After that, >>>> >> everything >>>> >> worked. >>>> >> >>>> >> >>>> >> On Sun, Jan 4, 2015 at 8:07 PM, Chan Choth wrote: >>>> >>> >>>> >>> Hi there, >>>> >>> >>>> >>> I try to convert from XLS to XFORM in http://opendatakit.org/xiframe/, >>>> >>> but I got the error like this. >>>> >>> >>>> >>> Environment: >>>> >>> >>>> >>> >>>> >>> Request Method: POST >>>> >>> Request URL: http://23.21.114.69/xlsform/ >>>> >>> >>>> >>> Django Version: 1.4 >>>> >>> Python Version: 2.6.5 >>>> >>> Installed Applications: >>>> >>> ('pyxform_interface', >>>> >>> 'django.contrib.auth', >>>> >>> 'django.contrib.contenttypes', >>>> >>> 'django.contrib.sessions', >>>> >>> 'django.contrib.sites', >>>> >>> 'django.contrib.messages', >>>> >>> 'django.contrib.staticfiles') >>>> >>> Installed Middleware: >>>> >>> ('django.middleware.common.CommonMiddleware', >>>> >>> 'django.contrib.sessions.middleware.SessionMiddleware', >>>> >>> 'django.contrib.auth.middleware.AuthenticationMiddleware', >>>> >>> 'django.contrib.messages.middleware.MessageMiddleware') >>>> >>> >>>> >>> >>>> >>> Traceback: >>>> >>> File >>>> >>> "/usr/local/lib/python2.6/dist-packages/django/core/handlers/base.py" >>>> >>> in >>>> >>> get_response >>>> >>> 111. response = callback(request, >>>> >>> *callback_args, **callback_kwargs) >>>> >>> File "/home/ubuntu/django/xlsform/xlsform/pyxform_interface/views.py" >>>> >>> in >>>> >>> index >>>> >>> 77. error = 'Error: ' + str(e) >>>> >>> >>>> >>> Exception Type: UnicodeEncodeError at / >>>> >>> Exception Value: 'ascii' codec can't encode character u'\u200b' in >>>> >>> position 36: ordinal not in range(128) >>>> >>> >>>> >>> Is there any problem? Please see the attached file of my XLS form. >>>> >>> Thanks >>>> >>> so much for your support. >>>> >>> >>>> >>> Best regards, >>>> >>> Chan Choth >>>> >>> >>>> >>> -- >>>> >>> -- >>>> >>> 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/d/optout. >>>> >> >>>> >> >>>> >> >>>> >> >>>> >> -- >>>> >> Mitch Sundt >>>> >> Software Engineer >>>> >> University of Washington >>>> >> mitche...@gmail.com >>>> > >>>> > -- >>>> > -- >>>> > 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/d/optout. >>> >>> -- >>> -- >>> 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.