Cannot convert xls form

Hello everyone!

I am trying to convert my xls form to xml form. The form contains a number
of relevant field. I am receiving the following error while I am trying to
convert the form ODK online converter: Error: ODK Validate Errors:
XForm Parse Error: Encountered a problem with display condition for node
[${accredition_board}] at line: selected( ${accredition_info} , ?yes?),
Couldn't understand the expression starting at this point: ...edition_info
,??yes?) org.javarosa.xform.parse.XFormParseException: Encountered a
problem with display condition for node [${accredition_board}] at line:
selected( ${accredition_info} , ?yes?), Couldn't understand the expression
starting at this point: ...edition_info ,??yes?) >> XForm is invalid. See
above for the errors. Result: Invalid

and error message from offline converter: Input file: F:\Google
Drive\Work\Upcoming Assignments\Malawi eSupervision
checklist\hiv_lab_esupervision_checklist2.xlsx

Conversion errors:
'ascii' codec can't decode byte 0x91 in position 137: ordinal not in
range(128)

without the relevant field, the form is converting fine. Previously I have
used relevant on many other forms and it worked without any problem.

part of my form looks like this:
type name label appearance choice_filter default hint required relevant
start start
end end
today today
deviceid deviceid
imei imei
phonenumber phonenumber
username username
select_one yes_no accredition_info Is the lab accredited?
text accredition_board If Accredited specify Accrediting Board selected(${accredition_info},
‘yes’)

Please help me out, if you can encounter the mistake I am making.

Thanks
Imran

Hi,

Yes for the condition is supposed to have single quotation marks, its looks
like you have ? marks, that is 'yes'

Best and Regards
Ronald Munjoma

··· On 14 May 2016 at 09:21, A.N.M AL-IMRAN wrote:

Hello everyone!

I am trying to convert my xls form to xml form. The form contains a number
of relevant field. I am receiving the following error while I am trying to
convert the form ODK online converter: Error: ODK Validate Errors:
XForm Parse Error: Encountered a problem with display condition for node
[${accredition_board}] at line: selected( ${accredition_info} , ?yes?),
Couldn't understand the expression starting at this point: ...edition_info
,??yes?) org.javarosa.xform.parse.XFormParseException: Encountered a
problem with display condition for node [${accredition_board}] at line:
selected( ${accredition_info} , ?yes?), Couldn't understand the expression
starting at this point: ...edition_info ,??yes?) >> XForm is invalid. See
above for the errors. Result: Invalid

and error message from offline converter: Input file: F:\Google
Drive\Work\Upcoming Assignments\Malawi eSupervision
checklist\hiv_lab_esupervision_checklist2.xlsx

Conversion errors:
'ascii' codec can't decode byte 0x91 in position 137: ordinal not in
range(128)

without the relevant field, the form is converting fine. Previously I have
used relevant on many other forms and it worked without any problem.

part of my form looks like this:
type name label appearance choice_filter default hint required relevant
start start
end end
today today
deviceid deviceid
imei imei
phonenumber phonenumber
username username
select_one yes_no accredition_info Is the lab accredited?
text accredition_board If Accredited specify Accrediting Board selected(${accredition_info},
‘yes’)

Please help me out, if you can encounter the mistake I am making.

Thanks
Imran

--

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.

--
Best and Regards
Ronald Munjoma
+263 775 625 283

[image: --]

