Unable to auto-detect delimiting character

User Support Data Management
1

Hello, I am trying to share a link to view a form that has been submitted, however I keep getting an error message when logged out of my account (i.e. anonymous users will not be able to view the form).

The error message is: “Unable to auto-detect delimiting character; defaulted to ‘,’”

I have tried searching on online forums and using the solutions recommended on this post ( Enketo unable to auto-detect delimiting character - User Support / Form Building - KoboToolbox Community Forum), but no luck! The form uses dynamic data attachments to check for duplicate submissions, as well as a csv file to pull data for one field based on a previous response. Please advise how I can resolve this issue? Thank you.

2

That rather sounds like a ‘csv’ parsing error. What’s your raw CVS file data actually look like?

1 Like
3

Thanks for your response! To provide a bit more context to the issue, the form itself works as intended and data exports work correctly too. The issue comes when viewing single submissions it doesn’t work.

Using this:
https://eu.kobotoolbox.org/api/v2/assets/{form_id}/data/{submission_id}/enketo/redirect/view/?return_url=false

To generate a unique url something like this:
https://ee-eu.kobotoolbox.org/view/{form}?instance_id={instance}&return_url=false

The CSV data pulls correctly into the form when it’s submitted, but the view option won’t work. The data in the CSV looks something like this, and references the ID number to pull in band type.

image
image159×167 1.46 KB

1 Like
4

@SamH, would you mind sharing your CSV file with the community? From your screenshot, it looks like there might be an issue with the header.

5

Thanks Kalyan. Here’s the CSV
bandlist.csv (1.5 KB)