SQLITE “no such column: c_district_label” error in KoBoCollect with multilingual form and external CSV (search())

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

Types and names in the survey sheet, and choice names in the choices sheet (or equivalently an external CSV file) should all be untranslated** strings**. That is probably what is causing the errors you are seeing [I’m actually a bit surprised you could successfully deploy the form! :hushed_face: ]. You will probably need to go thru your entire form and convert these to English/latin alphabet chars.

Whereas survey labels, choice labels, hints, guidance hints can all be translated into other (non-latin) language strings for display in the UI.