Hi, just wanted to share back with the community the relevant checks to do when using select_one_external and a single CSV file rather than multiple files.
- With select_one_external the CSV file must be named “itemsets.csv”, other names are not possible
- For reasons that I dont fully understand I have found that sometimes a form like this will be rejected if Labels, Hints etc do not all specify a language (eg. Label::English), even if there is only one language. Adding this helped avoid a server500 error.
- When there are multiple cascading layers the top layer goes in the choices tab of your xlsform and all other layers are included in the CSV file.
- System does not seem to have significant performance issues even with 100,000 rows
