[ODK Community] XLS2XForm Conversion Error from IKI Malawi ROUND 2

Hi Andrew,
I need your help again. I took the xls file that you helped us convert to
xml on http://xform-prod.mvpafrica.org/ and added constraints, constraint
messages, relevances (skip patterns), and required fields (xls attached).
When I try to convert the updated xls file at
http://xform-prod.mvpafrica.org/ I get the XML but the added constraints,
constraint messages, relevances (skip patterns), and required fields do not
apply when I transfer the xml to the phone and start filling out the
questionnaire.

I am not XML literate, but I took a look that the xml file (attached)
produced at http://xform-prod.mvpafrica.org/ and it does not seem to contain
the entries for the added fields. I expected some of the additions to not
work due to formatting issues, etc... which I will need to perfect, but
fixing the absence of the xml code for these elements is beyond my skill
level.

I have also created a separate results form using the xls file you sent us
with modifications for the questionnaire and the same problem applies. (Also
attached)

I also tried to convert the xls to xml at http://xls2xform.opendatakit.org/,
but I get similar error messages to those first encountered. "Conversion
Error: ('Unknown question type', u'start time', 'base')"

I would really appreciate your help again. Thanks.
Mike

ODK_RANDQuestionnaire111017md.xls (94 KB)

RAND_Qn 111017md.xml (91.3 KB)

ODK_RANDResultsForm111019md.xls (37.5 KB)

RAND_Result_Form 111019md2.xml (16.5 KB)

··· On Mon, Oct 3, 2011 at 10:21 AM, Mike Dalious < mike.dalious@investinknowledge.org> wrote:

Andrew,
Thank you for your assistance. I was able to convert the file and we will
continue to program the skip patterns, etc...

Should we have any further issues or comments we will be in touch.

Thanks again,
Mike Dalious

On Thu, Sep 29, 2011 at 11:09 PM, Andrew Marder < andrew.ei.marder@gmail.com> wrote:

Hi Mike,

I made a few edits (see attached) and compiled this file at
http://xform-prod.mvpafrica.org/ . If you have any questions it'd be
great to have you on xls2xform@googlegroups.com.

Andrew

On Thu, Sep 29, 2011 at 2:06 AM, Mike Dalious mike.dalious@investinknowledge.org wrote:

Hi Andrew,
Sorry for the delay. I am attaching our xls file now (ending with
110917md). Also we were able to convert an earlier and much shorter
version
of the same questionnaire. I am also attaching it (ending with
110831md)
and the corresponding xml.
Thanks for your help.
Mike.

On Tue, Sep 27, 2011 at 8:54 PM, Andrew Marder < andrew.ei.marder@gmail.com> wrote:

Hi Pete,

Can you send me your xls file and I'll get back to you asap?

Andrew

On Tue, Sep 27, 2011 at 2:46 PM, Peter Fleming pcfleming@gmail.com wrote:

we're experiencing an error in XLS2XForm for the first time that
reads

