I used to the "Import Cases from Excel" feature to update some case properties that were not saved, but were collected and available on the form submission.
I managed to update the the missing information by using the steps on the help site and everything worked fine. All the missing data was now appearing on the reports and case exports.
However, after we ran some integrity checks, we had to archive a few of the cases. In order to archive some of the cases, I had to archive the "system form" first and then the corresponding form/s. I'm assuming the "system form" is the Case update using excel that I had done.
Doing this removed all the case properties that I had updated using the the import feature. I would have thought that archiving one specific case should only affect that case itself but it seems like it undo's all the case property updates for all affected cases. Is there a workaround this??
I even tried renaming the way the Case Name is stored to be unique rather than the facility name (incase the case update uses the case name), but even this didn't work.
Please assist. Thank you!