Increasing text field length beyond 255 in .xls Form?

Hello,
I have a text input (type = string) in my survey that needs to allow more
than 255 characters.
Is there a way to increase this limit in the .xls form?

Or, must I modify the converted .xml file according to the instructions
here:
http://opendatakit.org/help/form-design/guidelines/

Thank you.

I experimented with modifying the .xml form. I added the text:
odk:length="600"
To the end of the bind nodeset tag for which I need to increase the
allowable text length.

When I try to upload to ODK Aggregate, I get the following error:
Error: Problem with JavaRosa Parsing Form:
org.opendatakit.aggregate.exception.ODKIncompleteSubmissionData:
org.javarosa.xform.parse.XFormParseException: Unhandled Exception while
Parsing XForm

··· On Thu, Jan 30, 2014 at 2:05 PM, Steven Hansen wrote:

Hello,
I have a text input (type = string) in my survey that needs to allow more
than 255 characters.
Is there a way to increase this limit in the .xls form?

Or, must I modify the converted .xml file according to the instructions
here:
http://opendatakit.org/help/form-design/guidelines/

Thank you.

--

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/9z-IlaiYXmk/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/groups/opt_out.

Hey!

I tried the same workaround with xlmns and bind, and I receive the following error message when I try to upload the xml to aggregate:

"Error: Problem with JavaRosa Parsing Form: org.opendatakit.aggregate.exception.ODKIncompleteSubmissionData: org.javarosa.xform.parse.XFormParseException: XML Syntax Error at Line: 1, Column: 5!"

I double-checked and cant see the syntax error :frowning:

it looks as follows:

<?xml version="1.0"?>

<h:html

xmlns="http://www.w3.org/2002/xforms"
xmlns:ev="http://www.w3.org/2001/xml-events"
xmlns:h="http://www.w3.org/1999/xhtml"
xmlns:jr="http://openrosa.org/javarosa"
xmlns:orx="http://openrosa.org/xforms/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:odk="http://www.opendatakit.org/xforms"

Any ideas?
thanks,
Jevgeniy

The trick when adding the xmlns:odk="http://www.opendatakit.org/xforms" +
odk:length="xxxx" (where xxxx is the required string length) to your xml
form is:

#1 the text/xml editor you use to modify your xml form greatly matters
(e.g. in windows many of them add the encoding="utf-8" after the xml
version="1.0" >> error when validating/uploading the form;

#2 when validating the correctly modified form with ODK Validate 1.4.5 for
ODK Collect v1.4.5 and newer.jar, you will get a warning message, though
the form is okay, upploadable to aggregate and will work (=store text
strings up to the char.length you specified in the variable) like this:

··· --------------- Parsing form... Title: "SzA teszturlap7" XForm Parse Warning: Warning: 1 Unrecognized attributes found in Element [bind] and will be ignored: [length] Location:
Problem found at nodeset: /html/head/model/bind
With element <bind nodeset="/ODK_test7_sza/singular_list/list_spp" 

type="string" length="2000"/>

Problem found at nodeset: /html/head/model/bind
With element <bind nodeset="/ODK_test7_sza/singular_list/list_spp" 

type="string" length="2000"/>

warning: unrecognized data type in xpath expr:
org.javarosa.core.model.data.DateTimeData

Xform parsing completed! See above for any warnings.

Xform is valid! See above for any warnings.


I found this out after 2 days' struggle :frowning:

On Thursday, January 30, 2014 at 11:05:54 PM UTC+1, Steven Hansen wrote:

Hello,
I have a text input (type = string) in my survey that needs to allow more
than 255 characters.
Is there a way to increase this limit in the .xls form?

Or, must I modify the converted .xml file according to the instructions
here:
http://opendatakit.org/help/form-design/guidelines/

Thank you.

Steven,

What error message do you get if you validate the form with ODK
Validate? And can you share the entire bind tag you used?

Yaw

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

On Thu, Jan 30, 2014 at 3:19 PM, Steven Hansen steveohansen@gmail.com wrote:

I experimented with modifying the .xml form. I added the text:
odk:length="600"
To the end of the bind nodeset tag for which I need to increase the
allowable text length.

When I try to upload to ODK Aggregate, I get the following error:
Error: Problem with JavaRosa Parsing Form:
org.opendatakit.aggregate.exception.ODKIncompleteSubmissionData:
org.javarosa.xform.parse.XFormParseException: Unhandled Exception while
Parsing XForm

On Thu, Jan 30, 2014 at 2:05 PM, Steven Hansen steveohansen@gmail.com wrote:

Hello,
I have a text input (type = string) in my survey that needs to allow more
than 255 characters.
Is there a way to increase this limit in the .xls form?

Or, must I modify the converted .xml file according to the instructions
here:
http://opendatakit.org/help/form-design/guidelines/

Thank you.

--

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/9z-IlaiYXmk/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/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.

I'd recommend running the sample_form.xls through XLSForm and using that as
an example of how the XML should look. http://opendatakit.org/use/xlsform/

··· On Tue, Jun 3, 2014 at 6:29 AM, wrote:

Hey!

I tried the same workaround with xlmns and bind, and I receive the
following error message when I try to upload the xml to aggregate:

"Error: Problem with JavaRosa Parsing Form:
org.opendatakit.aggregate.exception.ODKIncompleteSubmissionData:
org.javarosa.xform.parse.XFormParseException: XML Syntax Error at Line: 1,
Column: 5!"

I double-checked and cant see the syntax error :frowning:

it looks as follows:

<?xml version="1.0"?>

<h:html

xmlns="http://www.w3.org/2002/xforms"
xmlns:ev="http://www.w3.org/2001/xml-events"
xmlns:h="http://www.w3.org/1999/xhtml"
xmlns:jr="http://openrosa.org/javarosa"
xmlns:orx="http://openrosa.org/xforms/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:odk="http://www.opendatakit.org/xforms"

Any ideas?
thanks,
Jevgeniy

--

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

I realized that I didn't add the xmlns alias. With that added, I get this
message from ODK Validate:
Parsing form...
Title: "test"
Warning: 1 Unrecognized attributes found in Element [bind] and will be
ignored: [length] Location:
Problem found at nodeset: /html/head/model/bind
With element <bind
nodeset="/SSF_Form_Short_Pushbutton_modified_boiler/InputSection/Description_4229"
type="string" length="600"/

Xform parsing completed! See above for any warnings.
Xform is valid! See above for any warnings.

It appeared to upload successfully to ODK Aggregate, but immediately after
adding this form, ODK Aggregate won't stop refreshing every few seconds. I
have restarted my browser, logged out and back in as a different user, but
the problem persists.
Is this an unrelated problem?

··· On Thu, Jan 30, 2014 at 6:33 PM, Yaw Anokwa wrote:

Steven,

What error message do you get if you validate the form with ODK
Validate? And can you share the entire bind tag you used?

Yaw

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

On Thu, Jan 30, 2014 at 3:19 PM, Steven Hansen steveohansen@gmail.com wrote:

I experimented with modifying the .xml form. I added the text:
odk:length="600"
To the end of the bind nodeset tag for which I need to increase the
allowable text length.

When I try to upload to ODK Aggregate, I get the following error:
Error: Problem with JavaRosa Parsing Form:
org.opendatakit.aggregate.exception.ODKIncompleteSubmissionData:
org.javarosa.xform.parse.XFormParseException: Unhandled Exception while
Parsing XForm

On Thu, Jan 30, 2014 at 2:05 PM, Steven Hansen steveohansen@gmail.com wrote:

Hello,
I have a text input (type = string) in my survey that needs to allow
more
than 255 characters.
Is there a way to increase this limit in the .xls form?

Or, must I modify the converted .xml file according to the instructions
here:
http://opendatakit.org/help/form-design/guidelines/

Thank you.

--

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/9z-IlaiYXmk/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/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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/9z-IlaiYXmk/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/groups/opt_out.

Hi Mitch,
I did as you suggested, the sample_form.xml looks the same with the difference that I added the line below in order to increase the string length:

xmlns:odk="http://www.opendatakit.org/xforms"

Since I received an error in Agreage, I then blindly added '/' at the end of ../xforms to make it look as follows:

xmlns:odk="http://www.opendatakit.org/xforms/"

Agregate didnt complain with this change, so the form is uploaded successfully this time. But when I write >255 characters ODK collect, it still cuts off at 255, after I upload the submission.

Here is the bind code whereby I added odk:length="600" in the end. Can you see why it didnt work?

thanks mate,
Jevgeniy

··· Am Dienstag, 3. Juni 2014 19:04:03 UTC+3 schrieb Mitch Sundt: > I'd recommend running the sample_form.xls through XLSForm and using that as an example of how the XML should look. http://opendatakit.org/use/xlsform/ > > > > > > On Tue, Jun 3, 2014 at 6:29 AM, wrote: > > Hey! > > > > I tried the same workaround with xlmns and bind, and I receive the following error message when I try to upload the xml to aggregate: > > > > "Error: Problem with JavaRosa Parsing Form: org.opendatakit.aggregate.exception.ODKIncompleteSubmissionData: org.javarosa.xform.parse.XFormParseException: XML Syntax Error at Line: 1, Column: 5!" > > > > I double-checked and cant see the syntax error :( > > > > it looks as follows: > > > > <?xml version="1.0"?> > > > > > > > xmlns="http://www.w3.org/2002/xforms" > > xmlns:ev="http://www.w3.org/2001/xml-events" > > xmlns:h="http://www.w3.org/1999/xhtml" > > xmlns:jr="http://openrosa.org/javarosa" > > xmlns:orx="http://openrosa.org/xforms/" > > xmlns:xsd="http://www.w3.org/2001/XMLSchema" > > xmlns:odk="http://www.opendatakit.org/xforms" > > > > > > > Any ideas? > > thanks, > > Jevgeniy > > > > > -- > > -- > > 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

Hi Steven,

The multiple refresh is not related, but it is a known issue. See the
"Repairing your AppEngine Database Yourself" section at
https://code.google.com/p/opendatakit/wiki/AppEngineTroubleshooting to
fix it.

Yaw

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

On Fri, Jan 31, 2014 at 9:40 AM, Steven Hansen steveohansen@gmail.com wrote:

I realized that I didn't add the xmlns alias. With that added, I get this
message from ODK Validate:
Parsing form...
Title: "test"
Warning: 1 Unrecognized attributes found in Element [bind] and will be
ignored: [length] Location:
Problem found at nodeset: /html/head/model/bind
With element <bind
nodeset="/SSF_Form_Short_Pushbutton_modified_boiler/InputSection/Description_4229"
type="string" length="600"/

Xform parsing completed! See above for any warnings.
Xform is valid! See above for any warnings.

It appeared to upload successfully to ODK Aggregate, but immediately after
adding this form, ODK Aggregate won't stop refreshing every few seconds. I
have restarted my browser, logged out and back in as a different user, but
the problem persists.
Is this an unrelated problem?

On Thu, Jan 30, 2014 at 6:33 PM, Yaw Anokwa yanokwa@nafundi.com wrote:

Steven,

What error message do you get if you validate the form with ODK
Validate? And can you share the entire bind tag you used?

Yaw

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

On Thu, Jan 30, 2014 at 3:19 PM, Steven Hansen steveohansen@gmail.com wrote:

I experimented with modifying the .xml form. I added the text:
odk:length="600"
To the end of the bind nodeset tag for which I need to increase the
allowable text length.

When I try to upload to ODK Aggregate, I get the following error:
Error: Problem with JavaRosa Parsing Form:
org.opendatakit.aggregate.exception.ODKIncompleteSubmissionData:
org.javarosa.xform.parse.XFormParseException: Unhandled Exception while
Parsing XForm

On Thu, Jan 30, 2014 at 2:05 PM, Steven Hansen steveohansen@gmail.com wrote:

Hello,
I have a text input (type = string) in my survey that needs to allow
more
than 255 characters.
Is there a way to increase this limit in the .xls form?

Or, must I modify the converted .xml file according to the instructions
here:
http://opendatakit.org/help/form-design/guidelines/

Thank you.

--

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/9z-IlaiYXmk/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/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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/9z-IlaiYXmk/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/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.

Ok problem solved! Couldnt reproduce the error message anymore in Xform Upload. works without "/" after xforms.
J.

··· Am Mittwoch, 4. Juni 2014 21:51:37 UTC+3 schrieb jb.ma...@gmail.com: > Hi Mitch, > I did as you suggested, the sample_form.xml looks the same with the difference that I added the line below in order to increase the string length: > > xmlns:odk="http://www.opendatakit.org/xforms" > > Since I received an error in Agreage, I then blindly added '/' at the end of ../xforms to make it look as follows: > > xmlns:odk="http://www.opendatakit.org/xforms/" > > Agregate didnt complain with this change, so the form is uploaded successfully this time. But when I write >255 characters ODK collect, it still cuts off at 255, after I upload the submission. > > Here is the bind code whereby I added odk:length="600" in the end. Can you see why it didnt work? > > > > thanks mate, > Jevgeniy > > > Am Dienstag, 3. Juni 2014 19:04:03 UTC+3 schrieb Mitch Sundt: > > I'd recommend running the sample_form.xls through XLSForm and using that as an example of how the XML should look. http://opendatakit.org/use/xlsform/ > > > > > > > > > > > > On Tue, Jun 3, 2014 at 6:29 AM, wrote: > > > > Hey! > > > > > > > > I tried the same workaround with xlmns and bind, and I receive the following error message when I try to upload the xml to aggregate: > > > > > > > > "Error: Problem with JavaRosa Parsing Form: org.opendatakit.aggregate.exception.ODKIncompleteSubmissionData: org.javarosa.xform.parse.XFormParseException: XML Syntax Error at Line: 1, Column: 5!" > > > > > > > > I double-checked and cant see the syntax error :( > > > > > > > > it looks as follows: > > > > > > > > <?xml version="1.0"?> > > > > > > > > > > > > > > > xmlns="http://www.w3.org/2002/xforms" > > > > xmlns:ev="http://www.w3.org/2001/xml-events" > > > > xmlns:h="http://www.w3.org/1999/xhtml" > > > > xmlns:jr="http://openrosa.org/javarosa" > > > > xmlns:orx="http://openrosa.org/xforms/" > > > > xmlns:xsd="http://www.w3.org/2001/XMLSchema" > > > > xmlns:odk="http://www.opendatakit.org/xforms" > > > > > > > > > > > > > Any ideas? > > > > thanks, > > > > Jevgeniy > > > > > > > > > > -- > > > > -- > > > > 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

To make this work, you need to completely delete your old form and its
data, then upload the new form.

If you merely updated the form definition with a new version, it would
still have the original size and ignore this change (that could be
considered a bug with detecting significant changes in forms).

If you need the existing data, download that using Briefcase, then delete
the form on the server, upload a revision with a newer version attribute,
then push the data back up to the server using ODK Briefcase. It should
detect that the form on the server is newer, and just push the existing
data back up into it.

Mitch

··· On Wed, Jun 4, 2014 at 11:51 AM, wrote:

Hi Mitch,
I did as you suggested, the sample_form.xml looks the same with the
difference that I added the line below in order to increase the string
length:

xmlns:odk="http://www.opendatakit.org/xforms"

Since I received an error in Agreage, I then blindly added '/' at the end
of ../xforms to make it look as follows:

xmlns:odk="http://www.opendatakit.org/xforms/"

Agregate didnt complain with this change, so the form is uploaded
successfully this time. But when I write >255 characters ODK collect, it
still cuts off at 255, after I upload the submission.

Here is the bind code whereby I added odk:length="600" in the end. Can you
see why it didnt work?

thanks mate,
Jevgeniy

Am Dienstag, 3. Juni 2014 19:04:03 UTC+3 schrieb Mitch Sundt:

I'd recommend running the sample_form.xls through XLSForm and using that
as an example of how the XML should look.
http://opendatakit.org/use/xlsform/

On Tue, Jun 3, 2014 at 6:29 AM, jb.ma...@gmail.com wrote:

Hey!

I tried the same workaround with xlmns and bind, and I receive the
following error message when I try to upload the xml to aggregate:

"Error: Problem with JavaRosa Parsing Form:
org.opendatakit.aggregate.exception.ODKIncompleteSubmissionData:
org.javarosa.xform.parse.XFormParseException: XML Syntax Error at Line: 1,
Column: 5!"

I double-checked and cant see the syntax error :frowning:

it looks as follows:

<?xml version="1.0"?>

<h:html

xmlns="http://www.w3.org/2002/xforms"

xmlns:ev="http://www.w3.org/2001/xml-events"

xmlns:h="http://www.w3.org/1999/xhtml"

xmlns:jr="http://openrosa.org/javarosa"

xmlns:orx="http://openrosa.org/xforms/"

xmlns:xsd="http://www.w3.org/2001/XMLSchema"

xmlns:odk="http://www.opendatakit.org/xforms"

Any ideas?

thanks,

Jevgeniy

--

--

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.

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