Why does data that has been deleted from the server still appear in an exported CSV file?

If you are using SurveyCTO Sync, our desktop software, to download and export your collected data from your server, you will have noticed that even if you delete/purge submissions for a form on your server, those deleted submissions still appear in your exported CSV file.

Why do those submissions still appear in the export after they have been deleted from the server? And how do you exclude them from the export (maybe they were test submissions and you don't want them to appear with real data) permanently?

SurveyCTO Sync's local data cache

The reason those submissions appear in the export is that even though you have deleted them from the server, a copy of those submissions is still stored locally on your server by SurveyCTO Sync. Each time you download data, SurveyCTO Sync stores a copy of the data locally. This serves two purposes:

1) It makes sure that each time you export your data, SurveyCTO Sync does not have to re-download all the data from the server and only has to download new submissions;

2) It ensures that if you delete your data from the server accidentally, the data is not lost as there is an extra copy of the data on your computer as well.

Cleaning up local storage on SurveyCTO Sync

However, this also means that if you want to completely delete certain data so that it does not appear in your exported CSV, it is not sufficient to purge submissions only on the server. You must also delete the copy of the forms stored locally by SurveyCTO Sync:

1) Open SurveyCTO Sync

2) Click on the Tools menu and select the option to Clean local storage...

3) In the pop-up window that appears, select the form for which you want to delete submissions, choose to Delete data only and click Clean up now. This will delete all the submissions for that form that are saved in SurveyCTO Sync's local storage.

4) Now re-export your data for that form as you normally would. All submissions will be re-downloaded from the server and hence only those submissions that are still on the server will be downloaded and exported; any submissions that were purged will now be permanently deleted and will not appear in the CSV file.

Please delete your data carefully and make sure you are not deleting any submissions from the server that you actually want to keep!




Article is closed for comments.