Deleted fields missing from submissions csv

[LeaTark]

It looks like the columns in the csv are created from the fields currently in a form rather than the submissions. This can be a problem when a field is deleted.

Even though the data is still in the submissions list, deleted fields are not exported to csv.

If a field is no longer required in a form, I'd like to be able to delete it and not have it in future submissions but not lose access to data currently gathered.

[Nicholas-Westby]

Thanks for the report!

If anybody wants to tackle this, here's the code that is writing the header fields for the CSV:

formulate/src/formulate.app/Controllers/StoredDataDownloadController.cs

Line 229 in 61d7f4f

foreach (var fieldId in fieldIds)

The tricky bit is that you'll have to read in all the stored submission records to figure out the "extra" fields (i.e., the fields that no longer exist in the current form).

After you write out the headers, you'll also have to write out the values, which is currently done here:

formulate/src/formulate.app/Controllers/StoredDataDownloadController.cs

Line 243 in 61d7f4f

foreach (var fieldId in fieldIds)

You'll need to write out a dummy value for any submissions missing some of the fields (which is likely to be the case on newer submissions, since newer submissions wouldn't contain any of the deleted fields).