topic Re: Pull data from csv into webform in ArcGIS Survey123 Questions

Pull data from csv into webform

tomhughson — Mon, 13 Feb 2017 03:27:45 GMT

Hello there, are there any known limitations in getting the pulldata from csv function working on a web form? Seems to be functioning well when testing in survey123 connect but after publishing the relevant information is not being pulled into the form. I also can't submit the survey, I get this 'loading' message at the bottom of the survey form. The same form lodges OK from the iphone app (but the pulldata from csv also doesn't seem to be working on the iphone). ?? Thanks

Re: Pull data from csv into webform

MarikaVertzonis — Mon, 13 Feb 2017 05:52:17 GMT

As long as your csv file is stored in the media folder of the survey, there is currently no known issue with using pull data from csv in a web form.

If your issue persists, please contact tech support and supply them with your survey spreadsheet and csv file (or simplified versions of them) so that the problem can be troubleshooted.

Re: Pull data from csv into webform

Anonymous User — Mon, 20 Feb 2017 23:21:41 GMT

The Pull Data function can only be created in Survey123 Connect because the online forms do not yet support this functionality. I've logged ENH-000102972 on your behalf so we can get the error messages improved in Survey123 Online. I know the team is also working on adding more functionality to the online app so it is more directly in line with what is in the desktop application.

Re: Pull data from csv into webform

JamesTedrick — Tue, 21 Feb 2017 23:33:18 GMT

Andrew, the web form you are showing should be able to support pulldata() functions. This is the next generation webform and is currently in beta- there might be another question that is causing the failure to load. Can you share the xls file?

Re: Pull data from csv into webform

JamesTedrick — Wed, 22 Feb 2017 18:52:31 GMT

Hi Tom,

The main issue is regarding the calculation of the location- the web form does not support that yet. Additionally, the intermixing of single apostrophes and double apostrophes in the calculation causes a separate issue.

James

Re: Pull data from csv into webform

tomhughson — Wed, 17 May 2017 20:53:47 GMT

Hi James, by way of update, I am still searching for a way to have the location information populate a geopoint question on a web form. I understand pulling lat long from a csv doesn't function in a web form and I have also tried the method described in the sample templates where the coordinates are part of the name field which also doesn't seem to work in the web form. Is there a solution yet to having this functionality in web forms? Thanks Tom

Re: Pull data from csv into webform

JamesTedrick — Wed, 17 May 2017 21:51:21 GMT

Hi Tom,

populating the geopoint in the new webform works - take a look at the attached sample.

Re: Pull data from csv into webform

tomhughson — Thu, 18 May 2017 07:07:47 GMT

Hi James yes that works thank you

Re: Pull data from csv into webform

PatrickHannan1 — Thu, 08 Mar 2018 20:41:38 GMT

I'm having the same issue with the csv not populating in the iPhone app. I created my form in Survey123 Connect and it scans a badge, pulls the badge number from from the csv and inputs the persons information. I tested the form through Survey123 Connect using my laptop camera and it populated the data. When I tested the form on the iPhone app, the badge is scanned but it doesn't pull the data from the csv. Is there any way to fix this?

Re: Pull data from csv into webform

JamesTedrick — Tue, 13 Mar 2018 16:08:18 GMT

Hi Patrick,

One thing to check is whether the file name is the same, including capitalization, between the XLS file and the name of the file - iOS is case sensitive, while other operating systems are not.

Re: Pull data from csv into webform

TKSHEP — Tue, 13 Mar 2018 21:00:30 GMT

I am trying to do the exact thing, would you be will to share with me how you set up the barcode to read information form a csv and populate the fields that it finds such as in your example you used. I would greatly appreciate it.