Ronald Munjoma
[image: https://]about.me/ronaldmunjoma
https://about.me/ronaldmunjoma?promo=email_sig

Thanks Ronald, Yes I have tried all different ways. even there is two
different ways to write it and I have tried in both ways. seems like
something is wrong with the skip logic. I created a separate small test
form and relevant function is working fine there. The form I am
experiencing problem with is a bit big, it has around 200 columns 16 skip
logic and around 15 groups. I am trying to figure out what is the issue.
When I am removing the relevant function, then it is converting to XML
without any problem.

All of your suggestions will be appreciated.

Thanks
Imran

··· On Saturday, May 14, 2016 at 7:26:06 AM UTC-4, Ronald Munjoma wrote: > > Hi, > > Yes for the condition is supposed to have single quotation marks, its > looks like you have ? marks, that is 'yes' > > Best and Regards > Ronald Munjoma > > On 14 May 2016 at 09:21, A.N.M AL-IMRAN <imra...@gmail.com > wrote: > >> Hello everyone! >> >> I am trying to convert my xls form to xml form. The form contains a >> number of relevant field. I am receiving the following error while I am >> trying to convert the form ODK online converter: Error: ODK Validate >> Errors: >> XForm Parse Error: Encountered a problem with display condition for node >> [${accredition_board}] at line: selected( ${accredition_info} , ?yes?), >> Couldn't understand the expression starting at this point: ...edition_info >> ,??yes?) org.javarosa.xform.parse.XFormParseException: Encountered a >> problem with display condition for node [${accredition_board}] at line: >> selected( ${accredition_info} , ?yes?), Couldn't understand the expression >> starting at this point: ...edition_info ,??yes?) >> XForm is invalid. See >> above for the errors. Result: Invalid >> >> and error message from offline converter: Input file: F:\Google >> Drive\Work\Upcoming Assignments\Malawi eSupervision >> checklist\hiv_lab_esupervision_checklist2.xlsx >> >> Conversion errors: >> 'ascii' codec can't decode byte 0x91 in position 137: ordinal not in >> range(128) >> >> >> without the relevant field, the form is converting fine. Previously I >> have used relevant on many other forms and it worked without any problem. >> >> part of my form looks like this: >> type name label appearance choice_filter default hint required relevant >> start start >> end end >> today today >> deviceid deviceid >> imei imei >> phonenumber phonenumber >> username username >> select_one yes_no accredition_info Is the lab accredited? >> text accredition_board If Accredited specify Accrediting Board selected(${accredition_info}, >> ‘yes’) >> >> Please help me out, if you can encounter the mistake I am making. >> >> Thanks >> Imran >> >> -- >> -- >> 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. >> > > > > -- > Best and Regards > Ronald Munjoma > +263 775 625 283 > > > [image: --] > > Ronald Munjoma > [image: https://]about.me/ronaldmunjoma > >

Hi Imran

Please share the form if you can.

Best and Regards
Ronald Munjoma

··· On 16 May 2016 at 16:32, A.N.M AL-IMRAN wrote:

Thanks Ronald, Yes I have tried all different ways. even there is two
different ways to write it and I have tried in both ways. seems like
something is wrong with the skip logic. I created a separate small test
form and relevant function is working fine there. The form I am
experiencing problem with is a bit big, it has around 200 columns 16 skip
logic and around 15 groups. I am trying to figure out what is the issue.
When I am removing the relevant function, then it is converting to XML
without any problem.

All of your suggestions will be appreciated.

Thanks
Imran

On Saturday, May 14, 2016 at 7:26:06 AM UTC-4, Ronald Munjoma wrote:

Hi,

Yes for the condition is supposed to have single quotation marks, its
looks like you have ? marks, that is 'yes'

Best and Regards
Ronald Munjoma

On 14 May 2016 at 09:21, A.N.M AL-IMRAN imra...@gmail.com wrote:

Hello everyone!

I am trying to convert my xls form to xml form. The form contains a
number of relevant field. I am receiving the following error while I am
trying to convert the form ODK online converter: Error: ODK Validate
Errors:
XForm Parse Error: Encountered a problem with display condition for node
[${accredition_board}] at line: selected( ${accredition_info} , ?yes?),
Couldn't understand the expression starting at this point: ...edition_info
,??yes?) org.javarosa.xform.parse.XFormParseException: Encountered a
problem with display condition for node [${accredition_board}] at line:
selected( ${accredition_info} , ?yes?), Couldn't understand the expression
starting at this point: ...edition_info ,??yes?) >> XForm is invalid. See
above for the errors. Result: Invalid

and error message from offline converter: Input file: F:\Google
Drive\Work\Upcoming Assignments\Malawi eSupervision
checklist\hiv_lab_esupervision_checklist2.xlsx

Conversion errors:
'ascii' codec can't decode byte 0x91 in position 137: ordinal not in
range(128)

without the relevant field, the form is converting fine. Previously I
have used relevant on many other forms and it worked without any problem.

part of my form looks like this:
type name label appearance choice_filter default hint required relevant
start start
end end
today today
deviceid deviceid
imei imei
phonenumber phonenumber
username username
select_one yes_no accredition_info Is the lab accredited?
text accredition_board If Accredited specify Accrediting Board selected(${accredition_info},
‘yes’)

Please help me out, if you can encounter the mistake I am making.

Thanks
Imran

