External select (select one) doens't recognise numeric filter

Dear all,

I was encountering an issue with filtering for external select function in
xlsform. After some searches in this forum, I didn't see any thread stating
this issue. So I was trying to solve this issue myself, using ODK's south
sudan example.

After some testing and examining xml & csv files, I realised that ODK
Collect's select_one_external won't work if you have your filter as numeric
values (e.g. 1, 2, 3, 4, etc) . I figured this out after changing column
"name" 's value in South Sudan example (from ODK Help) to numeric value
instead of short alphabetic values, then test it on ODK Collect and as
expected, no choice items were displayed after "state" . So I went back to
check itemsets.csv files and found that all numeric values are converted in
to decimal format (e.g. 1 = "1.0", 2 = "2.0", etc.) . (find attached files)

So that means, unless numeric values for name include ".0", ODK Collect
won't be able to display cascaded selection of choices. A quick work around
that I used was to remove ".0" in itemsets.csv file. This has work like
charms.

To conclude: 2 ways of fixing numeric value sets for select_one_external -
make value set in column "name" - decimal. Or remove ".0" in itemsets.csv
file after compiling from xlsform.

Find find attached files for clearer understanding.

Regards all.

Hung.

south_sudan_2.xml (1.77 KB)

itemsets.csv (298 Bytes)

itemsets(edited).csv (270 Bytes)

south_sudan_2.xls (10 KB)

Thanks for sharing your findings, Hung.

Yaw

··· -- Need ODK consultants? https://nafundi.com provides form design, server setup, in-field training, and software development for ODK.

On Mon, Oct 19, 2015 at 3:12 PM, Hung Pham hpham2709@gmail.com wrote:

Dear all,

I was encountering an issue with filtering for external select function in
xlsform. After some searches in this forum, I didn't see any thread stating
this issue. So I was trying to solve this issue myself, using ODK's south
sudan example.

After some testing and examining xml & csv files, I realised that ODK
Collect's select_one_external won't work if you have your filter as numeric
values (e.g. 1, 2, 3, 4, etc) . I figured this out after changing column
"name" 's value in South Sudan example (from ODK Help) to numeric value
instead of short alphabetic values, then test it on ODK Collect and as
expected, no choice items were displayed after "state" . So I went back to
check itemsets.csv files and found that all numeric values are converted in
to decimal format (e.g. 1 = "1.0", 2 = "2.0", etc.) . (find attached files)

So that means, unless numeric values for name include ".0", ODK Collect
won't be able to display cascaded selection of choices. A quick work around
that I used was to remove ".0" in itemsets.csv file. This has work like
charms.

To conclude: 2 ways of fixing numeric value sets for select_one_external -
make value set in column "name" - decimal. Or remove ".0" in itemsets.csv
file after compiling from xlsform.

Find find attached files for clearer understanding.

Regards all.

Hung.

--

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 deployed the south_sudan_2.xls file.

But after selecting any state, it doesnot show any county on web form. A normal text box appears.

Any idea why?
How to make it the respective county visible?

Parth Saha

··· On Monday, 19 October 2015 13:42:10 UTC+5:30, Hung Pham wrote: > Dear all, > > I was encountering an issue with filtering for external select function in xlsform. After some searches in this forum, I didn't see any thread stating this issue. So I was trying to solve this issue myself, using ODK's south sudan example. > > After some testing and examining xml & csv files, I realised that ODK Collect's select_one_external won't work if you have your filter as numeric values (e.g. 1, 2, 3, 4, etc) . I figured this out after changing column "name" 's value in South Sudan example (from ODK Help) to numeric value instead of short alphabetic values, then test it on ODK Collect and as expected, no choice items were displayed after "state" . So I went back to check itemsets.csv files and found that all numeric values are converted in to decimal format (e.g. 1 = "1.0", 2 = "2.0", etc.) . (find attached files) > > So that means, unless numeric values for name include ".0", ODK Collect won't be able to display cascaded selection of choices. A quick work around that I used was to remove ".0" in itemsets.csv file. This has work like charms. > > To conclude: 2 ways of fixing numeric value sets for select_one_external - make value set in column "name" - decimal. Or remove ".0" in itemsets.csv file after compiling from xlsform. > > Find find attached files for clearer understanding. > > Regards all. > > > Hung. > > >

Dear Hung!

On the web https://opendatakit.org/help/form-design/workarounds/ there is provided a topic indexed-repeat failure before adding 2nd repeat group

I kindly ask to provide an .xls example. Because it is still not clear for me how to use indexed-repeat(..)

Dear Hung,
can you help me in same problem, i tried but failed.
can you reply me on waqarahmadcro@gmail.com

