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.
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.
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,
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, \
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.
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 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?
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?
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.
···
--
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.
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 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?