Hi Guys, Any heads up appreciated... I have a survey123 form and it works (so far) well in the mobile app on iOS, the same form however on the Web Browser app in IE and Chrome fails to load with an error while accessing the content of a .csv file this is the IE file error The error in chrome The auth.csv below file is as example - it only has commas as the delimiter.... I'm using this calculate on a username Type to lookup the csv file find a user and update their Authority field. pulldata('auth','authority','name',${username}) Auth.csv authority,name A,AA B,BB C,CC any ideas or direction hugely appreciated Cheers

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Survey 123 Webform error with .csv pulldata - Unable to auto-detect delimiting character

jonathanharte

Hi Guys,

Any heads up appreciated...

I have a survey123 form and it works (so far) well in the mobile app on iOS, the same form however on the Web Browser app in IE and Chrome fails to load with an error while accessing the content of a .csv file

this is the IE file error

The error in chrome

Chrome Error The auth.csv below file is as example - it only has commas as the delimiter.... I'm using this calculate on a username Type to lookup the csv file find a user and update their Authority field.

pulldata('auth','authority','name',${username})

Auth.csv

authority,name

A,AA

B,BB

C,CC

any ideas or direction hugely appreciated

Cheers

Find more posts tagged with

Accepted answers

Anonymous User

Hi Jonathon,

I had a look at your survey and csv file, and the issue appears to be caused by an extra line that exists in your auth.csv file. If you open the csv in a text editor (such as Notepad++) you will see an extra line that has no data in it (line 10). The field app appears to ignore this null line, but the web app is more sensitive to this null line:

After I remove this line the web app loads your survey correctly without error.

Phil.

All comments

jonathanharte

Thanks a mil Phil, sometimes the obvious is not so obvious 😞

Works a treat, thanks for taking the time to look at this for me .... I'd be lost without this facility and the like of you guys supporting it.

Cheers

Anonymous User

Hi Jonathon,

After I remove this line the web app loads your survey correctly without error.

Phil.

Anonymous User

Hi Johnathon,

Was the survey originally published via Connect? Can you provide a copy of the xlsx form file and also any related csv files in media folder so we can take a further look.

Phil.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

All Communities
Recent Posts
Followed Content
Community Help

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.