··· On Monday, October 19, 2015 at 1:12:10 PM UTC+5, Hung Pham wrote: > Dear all, > > I was encountering an issue with filtering for external select function in xlsform. After some searches in this forum, I didn't see any thread stating this issue. So I was trying to solve this issue myself, using ODK's south sudan example. > > After some testing and examining xml & csv files, I realised that ODK Collect's select_one_external won't work if you have your filter as numeric values (e.g. 1, 2, 3, 4, etc) . I figured this out after changing column "name" 's value in South Sudan example (from ODK Help) to numeric value instead of short alphabetic values, then test it on ODK Collect and as expected, no choice items were displayed after "state" . So I went back to check itemsets.csv files and found that all numeric values are converted in to decimal format (e.g. 1 = "1.0", 2 = "2.0", etc.) . (find attached files) > > So that means, unless numeric values for name include ".0", ODK Collect won't be able to display cascaded selection of choices. A quick work around that I used was to remove ".0" in itemsets.csv file. This has work like charms. > > To conclude: 2 ways of fixing numeric value sets for select_one_external - make value set in column "name" - decimal. Or remove ".0" in itemsets.csv file after compiling from xlsform. > > Find find attached files for clearer understanding. > > Regards all. > > > Hung. > > >

dear Hung,
i tried but didn't succeeded. it works for alphabetic data but don't works for codes or digits in choice/casecading. you can try the attached files, \

PEI_Training codes.xlsx (1.16 MB)

PEI_Training.xlsx (1.13 MB)

Thanks. Added this to the bottom of the Gotchas page:
https://opendatakit.org/help/form-design/workarounds/

··· On Tue, Oct 20, 2015 at 9:32 AM, Yaw Anokwa wrote:

Thanks for sharing your findings, Hung.

Yaw

Need ODK consultants? https://nafundi.com provides form design, server
setup, in-field training, and software development for ODK.

On Mon, Oct 19, 2015 at 3:12 PM, Hung Pham hpham2709@gmail.com wrote:

Dear all,

I was encountering an issue with filtering for external select function
in
xlsform. After some searches in this forum, I didn't see any thread
stating
this issue. So I was trying to solve this issue myself, using ODK's south
sudan example.

After some testing and examining xml & csv files, I realised that ODK
Collect's select_one_external won't work if you have your filter as
numeric
values (e.g. 1, 2, 3, 4, etc) . I figured this out after changing column
"name" 's value in South Sudan example (from ODK Help) to numeric value
instead of short alphabetic values, then test it on ODK Collect and as
expected, no choice items were displayed after "state" . So I went back
to
check itemsets.csv files and found that all numeric values are converted
in
to decimal format (e.g. 1 = "1.0", 2 = "2.0", etc.) . (find attached
files)

So that means, unless numeric values for name include ".0", ODK Collect
won't be able to display cascaded selection of choices. A quick work
around
that I used was to remove ".0" in itemsets.csv file. This has work like
charms.

To conclude: 2 ways of fixing numeric value sets for select_one_external

make value set in column "name" - decimal. Or remove ".0" in itemsets.csv
file after compiling from xlsform.

Find find attached files for clearer understanding.

Regards all.

Hung.

--

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.

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

Parth,

What web form? Are you using ODK Collect or something else?

Yaw

··· -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Tue, Apr 19, 2016 at 8:13 AM, parthsaha@gmail.com wrote:

On Monday, 19 October 2015 13:42:10 UTC+5:30, Hung Pham wrote:

Dear all,

I was encountering an issue with filtering for external select function in xlsform. After some searches in this forum, I didn't see any thread stating this issue. So I was trying to solve this issue myself, using ODK's south sudan example.

After some testing and examining xml & csv files, I realised that ODK Collect's select_one_external won't work if you have your filter as numeric values (e.g. 1, 2, 3, 4, etc) . I figured this out after changing column "name" 's value in South Sudan example (from ODK Help) to numeric value instead of short alphabetic values, then test it on ODK Collect and as expected, no choice items were displayed after "state" . So I went back to check itemsets.csv files and found that all numeric values are converted in to decimal format (e.g. 1 = "1.0", 2 = "2.0", etc.) . (find attached files)

So that means, unless numeric values for name include ".0", ODK Collect won't be able to display cascaded selection of choices. A quick work around that I used was to remove ".0" in itemsets.csv file. This has work like charms.

To conclude: 2 ways of fixing numeric value sets for select_one_external - make value set in column "name" - decimal. Or remove ".0" in itemsets.csv file after compiling from xlsform.

Find find attached files for clearer understanding.

Regards all.

Hung.

