topic pull data from external CSV in Survey123 in ArcGIS Survey123 Questions

pull data from external CSV in Survey123

DirkPeterson2 — Tue, 16 Mar 2021 12:46:45 GMT

I am working on a survey we will be using to collect pipeline data. We use a device that will calculate the yield strength and tensile strength of pipe exposed in the trench during an integrity dig. The output is an Excel document. Is there a way to pull the data into S123 so it does not have to be typed by hand? We are looking to reduce human error wherever we can. I have already looked at https://community.esri.com/t5/arcgis-survey123-blog/use-existing-data-in-your-survey-the-pulldata-function/ba-p/896889 , and that won't work because the data has to be loaded to the Media folder prior to publishing. Any help would be appreciated.

Re: pull data from external CSV in Survey123

DougBrowning — Tue, 16 Mar 2021 13:46:59 GMT

Why can you not add the file to the media folder? It works great.

There is a way to read a CSV from AGOL or a feature service that is still in beta. Of course you would need internet access. It is still early adopter so take a look there. https://earlyadopter.esri.com/project/article/item.html?cap=e69ef91f45744b98882c651f7b518eb7&arttypeid={5a8e51ed-4a87-43fe-a67d-2b7829af130f}&artid={F91C2CD4-2A42-4CA3-AC7D-755A5C34F811}

hope that helps

Re: pull data from external CSV in Survey123

DirkPeterson2 — Tue, 16 Mar 2021 16:44:11 GMT

They are taking the measurements in the field and want to add them to the survey. I looked at the files for my surveys on my iPad, and did not see a Media folder like there is when I look on my PC. Is there somewhere in the file structure we could put the csv and the survey would be able to pull the data?

Re: pull data from external CSV in Survey123

DougBrowning — Tue, 16 Mar 2021 16:51:34 GMT

Is this Connect or the web builder? In Connect you add files to the media folder and they get pushed to the tablet for you.

On a PC using Connect it should look like this.

I can then do lookups to all of these files. I do what you are describing all the time.

Hope that helps

Re: pull data from external CSV in Survey123

DirkPeterson2 — Tue, 16 Mar 2021 17:38:53 GMT

I believe you are setting these up before a survey is done. What I am trying to do is pull data from a csv that is created by a machine in the field that determines yield strength and tensile strength. Since there are quite a few numbers, I was hoping to be able to use pulldata to reduce any human error when typing in all the measurements taken in the field.

Re: pull data from external CSV in Survey123

DougBrowning — Tue, 16 Mar 2021 18:12:15 GMT

How would you physically move it from the device to the tablet? That's the hard part unless I am not getting it right.

You could copy paste it from a USB stick if that is an option?

Re: pull data from external CSV in Survey123

ShariForbes — Wed, 01 Dec 2021 17:57:03 GMT

Hi Doug. I wonder if you can help me. I've got my .csv in the media folder and the pull data function is working great in Survey123 Connect prepopulating the questions. When I publish it to use in the web I get this error "FormLogicError: instance "CWAreas" does not exist in model". In addition, I've uploaded the CWAreas.csv to AGOL and linked it to the XLS form in Survey123 Connect with same error.

Re: pull data from external CSV in Survey123

DougBrowning — Wed, 01 Dec 2021 18:05:53 GMT

I am not sure pulldata works on the web? It used to not but not sure now. You will have to look that up.

https://community.esri.com/t5/arcgis-survey123-questions/survey123-web-form-not-recognizing-pulldata-csv/td-p/851429