1. What is the problem? Be very detailed.
Hey there,
I have to survey households who are members of cooperatives. I previously manually registered the names of all the members of these coops, with other information like their localization (districts > communes > villages) in the db_bnf. I now want the surveyors to select the members in a list, restricted thanks to the localization. As I have more than 2500 entries in the db_bnf, I don't want to copy/paste it directly in my choice sheet. So I put it in a CSV (an sample is attached) download it with my xlsform on Aggregate and pulled the data in Xlsform with the pulldata() function (please see the attached file). I then use cascading select_one to reduce the list of beneficiaries.
The importation goes well, but when I go on my mobile device to try it, I have the following error :
For each column called, I have the message error "No such table: externalData (Sqlite code 1): ,while compiling, : SELECT c_district FROM externalData, (OS error - 2: No such file or directory)
It's the same for the c_op, c_id-commune, c_commune etc.
your xls form contains many problems and ca't be converted using http://opendatakit.org/xlsform/ the csv file doesn't seems good as well. If you want someone to help you please just attach a form that we can use for testing.
When it comes to pulling data from csv file you can find more info and a sample form here: http://xlsform.org/en/#dynamic-selects-from-pre-loaded-data I think it should help you.
Thanks for the link, I read it at least ten times these past two days trying to understand my mistakes. I also searched on this forum and on ona. I found this example that helped me a lot.
Thank you @Grzesiek2010, it's finally working. I just splitted my CSV in 3 files to make things easier to interprete.
If I may give some non computer specialist feelback, I think that the example you gave me is not that good. The 'fruits' is the CSV, the question's name and the choice_list. In my opinion it would be much easier to understand if there were three different names!