How to pull external data from a csv file in cascading select question?

1. I am designing a form in which I have select_one option1 District than with cascading select_one Block and further I have thousands of village names {more than 100 for each Block} which I want to pull from a csv file. My question is that it is possible to pull data in cascading select manner from a external csv file? I really looking forward for reply

2. What app or server are you using and on what device and operating system? Include version numbers.

3. What you have you tried to fix the problem?

4. What steps can we take to reproduce the problem?

5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.

Check the document http://xlsform.org/en/#external-selects

I tried it and after running it into xls converter it's giving me Syntex error even the sample file linked with external select have Syntex error in input element. How to overcome that?

Could you please attach your excel and csv file here so that forum member who have idea about it can help you regarding this issue.

To provide you best answer could you please tell us which way you are planning to data collection web or mobile? I am asking it because same xls would not work both mobile and web.

I will attach the excel file shortly. I am making this form to report from mobile. If you had time can you please check the sample file linked with external select because this file also showing similar Syntex error on conversion with xls converter.

itemsets.csv (1.7 MB)
problems.txt (439 Bytes)
test.xlsx (1.1 MB)
uploaded my excel file with csv getting created by xlsform offline converter along with error log while converting xls to xml in xlsform offline

Change list space name to list_name in choices sheet of your excel file and check if it works. I would suggest to check the form here https://opendatakit.org/xlsform/

Changing list name not solving my problem because the problem is with Syntex in input element. If someone made any similar external select survey can be of big help.. looking forward

Use this xls external_data.xlsx (1.1 MB) .I do not get any error while i upload it here https://opendatakit.org/xlsform/ and works fine in updated ODK collect.

Thank You ARIF_AZAD_KHAN this was big help can't thank you enough.

Thank you Arif. How can this be used for multiple language forms?

1 Like

I have the same issue. Multiple languages does not seem to work. ODK apps throw node for itemset does not exist