Pulling Data from a CSV, CSV File Format Issues/Limitations Enketo

37 views
Skip to first unread message

tyler...@gmail.com

unread,
Oct 2, 2024, 9:30:35 AM10/2/24
to Ona Community
Hello all,

I've had a form that I've been using for quite some time and I switched to using ODK Collect and while Enketo isn't used as much, I would really like to use it, unfortunately there is an error that comes up anytime I try to open the form or edit a previous submission in a web browser using Enketo. Attached is a screenshot of the error that states:

Error occured during the loading of this form. We do not recommend you edit this record until this is resolved.

Please contact sup...@ona.io with the link to this page and the error message below:

CSV column heading "" cannot be turned into a valid XML element

I know this has to do with a CSV file that I used to preload data in my form. I didn't always have this issue, then it came up, I stopped using Enketo for a while, then updated my CSV, and it worked again. Unfortunately I've had to update my CSV again where it "broke" enketo and I'm back in the same place and I've forgotten how I fixed the issue/what the exact issue is. My assumption is that there is something in one of the headers that Enketo doesn't like, but I've looked and looked and cannot find the issue. I've tried to copy the data from google sheets to a new Excel workbook, then save it as both CSV UTF-8 (Comma Delimited) (.csv) or Comma Separated Values (.csv) and neither of those worked. I tried exporting from google sheets using file-->download-->Comma Separated Values (.csv) and still it is giving the same error.

Any help would be appreciated. Attached is the CSV file I'm trying. In Column I I also removed the "." so it just read Loc instead of Loc. but that didn't work either.

Import.csv
Screenshot 2024-10-02 at 1.08.41 PM.png

Evans from Ona

unread,
Oct 3, 2024, 2:47:00 AM10/3/24
to ona-co...@googlegroups.com, tyler...@gmail.com

Hello Tyler,


Thank you for contacting us.


Please share the XLSForm and associated CSV files so that we can try to replicate this issue.


Regards,

Evans

Evans

Ona

--
Collect, Analyze and Share Data - https://ona.io/
---
You received this message because you are subscribed to the Google Groups "Ona Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ona-communit...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/e50d5bcf-588d-4502-9829-d9566c3a1019n%40googlegroups.com.

intercom

Evans from Ona

unread,
Oct 4, 2024, 6:38:50 AM10/4/24
to ona-co...@googlegroups.com, tyler...@gmail.com

Hello Tyler,


Thank you for the response.


