Hello KoBo Team,
We are encountering a problem (bug?) on data download. In all file formats (XLS, XML, CSV). the case order has changed, different to the order in the table view.
End of table view
Beginning of export file
Normally the cases in the export files appear in reverse order of the KoBo table view. But now we have a case which appears at index place 1. In consequence all indexes are changed by one. (This is different to previous exports we have!)
As far as we can see, there is no reason for this on data level. For ex. this wrong case at position 1 was sent, started and ended later as the next following cases. Also, no editing was done (so far) on server level.
Can anyone explain this? It might have arrived after the server problems in January (but we didn’t lose any project or data at this time).
What should be the KoBo case order in the export file?
The order in the table view seems to follow the end (datetime) metadata.
In the table this case (appearing at position 1 in the export) is somewhere in the middle of the KoBo table view (page 3 of 7). But in the download the case shows up on position 1. (Screenshot updated):
The recent change of the export order / _index is a relevant problem for us, as we used previous downloads to specify cleaning issues.