1. What is the problem? Be very detailed.
I had to move some variables from one group (or page) to another in an effort to optimise our data collection, while keeping the same name since we are still collecting the same information.
Let's for instance consider I started with
group1 then decided to move it later in
I was expecting to end up with two columns with the
group2-var1 (which I would then have to retrospectively merge), however, it seems that the export is constrained by the latest published version of the ODK form, and only allows
var1 to be exported once for the group that is used in this latest version, which means I only export
group2-var1 but I do no longer export
group1-var1 using the CSV export... (I cannot tell about odata since these data are encrypted).
Similarly, values for variables that have been removed from the form during data collection are not exported, which is not a behaviour I would expect, especially when adjusting the data collection and trying to adjust the data collection strategy.
Not sure if I am missing something absolutely obvious here as I have not seen this reported anywhere, but it does not seem to me like a desirable behaviour for the export function as I would like to be able to download all the data that have been collected for this form (independently on its current structure). Any thoughts welcome.
2. What app or server are you using and on what device and operating system? Include version numbers.
3. What you have you tried to fix the problem?
I have moved back
group 1 to check that the data are still there and I indeed now retrieve the column
group1-var1, but I am losing
I have tried exporting CSVs filtering submissions up to the date of the form update, but I am unable to retrieve the same data structure I was able to export before the form update.
I have also looked at the description of the API (Exporting Form Submissions to CSV via POST) to see if there is a parameter that could be used to retrieve the whole dataset, but I have not seen anything that could help me to get around this issue (except maybe publishing a previous version of the form to retrieve the former data structure, but then I will miss the most recent data that are collected with the current form)
4. What steps can we take to reproduce the problem?
- Use a form with 2 groups
- Start collecting data with
- Then publish a new form with
var1removed from the XLSForm
- Collect more data
- Download the CSV export
5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.