I am unable to access the project you shared (https://ona.io/foodforestfun/152572/654924). If possible, please share the project, in which the form is located, with onasupport and assign a Can Submit permission level to enable us to look into the issue. Once you have shared the project, please let us know the account name, project name, and form title.


Regards,

Evans 

Evans

Ona

On Thu, Oct 03, 2024 at 19:55 PM, Tyler Depke <tyler...@gmail.com> wrote:
Evans,

I've tried with several files. I included the original CSV that I was trying in the first email.
Here is the project I'm trying to use it with: https://ona.io/foodforestfun/152572/654924

Attached is the latest CSV I've been trying. There are a few more files in the forum below as well as others who have been trying to help:


Tyler


On Thu, Oct 3, 2024 at 6:46 AM Evans from Ona <eony...@ona.io> wrote:

Hello Tyler,


Thank you for contacting us.


Please share the XLSForm and associated CSV files so that we can try to replicate this issue.


Regards,

Evans

Evans

Ona

On Wed, Oct 02, 2024 at 16:30 PM, tyler...@gmail.com <tyler...@gmail.com> wrote:
--
Collect, Analyze and Share Data - https://ona.io/
---
You received this message because you are subscribed to the Google Groups "Ona Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ona-communit...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/e50d5bcf-588d-4502-9829-d9566c3a1019n%40googlegroups.com.
intercom

Evans from Ona

unread,
Oct 4, 2024, 10:51:06 AM10/4/24
to ona-co...@googlegroups.com, tyler...@gmail.com

Thanks for the information. I thought I could download all media files as well as the form and upload it on a separate project to test and identify the issue but it appears there are quite a number of media files. Have you taken a look at the species.csv file? I've noted it has multiple languages. A possible solution would be to try and remove the other labels and just have one since :: may be considered as a special character.


Regards,

Evans

Evans

Ona

On Fri, Oct 04, 2024 at 14:42 PM, Tyler Depke <tyler...@gmail.com> wrote:
Evans,

You should have submit access now.

Account name foodforestfun
Project Name: foodforestfun's Project
Form Title: Farm_Observations

The CSV in question I believe is Import.csv


I'm still not finding the issue ;(

Thanks again

Tyler

On Fri, Oct 4, 2024 at 9:56 AM Evans from Ona <eony...@ona.io> wrote:

Hello Tyler,


Thank you for the response.


I am unable to access the project you shared (https://ona.io/foodforestfun/152572/654924). If possible, please share the project, in which the form is located, with onasupport and assign a Can Submit permission level to enable us to look into the issue. Once you have shared the project, please let us know the account name, project name, and form title.


Regards,

Evans

Evans

Ona

On Thu, Oct 03, 2024 at 19:55 PM, Tyler Depke <tyler...@gmail.com> wrote:
Evans,

I've tried with several files. I included the original CSV that I was trying in the first email.
Here is the project I'm trying to use it with: https://ona.io/foodforestfun/152572/654924

Attached is the latest CSV I've been trying. There are a few more files in the forum below as well as others who have been trying to help:


Tyler

On Thu, Oct 3, 2024 at 6:46 AM Evans from Ona <eony...@ona.io> wrote:

Hello Tyler,


Thank you for contacting us.


Please share the XLSForm and associated CSV files so that we can try to replicate this issue.


Regards,

Evans

Evans

Ona

On Wed, Oct 02, 2024 at 16:30 PM, tyler...@gmail.com <tyler...@gmail.com> wrote:
--
Collect, Analyze and Share Data - https://ona.io/
---
You received this message because you are subscribed to the Google Groups "Ona Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ona-communit...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/e50d5bcf-588d-4502-9829-d9566c3a1019n%40googlegroups.com.
intercom

Tyler Depke

unread,
Oct 4, 2024, 10:51:15 AM10/4/24
to Evans from Ona, ona-co...@googlegroups.com
Evans, I found it, it was actually the cashewhill.csv which was an issue. There were two empty columns at the end. I posted the solution on the ODK forum here: https://forum.getodk.org/t/enketo-not-loading-because-of-issues-with-csv-file-used-for-pulldata/49867

Tyler

Evans from Ona

unread,
Oct 4, 2024, 10:52:25 AM10/4/24
to ona-co...@googlegroups.com, tyler...@gmail.com

Glad that you were able to find the solution Tyler.


Regards,

Evans

Evans

Ona

intercom

Tyler Depke

unread,
Oct 4, 2024, 11:26:37 AM10/4/24
to Evans from Ona, ona-co...@googlegroups.com
Evans,

Thank you for your help. It ended up being way simpler than what I was thinking. Did you see my suggestion in the forum regarding the error message? I basically just said it would be really helpful to include the title of the CSV file that is problematic instead of a generic CSV error file. Is that something controlled by ODK Central or ONA?

Tyler

Evans from Ona

unread,
Oct 4, 2024, 11:26:41 AM10/4/24
to ona-co...@googlegroups.com, tyler...@gmail.com

Thanks for the feedback Tyler. That is more within ODK's purview since they have been maintaining Enketo's code base.


Regards,

Evans

Evans

Ona

On Fri, Oct 04, 2024 at 18:21 PM, Tyler Depke <tyler...@gmail.com> wrote:
Evans,

intercom

Evans from Ona

unread,
Oct 6, 2024, 2:02:02 PM10/6/24
to ona-co...@googlegroups.com, tyler...@gmail.com

Alright. We will have to wait and see if they will add it has an enhancement to Enketo’s functionality.

Regards,
Evans

Evans

Ona

intercom
Reply all
Reply to author
Forward
0 new messages