topic Re: Reading data from CSV in ArcGIS Survey123 Questions

Reading data from CSV

AlBow — Thu, 08 Jun 2017 12:44:34 GMT

Hello,

I've a CSV file with a list of ID numbers. What I'd like to do is to read the column ID from the CSV and load all the values in a "select_one" combo on my form in Survey123.

I know how to read the CSV file using "pulldata" function and "calculate" field in my XLSForm to retrieve values according to a key, but in this case there is no key: I just want to load a list of data reading an external file, instead of copying all the data in my "choice" sheet of the XLSForm. I've tried using pulldata in "constraints" field but without success....

Any ideas? Thanks a lot

Re: Reading data from CSV

JamesTedrick — Thu, 08 Jun 2017 22:48:50 GMT

Hi Al,

Unfortunately, we do not support the functionality as you describe it at this time. The closest would be to implement the values you describe as external selects, which as you note requires copying the values into the XLSForm. I've added your request to enhancement for a 'search' function, which would implement what you describe.

Re: Reading data from CSV

AlbertoLaurenti1 — Fri, 09 Jun 2017 07:29:31 GMT

Thanks James. That funcionality could be very useful! Hope to see it in a next release.

Re: Reading data from CSV

RenatoSalvaleon — Sat, 24 Jun 2017 11:47:55 GMT

James is an Idea needed so people can vote this up?

Re: Reading data from CSV

JamesTedrick — Mon, 26 Jun 2017 16:28:13 GMT

I'm not seeing one that looks appropriate on the Ideas site; feel free to add one in.

Re: Reading data from CSV

SimonLange — Mon, 15 Jul 2019 14:28:13 GMT

Hi all,

James Tedrick‌ I have the exact same issue - has there been anything updated to fix something like this in the last versions of Survey123 since the original post?

Thanks!

Re: Reading data from CSV

TimothyKing3 — Wed, 15 Apr 2020 15:24:03 GMT

Does he pulldata function work in webforms as well?

Thanks

Re: Reading data from CSV

Anonymous User — Fri, 06 Nov 2020 10:13:33 GMT

Hi Alberto,

Just letting you know that in the latest 3.12 beta builds available on the Survey123 Early Adopter Community we have made significant improvements to large choice lists which improve the survey load time in both Connect and the field app.

On top of this there are now some new ways you can manage your choice lists dynamically and update them without having to republish the survey, meaning choice lists can now be populated and updated dynamically from a CSV file or hosted table shared in ArcGIS or directly from a feature service using the search() function. Please check out the latest announcement on EAC and test out these new beta features with the latest 3.12 beta builds.

Regards,

Phil.