topic Re: Problems with Survey 123 - Pull Data in ArcGIS Survey123 Questions

Problems with Survey 123 - Pull Data

AnthonyTaccone — Thu, 15 Mar 2018 17:11:35 GMT

I am having trouble implementing the pulldata function using Survey123. I have a CSV file that contains road names and the district associated with the road. That CSV has been put into the media folder of my survey. I believe my calculation formula is correct. When I go into my survey, the district simply doesn't populate or return any value. Any help would be appreciated. A screenshot been added below.

Re: Problems with Survey 123 - Pull Data

BrandonArmstrong — Thu, 15 Mar 2018 17:29:18 GMT

Hi Anthony,

Your pulldata syntax looks to be sound (assuming your StreetAddress matches your ${Street} values), but I am wondering what the reason is for utilizing the calculate question for the process instead of just using the note question to apply the pulldata function?

It seems that your note question is simply reflecting the value derived in the calculate question.

Are you able to share your XLSForm with subset of the information in your CSV? If so, please upload to this thread or I can send you a personal message upon request.

Thank you,

Brandon

Re: Problems with Survey 123 - Pull Data

AnthonyTaccone — Thu, 15 Mar 2018 18:06:52 GMT

Hi Brandon,

I am not able to share the XLSForm. If you could message me, that would be great. In regard to the calculation/note setup, i was trying to follow a template I saw and make it work for me. It does seem irrelevant but I wanted to make sure it would work before I started messing around with everything.

Anthony

Re: Problems with Survey 123 - Pull Data

BrandonArmstrong — Fri, 16 Mar 2018 00:25:37 GMT

Hi Anthony,

I have sent you a private GeoNet message providing you with my email.

Thanks,

Brandon

Re: Problems with Survey 123 - Pull Data

BrandonArmstrong — Thu, 22 Mar 2018 16:12:19 GMT

Hi Anthony,

As shared via email, it is necessary for the external dataset being referenced by the pulldata calculation to be in CSV format. After changing it from an XLSX to CSV, it appears to be working as desired.

Best Regards,

Brandon

Re: Problems with Survey 123 - Pull Data

LeydiRamos1 — Fri, 03 Aug 2018 12:24:54 GMT

Hi,

I am having the same trouble using pulldata function in Survey123. In my case, I have a select_one question to select a municipality (as a label) and write down the XY coordinates (municipio_xy). I am trying to use that field as a link to store the name of the municipality (municipio) and an ID of each one (id_municipio) from a CSV file. That CSV has been put into the media folder of my survey. I belive my calculation formula is correct. When I try to capture (Survey123 App or Suevey123 web) it does not fill the fields as expected. When checking the generated survey123 service these fields are always Null.

I share some images of what I'm trying:

My Survey:

My choices sheet:

My CSV file (placed in media folder):

I have invested some time in discovering what could be wrong. Could you help me see if there's something I'm not seeing? Could it be that the key field between the survey and CSV file is complex? (I've tried with the ID field with the same result).

Re: Problems with Survey 123 - Pull Data

JamesTedrick — Fri, 03 Aug 2018 17:04:18 GMT

Hi Leydi,

Can you open up the CSV file in a text editor? In countries that normally use a comma as the decimal mark, 'CSV' files use a semicolon (;) as a separator.

Re: Problems with Survey 123 - Pull Data

LeydiRamos1 — Fri, 03 Aug 2018 19:52:49 GMT

Hi James,

Thanks for your answer.

I just checked the CSV file in a text editor and I had effectively changed the commas for semicolons. Now I tried my survey again but I still have the same problem.

I tried changing the fields that should be brought from the CSV as note type. Even so, Null appears.

Re: Problems with Survey 123 - Pull Data

JamesTedrick — Fri, 03 Aug 2018 20:01:14 GMT

Hi Leydi,

Can you share the form files?

Re: Problems with Survey 123 - Pull Data

LeydiRamos1 — Fri, 03 Aug 2018 20:13:41 GMT

Hi again,

I have attached my form file (TEST) and CSV file (municipios_pulldata).

Re: Problems with Survey 123 - Pull Data

JamesTedrick — Fri, 03 Aug 2018 20:17:32 GMT

Hi Leydi,

The CSV file works for me. Just to confirm, you are placing the csv file in the media folder of the survey?

Re: Problems with Survey 123 - Pull Data

LeydiRamos1 — Mon, 06 Aug 2018 12:44:57 GMT

Thanks for trying it.

Yes, the file that I passed to you is exactly the one in the media folder.

I have the Survey123 Connect 3.0.127, this will have something to do?

Re: Problems with Survey 123 - Pull Data

JamesTedrick — Mon, 06 Aug 2018 16:21:31 GMT

Hi Leydi,

The version of Survey123 Connect should not be affecting it (in fact, I'm using that version as well). I've attached the version working on my computer.

Re: Problems with Survey 123 - Pull Data

LeydiRamos1 — Tue, 07 Aug 2018 20:00:41 GMT

Hi James!

I can not find what is different between the version you send me and the one I had, but using yours the pulldata works well. I replicated the same in other test forms and they also work perfect.

Thank you very much for the help!

Re: Problems with Survey 123 - Pull Data

IslamSaeed1 — Sat, 19 Oct 2019 21:53:04 GMT

Hello James,

I am facing an issue with Pull data function from a CSV with Arabic data and we entirely depend on this setting on our currently running project so i will be grateful if there any resolution/workaround to be able to pull Arabic values from CSV files

i am using ArcGIS Enterprise 10.7.1 and survey 123 connect 3.6

Re: Problems with Survey 123 - Pull Data

JamesTedrick — Tue, 22 Oct 2019 18:03:03 GMT

Note: I followed up with Islam off-line on this - the issue is the conversion from Excel creating non-UTF-8 CSV files.

Re: Problems with Survey 123 - Pull Data

JanelleLeza — Fri, 22 May 2020 18:25:11 GMT

I am also having this problem, the live survey shows the options that my pull data labeled, however it does not auto populate. One reason is I think that my list in choices nay not be correct.

I am unable to share the data specifically so I left the screen shots as generic as I could

Is this the correct save file name that is in the media file?

Re: Problems with Survey 123 - Pull Data

LebogangMashishi2 — Thu, 18 Jun 2020 20:13:59 GMT

Hi All,

Jumping in with a different issue. I am wondering if you are able to utilise the pulldata function for a survey you created in connect but are viewing on a web browser?

Your help will be appreciated.

Re: Problems with Survey 123 - Pull Data

ahmad_sidani — Mon, 22 Aug 2022 19:48:36 GMT

Hello ,

I am facing also an issue in the pulldata function if the CSV file contains arabic !! any support ?

I am dropping the form(capacity) and the csv(public)

Thanks !!