Hi everyone,
I am facing an issue with a KoBoCollect form using external CSV with cascading selects and multilingual support (English, Hindi, Tamil). Instead of using mulitple externals csvs for multiple levels, i am using single csv for all levels as suggested in the community (@stephanealoo )
It was working for fine untill english only, english and tamil. but when I added a hindi then it started giving me error. As soon as i select the state, this errors pops up.
Survey sheet:
| type | name | label::English (en) | label::Hindi (hi) | label::Tamil (ta) | hint::English (en) | hint::Hindi (hi) | hint::Tamil (ta) | required | appearance |
|---|---|---|---|---|---|---|---|---|---|
| xml-external | TMS | ||||||||
| start | start | ||||||||
| end | end | ||||||||
| today | today | ||||||||
| username | username | ||||||||
| text | your_name | Enumerator’s Name | Enumerator’s Name | ||||||
| (सर्वे करने वाले का नाम) | Enumerator’s Name | ||||||||
| (கணக்கெடுப்பாளரின் பெயர்) | true | ||||||||
| select_one state | state | Select State | Select State | ||||||
| (राज्य चुनें) | Select State | ||||||||
| (மாநிலத்தைத் தேர்ந்தெடுக்கவும்) | true | autocomplete | |||||||
| select_one district | district | Select District | Select District | ||||||
| (जिला चुनें) | Select District | ||||||||
| (மாவட்டத்தைத் தேர்ந்தெடுக்கவும்) | true | autocomplete search(‘locations1.csv’,‘matches’,‘state_name’,${state}) | |||||||
| select_one sub_district | sub_district | Select Sub-district | Select Sub-district | ||||||
| (उप-जिला चुनें) | Select Sub-district | ||||||||
| (துணை மாவட்டத்தைத் தேர்ந்தெடுக்கவும்) | true | autocomplete search(‘locations1.csv’,‘matches’,‘district_name’,${district}) | |||||||
| select_one town_village | town_village | Select Town/Village | Select Town/Village | ||||||
| (शहर/गांव चुनें) | Select Town/Village | ||||||||
| (நகரம்/கிராமத்தைத் தேர்ந்தெடுக்கவும்) | true | autocomplete search(‘locations1.csv’,‘matches’,‘sub_district_name’,${sub_district}) |
External csv
| name | label::English (en) | label::Hindi (hi) | label::Tamil (ta) | state_name | district_name | sub_district_name |
|---|---|---|---|---|---|---|
| saharanpur | Saharanpur | Saharanpur | ||||
| (सहारनपुर) | Saharanpur | |||||
| (சஹாரன்பூர்) | uttar_pradesh | saharanpur | saharanpur | |||
| moradabad | Moradabad | Moradabad | ||||
| (मुरादाबाद) | Moradabad | |||||
| (முராதாபாத்) | uttar_pradesh | moradabad | moradabad | |||
| ghaziabad | Ghaziabad | Ghaziabad | ||||
| (गाज़ियाबाद) | Ghaziabad | |||||
| (காசியாபாத்) | uttar_pradesh | ghaziabad | ghaziabad | |||
| aligarh | Aligarh | Aligarh | ||||
| (अलीगढ़) | Aligarh | |||||
| (அலிகர்) | uttar_pradesh | aligarh | aligarh |
Suggest the solution please.
Thank you,
Manishankar