I deployed the south_sudan_2.xls file.

But after selecting any state, it doesnot show any county on web form. A normal text box appears.

Any idea why?
How to make it the respective county visible?

Parth Saha

--

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.

can anyone guide

I deployed the file that you had provided to Kobotoolbox. But in enketo,
only a text box appears not the list of county based on state.

Actually the select_one_external is not working in enketo but it works on
android phone/Odk collect.

I hope it answers your question.

Thanks for replying.

Parth

··· On Tuesday 3 May 2016, Yaw Anokwa wrote:

Parth,

What web form? Are you using ODK Collect or something else?

Yaw

Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.

On Tue, Apr 19, 2016 at 8:13 AM, <parthsaha@gmail.com <javascript:;>> wrote:

On Monday, 19 October 2015 13:42:10 UTC+5:30, Hung Pham wrote:

Dear all,

I was encountering an issue with filtering for external select function
in xlsform. After some searches in this forum, I didn't see any thread
stating this issue. So I was trying to solve this issue myself, using ODK's
south sudan example.

After some testing and examining xml & csv files, I realised that ODK
Collect's select_one_external won't work if you have your filter as numeric
values (e.g. 1, 2, 3, 4, etc) . I figured this out after changing column
"name" 's value in South Sudan example (from ODK Help) to numeric value
instead of short alphabetic values, then test it on ODK Collect and as
expected, no choice items were displayed after "state" . So I went back to
check itemsets.csv files and found that all numeric values are converted in
to decimal format (e.g. 1 = "1.0", 2 = "2.0", etc.) . (find attached files)

So that means, unless numeric values for name include ".0", ODK Collect
won't be able to display cascaded selection of choices. A quick work around
that I used was to remove ".0" in itemsets.csv file. This has work like
charms.

To conclude: 2 ways of fixing numeric value sets for
select_one_external - make value set in column "name" - decimal. Or remove
".0" in itemsets.csv file after compiling from xlsform.

Find find attached files for clearer understanding.

Regards all.

Hung.

I deployed the south_sudan_2.xls file.

But after selecting any state, it doesnot show any county on web form. A
normal text box appears.

Any idea why?
How to make it the respective county visible?

Parth Saha

--

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

--

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


You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/dVSIfMnnSaU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com <javascript:;>.
For more options, visit https://groups.google.com/d/optout.

--

Parth

Hi Parth,

Sounds like the problem is at Enketo then. Email support@enketo.org.

Yaw

··· -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Tue, May 3, 2016 at 5:18 PM, Parth Saha parthsaha@gmail.com wrote:

I deployed the file that you had provided to Kobotoolbox. But in enketo,
only a text box appears not the list of county based on state.

Actually the select_one_external is not working in enketo but it works on
android phone/Odk collect.

I hope it answers your question.

Thanks for replying.

Parth

On Tuesday 3 May 2016, Yaw Anokwa yanokwa@nafundi.com wrote:

Parth,

What web form? Are you using ODK Collect or something else?

Yaw

Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.

On Tue, Apr 19, 2016 at 8:13 AM, parthsaha@gmail.com wrote:

On Monday, 19 October 2015 13:42:10 UTC+5:30, Hung Pham wrote:

Dear all,

I was encountering an issue with filtering for external select function
in xlsform. After some searches in this forum, I didn't see any thread
stating this issue. So I was trying to solve this issue myself, using ODK's
south sudan example.

After some testing and examining xml & csv files, I realised that ODK
Collect's select_one_external won't work if you have your filter as numeric
values (e.g. 1, 2, 3, 4, etc) . I figured this out after changing column
"name" 's value in South Sudan example (from ODK Help) to numeric value
instead of short alphabetic values, then test it on ODK Collect and as
expected, no choice items were displayed after "state" . So I went back to
check itemsets.csv files and found that all numeric values are converted in
to decimal format (e.g. 1 = "1.0", 2 = "2.0", etc.) . (find attached files)

So that means, unless numeric values for name include ".0", ODK Collect
won't be able to display cascaded selection of choices. A quick work around
that I used was to remove ".0" in itemsets.csv file. This has work like
charms.

To conclude: 2 ways of fixing numeric value sets for
select_one_external - make value set in column "name" - decimal. Or remove
".0" in itemsets.csv file after compiling from xlsform.

Find find attached files for clearer understanding.

Regards all.

Hung.

I deployed the south_sudan_2.xls file.

But after selecting any state, it doesnot show any county on web form. A
normal text box appears.

Any idea why?
How to make it the respective county visible?

Parth Saha

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/dVSIfMnnSaU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Parth

--

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.

Unfortunately this problem has not been fixed till date.