Conversion Error: ('Element with this name already exists.', [u'

followed by a list of some of the variable names.

has anyone had this same error? I could not find anything on the same
issue on the ODK Community.

thanks,
Pete

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

--
Mike Dalious | Research Director
Invest in Knowledge | Boston USA | Zomba MALAWI
Box 506 Zomba, Malawi
Tel: +265 (0) 888 207 852
Tel: +265 (0) 999 573 769
Email: mike.dalious@investinknowledge.org
Website: http://investinknowledge.org

--
Mike Dalious | Research Director
Invest in Knowledge | Boston USA | Zomba MALAWI
Box 506 Zomba, Malawi
Tel: +265 (0) 888 207 852
Tel: +265 (0) 999 573 769
Email: mike.dalious@investinknowledge.org
Website: http://investinknowledge.org

--
Mike Dalious | Research Director
Invest in Knowledge | Boston USA | Zomba MALAWI
Box 506 Zomba, Malawi
Tel: +265 (0) 888 207 852
Tel: +265 (0) 999 573 769
Email: mike.dalious@investinknowledge.org
Website: http://investinknowledge.org

Hi Mike,

I changed some of the column headers, the most important was changing
"relevance" to "bind:relevant" so that field will show up in the right
place in the XForm. When you convert the attached file you will see an
error message about an invalid XPath expression. ODK Validate doesn't
like the bind:relevant entry that looks like:

${Determine_Result}='invalid', 'indeterminate'

Instead, I think you want to write:

${Determine_Result}='invalid' or ${Determine_Result}='indeterminate'

Hope this helps,

Andrew

ODK_RANDResultsForm111019md.xls (32.5 KB)

··· On Wed, Oct 19, 2011 at 4:53 AM, Mike Dalious wrote: > Hi Andrew, > I need your help again. I took the xls file that you helped us convert to > xml on http://xform-prod.mvpafrica.org/ and added constraints, constraint > messages, relevances (skip patterns), and required fields (xls attached). > When I try to convert the updated xls file > at http://xform-prod.mvpafrica.org/ I get the XML but the added > constraints, constraint messages, relevances (skip patterns), and required > fields do not apply when I transfer the xml to the phone and start filling > out the questionnaire. > I am not XML literate, but I took a look that the xml file (attached) > produced at http://xform-prod.mvpafrica.org/ and it does not seem to contain > the entries for the added fields. I expected some of the additions to not > work due to formatting issues, etc... which I will need to perfect, but > fixing the absence of the xml code for these elements is beyond my skill > level. > I have also created a separate results form using the xls file you sent us > with modifications for the questionnaire and the same problem applies. (Also > attached) > I also tried to convert the xls to xml at http://xls2xform.opendatakit.org/, > but I get similar error messages to those first encountered. "Conversion > Error: ('Unknown question type', u'start time', 'base')" > I would really appreciate your help again. Thanks. > Mike > > > On Mon, Oct 3, 2011 at 10:21 AM, Mike Dalious wrote: >> >> Andrew, >> Thank you for your assistance. I was able to convert the file and we will >> continue to program the skip patterns, etc... >> Should we have any further issues or comments we will be in touch. >> Thanks again, >> Mike Dalious >> >> On Thu, Sep 29, 2011 at 11:09 PM, Andrew Marder wrote: >>> >>> Hi Mike, >>> >>> I made a few edits (see attached) and compiled this file at >>> http://xform-prod.mvpafrica.org/ . If you have any questions it'd be >>> great to have you on xls2xform@googlegroups.com. >>> >>> Andrew >>> >>> On Thu, Sep 29, 2011 at 2:06 AM, Mike Dalious wrote: >>> > Hi Andrew, >>> > Sorry for the delay. I am attaching our xls file now (ending with >>> > 110917md). Also we were able to convert an earlier and much shorter >>> > version >>> > of the same questionnaire. I am also attaching it (ending with >>> > 110831md) >>> > and the corresponding xml. >>> > Thanks for your help. >>> > Mike. >>> > >>> > On Tue, Sep 27, 2011 at 8:54 PM, Andrew Marder wrote: >>> >> >>> >> Hi Pete, >>> >> >>> >> Can you send me your xls file and I'll get back to you asap? >>> >> >>> >> Andrew >>> >> >>> >> On Tue, Sep 27, 2011 at 2:46 PM, Peter Fleming wrote: >>> >> > we're experiencing an error in XLS2XForm for the first time that >>> >> > reads >>> >> > >>> >> > Conversion Error: ('Element with this name already exists.', [u' >>> >> > >>> >> > followed by a list of some of the variable names. >>> >> > >>> >> > has anyone had this same error? I could not find anything on the >>> >> > same >>> >> > issue on the ODK Community. >>> >> > >>> >> > thanks, >>> >> > Pete >>> >> > >>> >> > -- >>> >> > Post: opendatakit@googlegroups.com >>> >> > Unsubscribe: opendatakit+unsubscribe@googlegroups.com >>> >> > Options: http://groups.google.com/group/opendatakit?hl=en >>> >> > >>> > >>> > >>> > >>> > -- >>> > Mike Dalious | Research Director >>> > Invest in Knowledge | Boston USA | Zomba MALAWI >>> > Box 506 Zomba, Malawi >>> > Tel: +265 (0) 888 207 852 >>> > Tel: +265 (0) 999 573 769 >>> > Email: mike.dalious@investinknowledge.org >>> > Website: http://investinknowledge.org >>> > >> >> >> >> -- >> Mike Dalious | Research Director >> Invest in Knowledge | Boston USA | Zomba MALAWI >> Box 506 Zomba, Malawi >> Tel: +265 (0) 888 207 852 >> Tel: +265 (0) 999 573 769 >> Email: mike.dalious@investinknowledge.org >> Website: http://investinknowledge.org > > > > -- > Mike Dalious | Research Director > Invest in Knowledge | Boston USA | Zomba MALAWI > Box 506 Zomba, Malawi > Tel: +265 (0) 888 207 852 > Tel: +265 (0) 999 573 769 > Email: mike.dalious@investinknowledge.org > Website: http://investinknowledge.org >

Andrew,
Thank you very much. I really appreciate your very timely support!

Regards,
Mike

··· On Wed, Oct 19, 2011 at 3:35 PM, Andrew Marder wrote:

Hi Mike,

I changed some of the column headers, the most important was changing
"relevance" to "bind:relevant" so that field will show up in the right
place in the XForm. When you convert the attached file you will see an
error message about an invalid XPath expression. ODK Validate doesn't
like the bind:relevant entry that looks like:

${Determine_Result}='invalid', 'indeterminate'

Instead, I think you want to write:

${Determine_Result}='invalid' or ${Determine_Result}='indeterminate'

Hope this helps,

Andrew

On Wed, Oct 19, 2011 at 4:53 AM, Mike Dalious mike.dalious@investinknowledge.org wrote:

Hi Andrew,
I need your help again. I took the xls file that you helped us convert
to
xml on http://xform-prod.mvpafrica.org/ and added constraints,
constraint
messages, relevances (skip patterns), and required fields (xls attached).
When I try to convert the updated xls file
at http://xform-prod.mvpafrica.org/ I get the XML but the added
constraints, constraint messages, relevances (skip patterns), and
required
fields do not apply when I transfer the xml to the phone and start
filling
out the questionnaire.
I am not XML literate, but I took a look that the xml file (attached)
produced at http://xform-prod.mvpafrica.org/ and it does not seem to
contain
the entries for the added fields. I expected some of the additions to
not
work due to formatting issues, etc... which I will need to perfect, but
fixing the absence of the xml code for these elements is beyond my skill
level.
I have also created a separate results form using the xls file you sent
us
with modifications for the questionnaire and the same problem applies.
(Also
attached)
I also tried to convert the xls to xml at
http://xls2xform.opendatakit.org/,
but I get similar error messages to those first encountered. "Conversion
Error: ('Unknown question type', u'start time', 'base')"
I would really appreciate your help again. Thanks.
Mike

On Mon, Oct 3, 2011 at 10:21 AM, Mike Dalious mike.dalious@investinknowledge.org wrote:

Andrew,
Thank you for your assistance. I was able to convert the file and we
will

continue to program the skip patterns, etc...
Should we have any further issues or comments we will be in touch.
Thanks again,
Mike Dalious

On Thu, Sep 29, 2011 at 11:09 PM, Andrew Marder andrew.ei.marder@gmail.com wrote:

Hi Mike,

I made a few edits (see attached) and compiled this file at
http://xform-prod.mvpafrica.org/ . If you have any questions it'd be
great to have you on xls2xform@googlegroups.com.

Andrew

On Thu, Sep 29, 2011 at 2:06 AM, Mike Dalious mike.dalious@investinknowledge.org wrote:

Hi Andrew,
Sorry for the delay. I am attaching our xls file now (ending with
110917md). Also we were able to convert an earlier and much shorter
version
of the same questionnaire. I am also attaching it (ending with
110831md)
and the corresponding xml.
Thanks for your help.
Mike.

On Tue, Sep 27, 2011 at 8:54 PM, Andrew Marder andrew.ei.marder@gmail.com wrote:

Hi Pete,

Can you send me your xls file and I'll get back to you asap?

Andrew

On Tue, Sep 27, 2011 at 2:46 PM, Peter Fleming <pcfleming@gmail.com wrote:

we're experiencing an error in XLS2XForm for the first time that
reads

Conversion Error: ('Element with this name already exists.', [u'

followed by a list of some of the variable names.

has anyone had this same error? I could not find anything on the
same
issue on the ODK Community.

thanks,
Pete

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

--
Mike Dalious | Research Director
Invest in Knowledge | Boston USA | Zomba MALAWI
Box 506 Zomba, Malawi
Tel: +265 (0) 888 207 852
Tel: +265 (0) 999 573 769
Email: mike.dalious@investinknowledge.org
Website: http://investinknowledge.org

--
Mike Dalious | Research Director
Invest in Knowledge | Boston USA | Zomba MALAWI
Box 506 Zomba, Malawi
Tel: +265 (0) 888 207 852
Tel: +265 (0) 999 573 769
Email: mike.dalious@investinknowledge.org
Website: http://investinknowledge.org

--
Mike Dalious | Research Director
Invest in Knowledge | Boston USA | Zomba MALAWI
Box 506 Zomba, Malawi
Tel: +265 (0) 888 207 852
Tel: +265 (0) 999 573 769
Email: mike.dalious@investinknowledge.org
Website: http://investinknowledge.org

--
Mike Dalious | Research Director
Invest in Knowledge | Boston USA | Zomba MALAWI
Box 506 Zomba, Malawi
Tel: +265 (0) 888 207 852
Tel: +265 (0) 999 573 769
Email: mike.dalious@investinknowledge.org
Website: http://investinknowledge.org