This article is part of a sequence of articles on troubleshooting missing data. If you arrived here directly, please start from the first article here.
Step 4A: Server <> Exported CSV record mismatch:
You are here because, in the previous step, you selected "A) The number of submissions collected on devices and uploaded to the server matches the number of records next to the form title on the server’s Export tab. That is, all submissions are on the server. But the number of rows in the exported CSV is less than the number of records on the server, so not all submissions on the server appear to be in the exported CSV" as your response.
(A) exporting data directly from the server console’s Export tab?
(B) Or Using our desktop software, SurveyCTO Sync, to export your data?
From the server console
If (A) >> When you run the export, please carefully note any warnings or error messages that you see during the export process. Please take a screenshot of this error message if necessary. And then create a support request to the support team via the My requests link in the top right, giving details about your situation and attaching the text or screenshot of the error message.
If you are a free community user and do not have access to our support team, attempt to understand and follow the instructions in that error message. You can also post the details of your issue and the text or screenshot of the error message to the community forum to get help from other users.
Using SurveyCTO Sync
If (B) >> After you run your data export using SurveyCTO Sync, next to the Details… button at the bottom of the SurveyCTO Sync window, do you see a message that says “completed with errors…”? If so, please click the Details… button to determine what the errors are.
There are two common types of errors:
- You are experiencing Internet connectivity issues. You may still be able to browse the Internet but the connection may not be stable enough to download and export all submissions in one go. If the errors indicate an internet connectivity issue (e.g. messages like the connection “timed out”) please just run SurveyCTO Sync again a few times. Each time SurveyCTO Sync will download some additional data that it was unable to retrieve in the prior attempts and will continue where it left off. It would also be most ideal to run SurveyCTO Sync over a better Internet connection in this case. Keep re-running SurveyCTO Sync until the number of records in the CSV match the number of records on the server.
- Internet connectivity is OK but certain individual submissions are not being exported. This is usually because the raw files for those submissions stored on your computer are corrupted. If this appears to be the case:
(A) Make sureSurveyCTO Sync's local storage folder, SurveyCTO Sync Storage, is not in a syncing folder like Dropbox, Google Drive, or Box. A synced folder location can corrupt submissions or create read/write conflicts during export. You can fix this by changing the internal storage directory to a non-syncing location by going into SurveyCTO Sync’s Preferences and, in the first setting you see on the first tab, changing the directory location. Then run SurveyCTO Sync again. This will download everything afresh from the server so will be slow, but all submissions will be fixed and exported.
(B) If you are sure that SurveyCTO Sync’s internal directory is not in a syncing folder, there might have been other issues on your computer hard drive that caused certain downloaded submissions to become corrupted. If you have not purged any data from your server, re-download the data from the server by going into SurveyCTO Sync’s Tools menu, then select Clean local storage. Select the form for which your submissions are not all exporting, choose to clean local storage for this form, and then re-download and export data for this form again. Now do all submissions export?
If you follow the above steps but the problem persists, please open a support request with our support team by clicking the My requests link in the top right of this support center. When you do so, attach a Word document that contains the full Details… output produced by SurveyCTO Sync.
If you are a free community user and do not have access to our support team, you can post a request for other users to help you in the community forum. Provide as much detail as possible to make it easy for other users to assist.