"Enabling external selects is straightforward. - Instead of select_one for the prompt type, use select_one_external. - Instead of the choices sheet, put external choices in the external_choices sheet."
I am following all the steps listed in that article (creation of an "external_choices" sheet, referencing it properly on the survey sheet, etc), but
when I convert the xlsform into an XML form, the itemsets.csv fails to be created, and
obviously, when loaded on the ODKCollect, the field set for external selects displays "itemsets.csv is missing".
As I am not finding any literature referencing the external_choices usage (apart from the xlsform.org article), I am wondering if this is a real feature or maybe something which is still work-in-progress and not working on the latest xlsform converter versión.
"Enabling external selects is straightforward. - Instead of select_one for the prompt type, use select_one_external. - Instead of the choices sheet, put external choices in the external_choices sheet."
I am following all the steps listed in that article (creation of an "external_choices" sheet, referencing it properly on the survey sheet, etc), but
when I convert the xlsform into an XML form, the itemsets.csv fails to be created, and
obviously, when loaded on the ODKCollect, the field set for external selects displays "itemsets.csv is missing".
As I am not finding any literature referencing the external_choices usage (apart from the xlsform.org article), I am wondering if this is a real feature or maybe something which is still work-in-progress and not working on the latest xlsform converter versión.
I tried to use the previous version of this same converter and it failed to recognize the expression "select_one_external". The one I am using now (the latest available, according to the ODK site) does not return any errors on the xls-xml converting process, but fails to transform the external_choices sheet on the itemsets.csv (needed to feed the choice list for two of the questions in my survey).
Any help would be most appreciated!
Pablo
PS. Just to clarify, on the xlsform I have the three standard sheets plus one named external_choices.
On the survey sheet, I have used the expression type select_one_external plus the name of the list ("country" and "base" in my case), with a constraint expression (list=${name of previously selected list}) on the choice_filter column.
And on the external_choices sheet, I have added an extra column to enable cascading.
···
On Wednesday, November 26, 2014 9:24:04 PM UTC+1, Yaw Anokwa wrote:
> What form converter are you using? I just tried XLSForm Offline
> (https://gumroad.com/l/xlsform-offline) and it worked great.
>
> Yaw
> --
> Need ODK services? http://nafundi.com provides form design, server
> setup, professional support, and software development for ODK.
>
> On Wed, Nov 26, 2014 at 11:19 AM, wrote:
> > Hello all,
> >
> > After checking on xlsform.org, I found this:
> >
> > "Enabling external selects is straightforward. - Instead of select_one for the prompt type, use select_one_external. - Instead of the choices sheet, put external choices in the external_choices sheet."
> >
> > I am following all the steps listed in that article (creation of an "external_choices" sheet, referencing it properly on the survey sheet, etc), but
> > 1) when I convert the xlsform into an XML form, the itemsets.csv fails to be created, and
> >
> > 2) obviously, when loaded on the ODKCollect, the field set for external selects displays "itemsets.csv is missing".
> >
> > As I am not finding any literature referencing the external_choices usage (apart from the xlsform.org article), I am wondering if this is a real feature or maybe something which is still work-in-progress and not working on the latest xlsform converter versión.
> >
> > Thanks a lot for your help!
> >
> > --
> > --
> > 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.
I tried to use the previous version of this same converter and it failed to recognize the expression "select_one_external". The one I am using now (the latest available, according to the ODK site) does not return any errors on the xls-xml converting process, but fails to transform the external_choices sheet on the itemsets.csv (needed to feed the choice list for two of the questions in my survey).
Any help would be most appreciated!
Pablo
PS. Just to clarify, on the xlsform I have the three standard sheets plus one named external_choices.
On the survey sheet, I have used the expression type select_one_external plus the name of the list ("country" and "base" in my case), with a constraint expression (list=${name of previously selected list}) on the choice_filter column.
And on the external_choices sheet, I have added an extra column to enable cascading.
On Wednesday, November 26, 2014 9:24:04 PM UTC+1, Yaw Anokwa wrote:
"Enabling external selects is straightforward. - Instead of select_one for the prompt type, use select_one_external. - Instead of the choices sheet, put external choices in the external_choices sheet."
I am following all the steps listed in that article (creation of an "external_choices" sheet, referencing it properly on the survey sheet, etc), but
when I convert the xlsform into an XML form, the itemsets.csv fails to be created, and
obviously, when loaded on the ODKCollect, the field set for external selects displays "itemsets.csv is missing".
As I am not finding any literature referencing the external_choices usage (apart from the xlsform.org article), I am wondering if this is a real feature or maybe something which is still work-in-progress and not working on the latest xlsform converter versión.
I have just tried your form on the xlsform converter for Windows, and it does not create itemsets.csv, so I guess the problem is the converter.
Thanks a lot for helping me! I will try to get a different converter and see if it Works (I am sure my form has still a number of errors, but of course the first step is to get a converter that works properly).
Thanks again!
Pablo
···
On Thursday, November 27, 2014 2:06:38 PM UTC+1, Yaw Anokwa wrote:
> Pablo,
>
> Attached is a sample form that works with XLSForm Offline.
>
> Does it work in the xlsform converter for Windows you downloaded? If
> no, there is a bug in that converter. If yes, then there is a bug in
> your form.
>
> Yaw
> --
> Need ODK services? http://nafundi.com provides form design, server
> setup, professional support, and software development for ODK.
>
> On Thu, Nov 27, 2014 at 5:17 AM, <> wrote:
> > Hello Yaw,
> >
> > Thanks for replying! I am using xlsform converter for Windows, the one you can find at https://opendatakit.org/downloads/download-info/xlsform-for-windows/, on its version 0.9.21_rev_1.4.4
> >
> > I tried to use the previous version of this same converter and it failed to recognize the expression "select_one_external". The one I am using now (the latest available, according to the ODK site) does not return any errors on the xls-xml converting process, but fails to transform the external_choices sheet on the itemsets.csv (needed to feed the choice list for two of the questions in my survey).
> >
> > Any help would be most appreciated!
> >
> > Pablo
> >
> > PS. Just to clarify, on the xlsform I have the three standard sheets plus one named external_choices.
> >
> > On the survey sheet, I have used the expression type select_one_external plus the name of the list ("country" and "base" in my case), with a constraint expression (list=${name of previously selected list}) on the choice_filter column.
> >
> > And on the external_choices sheet, I have added an extra column to enable cascading.
> >
> >
> > On Wednesday, November 26, 2014 9:24:04 PM UTC+1, Yaw Anokwa wrote:
> >> What form converter are you using? I just tried XLSForm Offline
> >> (https://gumroad.com/l/xlsform-offline) and it worked great.
> >>
> >> Yaw
> >> --
> >> Need ODK services? http://nafundi.com provides form design, server
> >> setup, professional support, and software development for ODK.
> >>
> >> On Wed, Nov 26, 2014 at 11:19 AM, <> wrote:
> >> > Hello all,
> >> >
> >> > After checking on xlsform.org, I found this:
> >> >
> >> > "Enabling external selects is straightforward. - Instead of select_one for the prompt type, use select_one_external. - Instead of the choices sheet, put external choices in the external_choices sheet."
> >> >
> >> > I am following all the steps listed in that article (creation of an "external_choices" sheet, referencing it properly on the survey sheet, etc), but
> >> > 1) when I convert the xlsform into an XML form, the itemsets.csv fails to be created, and
> >> >
> >> > 2) obviously, when loaded on the ODKCollect, the field set for external selects displays "itemsets.csv is missing".
> >> >
> >> > As I am not finding any literature referencing the external_choices usage (apart from the xlsform.org article), I am wondering if this is a real feature or maybe something which is still work-in-progress and not working on the latest xlsform converter versión.
> >> >
> >> > Thanks a lot for your help!
> >> >
> >> > --
> >> > --
> >> > 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.
> >
> > --
> > --
> > 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.
I have just tried to converte the sample form you sent over with Enketo, and again it fails to create the .csv needed. Because of this, when I load the form it fails to display the cascading options after the first select_one question.
It just seems odd to me none of the available converters (but for Nafundi´s xlsform) works with the select_one_external type of question. Any clue about why? Anyone else that has tried that option? I can´t seem to find anyone else who has used this, most people resorts to pull_data + search and to creating their own .csv
Sorry for insisting on this, but I just want to understand what´s happening
Thanks again!
Pablo
···
On Thursday, November 27, 2014 2:06:38 PM UTC+1, Yaw Anokwa wrote:
> Pablo,
>
> Attached is a sample form that works with XLSForm Offline.
>
> Does it work in the xlsform converter for Windows you downloaded? If
> no, there is a bug in that converter. If yes, then there is a bug in
> your form.
>
> Yaw
> --
> Need ODK services? http://nafundi.com provides form design, server
> setup, professional support, and software development for ODK.
>
> On Thu, Nov 27, 2014 at 5:17 AM, <> wrote:
> > Hello Yaw,
> >
> > Thanks for replying! I am using xlsform converter for Windows, the one you can find at https://opendatakit.org/downloads/download-info/xlsform-for-windows/, on its version 0.9.21_rev_1.4.4
> >
> > I tried to use the previous version of this same converter and it failed to recognize the expression "select_one_external". The one I am using now (the latest available, according to the ODK site) does not return any errors on the xls-xml converting process, but fails to transform the external_choices sheet on the itemsets.csv (needed to feed the choice list for two of the questions in my survey).
> >
> > Any help would be most appreciated!
> >
> > Pablo
> >
> > PS. Just to clarify, on the xlsform I have the three standard sheets plus one named external_choices.
> >
> > On the survey sheet, I have used the expression type select_one_external plus the name of the list ("country" and "base" in my case), with a constraint expression (list=${name of previously selected list}) on the choice_filter column.
> >
> > And on the external_choices sheet, I have added an extra column to enable cascading.
> >
> >
> > On Wednesday, November 26, 2014 9:24:04 PM UTC+1, Yaw Anokwa wrote:
> >> What form converter are you using? I just tried XLSForm Offline
> >> (https://gumroad.com/l/xlsform-offline) and it worked great.
> >>
> >> Yaw
> >> --
> >> Need ODK services? http://nafundi.com provides form design, server
> >> setup, professional support, and software development for ODK.
> >>
> >> On Wed, Nov 26, 2014 at 11:19 AM, <> wrote:
> >> > Hello all,
> >> >
> >> > After checking on xlsform.org, I found this:
> >> >
> >> > "Enabling external selects is straightforward. - Instead of select_one for the prompt type, use select_one_external. - Instead of the choices sheet, put external choices in the external_choices sheet."
> >> >
> >> > I am following all the steps listed in that article (creation of an "external_choices" sheet, referencing it properly on the survey sheet, etc), but
> >> > 1) when I convert the xlsform into an XML form, the itemsets.csv fails to be created, and
> >> >
> >> > 2) obviously, when loaded on the ODKCollect, the field set for external selects displays "itemsets.csv is missing".
> >> >
> >> > As I am not finding any literature referencing the external_choices usage (apart from the xlsform.org article), I am wondering if this is a real feature or maybe something which is still work-in-progress and not working on the latest xlsform converter versión.
> >> >
> >> > Thanks a lot for your help!
> >> >
> >> > --
> >> > --
> >> > 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.
> >
> > --
> > --
> > 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.
I have just tried to converte the sample form you sent over with Enketo, and again it fails to create the .csv needed. Because of this, when I load the form it fails to display the cascading options after the first select_one question.
It just seems odd to me none of the available converters (but for Nafundi´s xlsform) works with the select_one_external type of question. Any clue about why? Anyone else that has tried that option? I can´t seem to find anyone else who has used this, most people resorts to pull_data + search and to creating their own .csv
Sorry for insisting on this, but I just want to understand what´s happening
Thanks again!
Pablo
On Thursday, November 27, 2014 2:06:38 PM UTC+1, Yaw Anokwa wrote:
Pablo,
Attached is a sample form that works with XLSForm Offline.
Does it work in the xlsform converter for Windows you downloaded? If
no, there is a bug in that converter. If yes, then there is a bug in
your form.
Yaw
Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.
I tried to use the previous version of this same converter and it failed to recognize the expression "select_one_external". The one I am using now (the latest available, according to the ODK site) does not return any errors on the xls-xml converting process, but fails to transform the external_choices sheet on the itemsets.csv (needed to feed the choice list for two of the questions in my survey).
Any help would be most appreciated!
Pablo
PS. Just to clarify, on the xlsform I have the three standard sheets plus one named external_choices.
On the survey sheet, I have used the expression type select_one_external plus the name of the list ("country" and "base" in my case), with a constraint expression (list=${name of previously selected list}) on the choice_filter column.
And on the external_choices sheet, I have added an extra column to enable cascading.
On Wednesday, November 26, 2014 9:24:04 PM UTC+1, Yaw Anokwa wrote:
"Enabling external selects is straightforward. - Instead of select_one for the prompt type, use select_one_external. - Instead of the choices sheet, put external choices in the external_choices sheet."
I am following all the steps listed in that article (creation of an "external_choices" sheet, referencing it properly on the survey sheet, etc), but
when I convert the xlsform into an XML form, the itemsets.csv fails to be created, and
obviously, when loaded on the ODKCollect, the field set for external selects displays "itemsets.csv is missing".
As I am not finding any literature referencing the external_choices usage (apart from the xlsform.org article), I am wondering if this is a real feature or maybe something which is still work-in-progress and not working on the latest xlsform converter versión.