How can we set a default value of integer variable in Excel?

Support
1

Hi there,

I have this variable that I put in the excel form.

type name label
integer no_of_child No of your child

Is there any possibility that we can set a default value of this variable
to 0? Thanks.

2

Add another column called "default"

type name default label integer nr_children 1 Number of
children?
For more information regarding xlsForm syntax, read
thishttp://formhub.org/syntax/
.

/r
Nik

··· On Friday, December 21, 2012, Chan Choth wrote:

Hi there,

I have this variable that I put in the excel form.

type name label
integer no_of_child No of your child

Is there any possibility that we can set a default value of this variable
to 0? Thanks.

--
Post: opendatakit@googlegroups.com <javascript:_e({}, 'cvml',
'opendatakit@googlegroups.com');>
Unsubscribe: opendatakit+unsubscribe@googlegroups.com <javascript:_e({},
'cvml', 'opendatakit%2Bunsubscribe@googlegroups.com');>
Options: http://groups.google.com/group/opendatakit?hl=en

3

Hi,

I try to put the default column and when I put
in http://opendatakit.org/use/xlsform/ to generate the xml form and upload
to Google Aggregate, I got this error: Error: Problem with JavaRosa Parsing
Form: org.javarosa.xform.parse.XFormParseException: XML Syntax Error at
Line: 3, Column: 102!

Please see the attached Excel file.
Thanks for your support.

Best regards,
Chan Choth

Project_Mapping.xls (89 KB)

··· On Friday, December 21, 2012 1:58:12 PM UTC+7, ニコノコ wrote: > > Add another column called "default" > > *type* *name* *default* *label* integer nr_children 1 Number of > children? > For more information regarding xlsForm syntax, read this > . > > /r > Nik > > On Friday, December 21, 2012, Chan Choth wrote: > >> Hi there, >> >> I have this variable that I put in the excel form. >> >> type name label >> integer no_of_child No of your child >> >> Is there any possibility that we can set a default value of this variable >> to 0? Thanks. >> >> -- >> Post: opendatakit@googlegroups.com >> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >> Options: http://groups.google.com/group/opendatakit?hl=en >> >
4

Can you try again?

I just tested your version and it works. Also attached is another revised
version that works fine.

Project_Mapping_defaults.xls (68 KB)

··· On Tuesday, December 25, 2012, Chan Choth wrote:

Hi,

I try to put the default column and when I put in
http://opendatakit.org/use/xlsform/ to generate the xml form and upload
to Google Aggregate, I got this error: Error: Problem with JavaRosa
Parsing Form: org.javarosa.xform.parse.XFormParseException: XML Syntax
Error at Line: 3, Column: 102!

Please see the attached Excel file.
Thanks for your support.

Best regards,
Chan Choth

On Friday, December 21, 2012 1:58:12 PM UTC+7, ニコノコ wrote:

Add another column called "default"

type name default label integer nr_children 1 Number of
children?
For more information regarding xlsForm syntax, read thishttp://formhub.org/syntax/
.

/r
Nik

On Friday, December 21, 2012, Chan Choth wrote:

Hi there,

I have this variable that I put in the excel form.

type name label
integer no_of_child No of your child

Is there any possibility that we can set a default value of this
variable to 0? Thanks.

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

--
Post: opendatakit@googlegroups.com <javascript:_e({}, 'cvml',
'opendatakit@googlegroups.com');>
Unsubscribe: opendatakit+unsubscribe@googlegroups.com <javascript:_e({},
'cvml', 'opendatakit%2Bunsubscribe@googlegroups.com');>
Options: http://groups.google.com/group/opendatakit?hl=en

5

I'm fairly certain you are using the 1.1. preview version of Aggregate and
are encountering issue 596.
Upgrade to 1.2.
http://code.google.com/p/opendatakit/wiki/AggregateReleaseNotes

··· On Mon, Dec 24, 2012 at 11:13 PM, ゴー・ニコライ wrote:

Can you try again?

I just tested your version and it works. Also attached is another revised
version that works fine.

On Tuesday, December 25, 2012, Chan Choth wrote:

Hi,

I try to put the default column and when I put in
http://opendatakit.org/use/xlsform/ to generate the xml form and upload
to Google Aggregate, I got this error: Error: Problem with JavaRosa
Parsing Form: org.javarosa.xform.parse.XFormParseException: XML Syntax
Error at Line: 3, Column: 102!

Please see the attached Excel file.
Thanks for your support.

Best regards,
Chan Choth

On Friday, December 21, 2012 1:58:12 PM UTC+7, ニコノコ wrote:

Add another column called "default"

type name default label integer nr_children 1 Number of
children?
For more information regarding xlsForm syntax, read thishttp://formhub.org/syntax/
.

/r
Nik

On Friday, December 21, 2012, Chan Choth wrote:

Hi there,

I have this variable that I put in the excel form.

type name label
integer no_of_child No of your child

Is there any possibility that we can set a default value of this
variable to 0? Thanks.

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

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

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

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