I am using ODK Central v2023.5.1. Recently when i download submissions the csv file looks corrupt. What could be the problem? And how can i view the corrupted submissions (rows) and remove the corrupted rows from the database? 2. What steps can we take to reproduce this issue?
Ask for the snapshot of my download file.
Normally the data would look like this:
And recently there is several places in the file where the rows look like:
3. What have you tried to fix the issue?
Remove the rows with messy data but it looks like all if not majority of the records are affected.
4. Upload any forms or screenshots you can share publicly below.
I think this is similar to this thread. You will have some fields containing carriage returns that causes issues when opened. I still see this in some of my CSV exports as well where I have carriage returns in the cells that break the formatting.
If you are able to query the data using the OData URL instead you will get better formatted content.
1. What is the issue? Please be detailed.
I am running ODK Central for data collection and so far I have 2 050 submissions. The csv file seems to be corrupted when I download the submissions. I also have a csv file that i have attached to the forms, it is also not working. It looks like the forms are not able to read that file or the content is corrupt.
2. What steps can we take to reproduce this issue?
Not sure. Maybe by trying to use the forms.
3. What have you tried to fix the issue?
Tried using the OData Feed. And I am getting this error.
The OData error suggests you may be trying to use credentials that don't have access to that form. Could you please verify that the user you are using is at least a project viewer for the project that the form is in? Did you copy the OData link from Central?
Thank you for the feedback @LN . Let me try the open it as suggested by Sadiq Khoja. Another interesting thing is that i have two forms, one with 2 020 submissions and the other with 1 900 submissions. The later is not badly formatted.
In terms of the OData connection error, I am the project manager for the data collection, and use the same credentials i created during the deployment of ODK Central.
Thank you Andrew. I am working on Excel desktop app. The problem was permissions, and it is now solved. This is new terrain for me, but slowly I am getting there.
