I have a Kobo form called Structural Quality Checklist that records the infrastructure quality of education centres. Originally, we created it to assess one classroom, but recently adapted it to collect multiple classrooms using a repeat group.
I understand it’s possible to edit submissions manually, one by one, in the Enketo editor but this isn’t possible because of the high number of existing submissions. We have over 100 submissions that we’d like to shift the data from old variables to new variables. The variables are named the same (e.g. item_2, item_3) but are recorded as different variables when we pull the data out using an API because they sit in different groups. I.e., their xform paths have changed.
We would like to edit the old data so it is treated as if it was collected in the first repeat group. This is so that we can treat the old and new data the same in our Azure Synapse data pipeline.
Could you tell me the best way we could perform this kind of bulk edit?
-
Example old field: centre_open/classroom_checklist/ classroom_access/class_clean
-
Example new field: centre_open/classroom_checklist/class_repeat/classroom_access/class_clean
