Error uploading form created with ODK Build

Hi,

I've created a survey with ODK Build. Now i'm trying to upload it to an
aggegrate such as Kobo Toolbox or ONA, as i have to wait until our IT team
has installed ODK Aggregate on my computer.

However, with ONA i get the following error message:
You must have a sheet named (case-sensitive): survey

With Kobo, it get the error message:
Import Error. Syntax Error. xls upload must have one of these sheets:
survey, library.

Does this mean, the form created with ODK Build can only be used with ODK
Aggregate?
Or why does ODK Build generated forms do not have sheets like 'survey' or
'library'?

Thanks,

Linde

ODK Collect uses an XML file to describe the form.

ODK Build constructs and produces this XML file.

XLSForm, and the Ona and Kobo tools all use an XLSX file (Excel
spreadsheet) to describe the form. These all internally compile this form
definition to an XML file, which is then downloaded to the device.

ODK Aggregate only works with XML files. Those can be generated by ODK
Build or by XLSForm.

i.e., the compatibility layer across ONA, Kobo and the core ODK tools is
the XLSX file ( http://xlsform.org/ ) but internally there is another
compatibility layer, the XML file.

In practice, it is hard for people to write forms at the lower level detail
of an XML file, which is why the XLSX file standard developed.

··· On Wed, Oct 12, 2016 at 7:12 AM, Linde Mues wrote:

Hi,

I've created a survey with ODK Build. Now i'm trying to upload it to an
aggegrate such as Kobo Toolbox or ONA, as i have to wait until our IT team
has installed ODK Aggregate on my computer.

However, with ONA i get the following error message:
You must have a sheet named (case-sensitive): survey

With Kobo, it get the error message:
Import Error. Syntax Error. xls upload must have one of these sheets:
survey, library.

Does this mean, the form created with ODK Build can only be used with ODK
Aggregate?
Or why does ODK Build generated forms do not have sheets like 'survey' or
'library'?

Thanks,

Linde

--

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

Hi Mitch,

I understand, but i would think that if i convert the XML file to XLSX
using a converter, than i would be able to upload to it to any other tool
such as Kobo.
I would think whatever form builder you use, in the end they all would
produce the same XLSX file once converted from XML.

So still not clear to me why i can't convert the ODK Build XML file into an
XLSX that is compatible/readible by any other tool.

Thanks again,
Linde

··· Op donderdag 13 oktober 2016 18:43:53 UTC+2 schreef Mitch Sundt:

ODK Collect uses an XML file to describe the form.

ODK Build constructs and produces this XML file.

XLSForm, and the Ona and Kobo tools all use an XLSX file (Excel
spreadsheet) to describe the form. These all internally compile this form
definition to an XML file, which is then downloaded to the device.

ODK Aggregate only works with XML files. Those can be generated by ODK
Build or by XLSForm.

i.e., the compatibility layer across ONA, Kobo and the core ODK tools is
the XLSX file ( http://xlsform.org/ ) but internally there is another
compatibility layer, the XML file.

In practice, it is hard for people to write forms at the lower level
detail of an XML file, which is why the XLSX file standard developed.

On Wed, Oct 12, 2016 at 7:12 AM, Linde Mues <mues...@gmail.com <javascript:>> wrote:

Hi,

I've created a survey with ODK Build. Now i'm trying to upload it to an
aggegrate such as Kobo Toolbox or ONA, as i have to wait until our IT team
has installed ODK Aggregate on my computer.

However, with ONA i get the following error message:
You must have a sheet named (case-sensitive): survey

With Kobo, it get the error message:
Import Error. Syntax Error. xls upload must have one of these sheets:
survey, library.

Does this mean, the form created with ODK Build can only be used with ODK
Aggregate?
Or why does ODK Build generated forms do not have sheets like 'survey' or
'library'?

Thanks,

Linde

--

Post: opend...@googlegroups.com <javascript:>
Unsubscribe: opendatakit...@googlegroups.com <javascript:>
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 <javascript:>.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com <javascript:>

The conversion is in the other direction -- from XLSX (Excel spreadsheet)
into XML.

ODK Collect works on these XML files; they conform to the XForms spec (with
many non-conformance quirks/bugs/extensions)

In the early days, it quickly became apparent that it was too difficult to
directly write XForms XML documents

So a talented undergrad (Clint) at the UW created ODK Build, a
drag-and-drop form designer. ODK Build directly generates these XForms XML
files (it doesn't write or maintain an XLSX file).

Columbia University & Matt Berg (now ONA) came up with the brilliant idea
of using a spreadsheet (XLSX) to define the survey.

These were developed independently and there is no direct translation
between the two.

Once the XLSX format was invented, some of the servers and tools have
changed to work directly off of that XLSX file, with no access to the
underlying XML files. The ODK tools did not -- they explicitly retain
access to the XML files.

··· On Mon, Oct 17, 2016 at 12:36 AM, Linde Mues wrote:

Hi Mitch,

I understand, but i would think that if i convert the XML file to XLSX
using a converter, than i would be able to upload to it to any other tool
such as Kobo.
I would think whatever form builder you use, in the end they all would
produce the same XLSX file once converted from XML.

So still not clear to me why i can't convert the ODK Build XML file into
an XLSX that is compatible/readible by any other tool.

Thanks again,
Linde

Op donderdag 13 oktober 2016 18:43:53 UTC+2 schreef Mitch Sundt:

ODK Collect uses an XML file to describe the form.

ODK Build constructs and produces this XML file.

XLSForm, and the Ona and Kobo tools all use an XLSX file (Excel
spreadsheet) to describe the form. These all internally compile this form
definition to an XML file, which is then downloaded to the device.

ODK Aggregate only works with XML files. Those can be generated by ODK
Build or by XLSForm.

i.e., the compatibility layer across ONA, Kobo and the core ODK tools is
the XLSX file ( http://xlsform.org/ ) but internally there is another
compatibility layer, the XML file.

In practice, it is hard for people to write forms at the lower level
detail of an XML file, which is why the XLSX file standard developed.

On Wed, Oct 12, 2016 at 7:12 AM, Linde Mues mues...@gmail.com wrote:

Hi,

I've created a survey with ODK Build. Now i'm trying to upload it to an
aggegrate such as Kobo Toolbox or ONA, as i have to wait until our IT team
has installed ODK Aggregate on my computer.

However, with ONA i get the following error message:
You must have a sheet named (case-sensitive): survey

With Kobo, it get the error message:
Import Error. Syntax Error. xls upload must have one of these sheets:
survey, library.

Does this mean, the form created with ODK Build can only be used with
ODK Aggregate?
Or why does ODK Build generated forms do not have sheets like 'survey'
or 'library'?

Thanks,

Linde

--

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