AnsweredAssumed Answered

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

Question asked by jonnyha on Jul 25, 2018
Latest reply on Jul 27, 2018 by jonnyha
  • Comment • 3

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 ErrorThe 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

Philip.Wilson-esristaff
Philip.Wilson-esristaff Employee Jul 26, 2018 9:45 PM
Correct Answer

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.

See the reply in context
No one else had this question

Outcomes