Thanks so much for joining the discussion.
I will work on suggestion #1 soonest possible, but can react to suggestion #2 immediately: I didn’t change the linked example, just opened a form in KoboCollect and received an error message when arriving at the select question. Indeed, with my original approach, search in appearance worked perfectly for collection, but then I discovered the issue of not being able to use the single edit function in Data/Tables – which is the still unsolved core issue.
Not sure whether related: I followed the instruction for select_one_from_file to use the same term for “name” in the survey sheet, for “list_name” in the choices field (which the example above doesn’t) and for “list_name” in the csv file – however, the latter has no influence on the selection (fully determined by the content in “choice-filter”. So, I wonder: Is the instruction wrong (like the example above seems to have a bug)? Can you point at a perfect description of how to use select from file properly (and thus allowing editing later)?
Gesendet von meinem BlackBerry 10-Smartphone.
Von: Stephane Aloo via KoBoToolbox Community Forum
Gesendet: Mittwoch, 5. Mai 2021 21:11
An: York Lunau
Antwort an: KoBoToolbox Community Forum
Betreff: [KoBoToolbox Community Forum] [User Support/Data Management] Editing data (with Enketo = default) not possible when using external csv?
stephanealoo Core Team
I would like to join this conversation and picking up from the discussion trail, I would like to request that you just make some minor tweaks on your CSV naming so that we see if its resolves the issue:
SUPPORT ISSUE 1
- Proposed change: Could you change the name of your CSV file from to facilities_na_test.csv
- Rationale: This change tests the hypothesis that inclusion of - instead of _ may be causing an issue in the system during editing and not during data collection.
SUPPORT ISSUE 2
I would also like to revive one issue that you had probably set aside
I started out with the example questionnaire from Creating a form with cascading select, from a list in an external csv file - User Support / Form Building - KoBoToolbox Community Forum
First of all, this questionnaire created an error message on KoboCollect right for the first question: “File: …forms/EXAMPLE Selects with Choice Filter Search with from file_2-media/cbes.csv is missing.”
I would really like to check your form and see what could have been the issue with how you wrote this. My experience with this search() parameter has shown that this approach actually works quite easily even with large data CSV data sets.
Kindly start with Support Issue 1 and then update as you look at issue 2,