topic Re: Survey 123 Webform error with .csv pulldata - Unable to auto-detect delimiting character in ArcGIS Survey123 Questions

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

jonathanharte — Wed, 25 Jul 2018 15:42:23 GMT

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

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

Anonymous User — Thu, 26 Jul 2018 00:18:38 GMT

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.

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

Anonymous User — Fri, 27 Jul 2018 04:45:54 GMT

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.

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

jonathanharte — Fri, 27 Jul 2018 08:32:00 GMT

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