sg60060
February 25, 2021, 2:36pm
1
Hi,
I want test select_one_external.
I took the example file from xlsform.org : https://xlsform.org/en/#external-selects
Example file available : https://docs.google.com/spreadsheets/d/12qZL34kuHSZGWDv0BBJ1qf7dSmml-d2VnMWH0Vtg-O4/edit?usp=sharing
But it don’t work for me. In enketo it don’t show list populated with information.
I tried to create my own xlsform and it doesn’t recognize my external_sheet named “external_choices”
Can you help me with this question type?
Thank you for your reply.
Kal_Lam
February 25, 2021, 2:51pm
2
Maybe this post discussed previously should be helpful:
Hi, just wanted to share back with the community the relevant checks to do when using select_one_external and a single CSV file rather than multiple files.
With select_one_external the CSV file must be named “itemsets.csv”, other names are not possible
For reasons that I dont fully understand I have found that sometimes a form like this will be rejected if Labels, Hints etc do not all specify a language (eg. Label::English), even if there is only one language. Adding this helped avoid a serve…
At the same time, I would also advise you to use the select_one_from_file
that is able to handle external csv files.
For details, please view our support article Select One or Many From External File Question Type . We also have some workarounds in our community:
A simple workaround of using select_one_from_file
question type:
Hi @MarkS ,
Welcome tot he community! Yes, its possible to use the search function in appearance while executing a select_one_from_file question type in KoBoToolbox. However, please be informed that this only works with Enketo at the moment and not with KoBoCollect or ODK Collect.
You could do the same as shown in the image below:
In the survey tab:
[Image%201]
In the choices tab:
[Image%202]
In the csv file:
[Image%203]
Reference xlsform:
select_one_from_file.xlsx (11.8 KB)
fruits.cs…
If you wish to use the cascading select with select_one_from_file
question type:
Welcome to the community @isaacmugabo ! You could do the same as outlined in the images shared below:
In the survey tab of your xlsform:
[Image 1]
In the choices tab of your xlsform:
[Image 2]
In the csv file: state code
[Image 3]
In the csv file: district code
[Image 4]
In the csv file: village code
[Image 5]
Data entry screen as seen in Enketo:
[Image 6]
Reference xlsform:
select_one_from_file.xlsx (15.7 KB)
CSV file (state code):
State_Code.csv (245 Bytes)
CSV file (district cod…
sg60060
February 26, 2021, 9:16am
3
Hi @Kal_Lam ,
Thank you for your reply.
But following the advices from @NoelCartONG , I can’t deploy my form. Could you confirm me “select_one_external” field works with Kobo or if example file I send works for you?
Thank you for example of select_one_from_file field works very well for me
@sg60060 , kindly please be informed that you could manage your survey project through select_one_external
question type as discussed in our previous post:
@basualdo , kindly please be informed that I just checked the feature with the HHI server and it works. Please be informed that this feature at the moment only works with Collect android app while Enketo does not support it. You could design your xlsform as outlined in the image shared below:
In the survey tab of your xlsform:
[Image 1]
In the choices tab of your xlsform:
[Image 2]
In the external_choices of your xlsform:
[Image 3]
Or, you could simply list out the unique list_name as show…