I’ve created a form using XLSX Form. I was able to create a new project in KoBo Toolbox and upload this XLSForm. The project is created successfully, but I can’t edit the form - the website just hangs up and stop responding. No error in the console or in the UI. I can still deploy the form and collect data using KoBo Collect and send back to the server.
Is it because the form (XLSXForm) has some functionality that is incompatible with KoBo web form designer? I’m able to browse data collected and edit individual entries though. Just can’t edit or preview the empty form.
Initially I’ve experienced this in Chrome (Version 86.0.4240.198 (Official Build) (64-bit)) on Windows 10. After your suggestion I tried Firefox (83.0 (64 bit). The problem is still the same - the page becomes unresponsive. I’ve also tried using another account - the same problem occurs.
The form has one very long code list (over 9k entries) - can this be the issue? However, the form is working fine and smoothly on KoBo Collect and I can preview and edit existing submissions. So it is weird I can’t preview or edit the form in KoBo web designer.
Just tried uploading (replacing) the same XLSXForm without the long code (choice) list - it is working fine! So this must be due to long choice list. Is there any limitation per list, or a total number of entries (choices) per form? I’m using this long choice list with autocomplete and choice_filter - maybe this is a reason?
Thanks! I’ve tried using select_one_external field type with a reference to external_choices tab. I can upload the XLSXForm to KoBo, but when deploying, I get “if this problem persists, contact help@kobotoolbox.org. Server Error (500)”. Also, I’m not able to edit the form.
Is this functionality not available in KoBo? I will try also using select_one_from_file.
Thank you so much for sharing this workflow. I’ve tried using select_one_from_file in my form as well as using sample form shared in your post. I’ve uploaded CSV files to Media section and saved settings. Unfortunately, in both cases (my own form and your samples) I get the same error: invalid data_type: select_one_from_file State_Code.csv.
Any clues what I may be doing wrong? And most importantly: should this also work in KoBo Collect? I’ve checked this: Error message while previewing a form when using select_one_from_file which suggests this feature was not implemented in KoBo Collect (at least back in Feb 2020).
PS. Interestingly, I can deploy this form and sync with KoBo Collect and the external list is properly linked with the relevant field/question. So the only problem is with previewing or editing the form in web (Enketo?).
Yes, editing a survey project (form) with select_one_from_file question type is an issue with KoBoToolbox. It has already been discussed in our previous post and we too have a GitHub issue for the same (which you can follow it through this post):
But also please note that editing submissions with select_one_from_file question type should be supported in KoBoToolbox.
Yes, it’s an issue identified previously related with the bug report lodged previously. It should get solved once the GitHub issue is addressed.
However, regarding your second issue, you could temporarily solve your issue by downloading your data as XLS (legacy) format as shown in the image below:
Hi @Kal_Lam, great, thanks for this workaround. It works for both CSV (legacy) and XLS (legacy) downloads. What are the differences between regular and legacy downloads?