1. What is the issue?
I am getting the dreaded
Some background. I have a form with cascading dropdowns (Project/Site/ponds) which works just fine with some hand crafted csv files. XLSX extract as below:
I have a website which generates updated csv files with which I update the form automatically using API calls (create draft/upload csv files/publish form) And that all works.
However attempting to use the new form generates the error.
Furthermore if I replace the csv files with the old ones republishing the reverted form Android ODK Collect refuses to synchronise untill I shutdown and restart the Android app
2. What steps can we take to reproduce this issue?
Obviously I have compared the old and new files and they do not differ in format and records added do not look erroneous in anyway or contain potentially problematic characters such as quotations or slashes)
I have found the error to be irreproducible in the following sense. I created a cut down version of the form just using the first few lines of the excel sheet and updated its csv files with the ones which cause my main form to fail and the cut down test form works.
3. What have you tried to fix the issue?
4. Upload any forms or screenshots you can share publicly below.
I am happy to upload if this is useful
0b55d7d9f98f145c919c6e3476813275c4b69af7 client (v2023.1.0)
ad061f6088cf81c95bddf6f53310923cce9f76be server (v2023.1.0)