Xlsform with select_one_from_file states.csv is not working

I have created a test xlsform with select_one_from_file states,csv. I have created states.csv with name and label columns too. the form is successfully compiled at https://getodk.org/xlsform/.

But when i try to upload the form with the csv file as indicated in the screen sheets , it gives the following error.



select_state.xlsx (8.7 KB)
select_state.xml (928 Bytes)
states.csv (140 Bytes)

Hi @shiv_sms ,

I'm afraid that select_one_from_file was introduced after aggregate has reached end of life so it can't understand your form definition.

Select_one from csv file support in ODK Collect and Enketo - #3 by LN?

You should consider switching to Central

Thank you Mat,

I had read thru the xlsform doc page which had given the ability to load values from csv's even for ODK aggregate in different ways. If you can help with that.
The reason i am still working with Aggregate is for the time being is the lack of infrastructure to put up an instance of ODK central.
Can you help me with a workaround for ODK Aggregate itself.
Regards

Hi @shiv_sms ,

Yes, I should have given you a workaround :wink:

You can check out this resource to learn how to use a CSV file for a selected question when you can't use Central :

Is a select_one with a search functionality an option you want to consider for this use case?

Yes , i would definitely want to explore that option too. Please do let me know, how to use this option to implement external csv files.

Regards
Shiv

Here you go. This is an ordinary select one but permitting searches from an external media file.
select_state.xlsx (10.0 KB)
states.csv (140 Bytes)