--

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.

--
Best and Regards
Ronald Munjoma
+263 775 625 283

[image: --]

Ronald Munjoma
[image: https://]about.me/ronaldmunjoma
https://about.me/ronaldmunjoma?promo=email_sig

--

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.

--
Best and Regards
Ronald Munjoma
+263 775 625 283

[image: --]

Ronald Munjoma
[image: https://]about.me/ronaldmunjoma
https://about.me/ronaldmunjoma?promo=email_sig

Thanks a lot Ronald,

Problem resolved and let me explain, what was wrong for everyone's
information: I copied the formula from a website and copy from website
comes up with some hidden special characters. So advice for everyone, its
better to type by yourself.

Thanks
Imran

··· On Monday, May 16, 2016 at 10:47:06 AM UTC-4, Ronald Munjoma wrote: > > Hi Imran > > Please share the form if you can. > > Best and Regards > Ronald Munjoma > > On 16 May 2016 at 16:32, A.N.M AL-IMRAN <imra...@gmail.com > wrote: > >> Thanks Ronald, Yes I have tried all different ways. even there is two >> different ways to write it and I have tried in both ways. seems like >> something is wrong with the skip logic. I created a separate small test >> form and relevant function is working fine there. The form I am >> experiencing problem with is a bit big, it has around 200 columns 16 skip >> logic and around 15 groups. I am trying to figure out what is the issue. >> When I am removing the relevant function, then it is converting to XML >> without any problem. >> >> All of your suggestions will be appreciated. >> >> Thanks >> Imran >> >> On Saturday, May 14, 2016 at 7:26:06 AM UTC-4, Ronald Munjoma wrote: >>> >>> Hi, >>> >>> Yes for the condition is supposed to have single quotation marks, its >>> looks like you have ? marks, that is 'yes' >>> >>> Best and Regards >>> Ronald Munjoma >>> >>> On 14 May 2016 at 09:21, A.N.M AL-IMRAN wrote: >>> >>>> Hello everyone! >>>> >>>> I am trying to convert my xls form to xml form. The form contains a >>>> number of relevant field. I am receiving the following error while I am >>>> trying to convert the form ODK online converter: Error: ODK Validate >>>> Errors: >>>> XForm Parse Error: Encountered a problem with display condition for >>>> node [${accredition_board}] at line: selected( ${accredition_info} , >>>> ?yes?), Couldn't understand the expression starting at this point: >>>> ...edition_info ,??yes?) org.javarosa.xform.parse.XFormParseException: >>>> Encountered a problem with display condition for node >>>> [${accredition_board}] at line: selected( ${accredition_info} , ?yes?), >>>> Couldn't understand the expression starting at this point: ...edition_info >>>> ,??yes?) >> XForm is invalid. See above for the errors. Result: Invalid >>>> >>>> and error message from offline converter: Input file: F:\Google >>>> Drive\Work\Upcoming Assignments\Malawi eSupervision >>>> checklist\hiv_lab_esupervision_checklist2.xlsx >>>> >>>> Conversion errors: >>>> 'ascii' codec can't decode byte 0x91 in position 137: ordinal not in >>>> range(128) >>>> >>>> >>>> without the relevant field, the form is converting fine. Previously I >>>> have used relevant on many other forms and it worked without any problem. >>>> >>>> part of my form looks like this: >>>> type name label appearance choice_filter default hint required relevant >>>> start start >>>> end end >>>> today today >>>> deviceid deviceid >>>> imei imei >>>> phonenumber phonenumber >>>> username username >>>> select_one yes_no accredition_info Is the lab accredited? >>>> text accredition_board If Accredited specify Accrediting Board selected(${accredition_info}, >>>> ‘yes’) >>>> >>>> Please help me out, if you can encounter the mistake I am making. >>>> >>>> Thanks >>>> Imran >>>> >>>> -- >>>> -- >>>> 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. >>>> >>> >>> >>> >>> -- >>> Best and Regards >>> Ronald Munjoma >>> +263 775 625 283 >>> >>> >>> [image: --] >>> >>> Ronald Munjoma >>> [image: https://]about.me/ronaldmunjoma >>> >>> >> -- >> -- >> 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. >> > > > > -- > Best and Regards > Ronald Munjoma > +263 775 625 283 > > > [image: --] > > Ronald Munjoma > [image: https://]about.me/ronaldmunjoma > >