topic Re: Pull data for dates not working in browser but works in Connect and mobile app in ArcGIS Survey123 Questions

Pull data for dates not working in browser but works in Connect and mobile app

MatthewBradbury — Tue, 18 May 2021 15:27:45 GMT

When pulling data using the pulldata() function for date or dateTime types from a csv in the media file, the value is not pulled while using the survey in a browser; I tried the latest desktop versions of Chrome, Firefox, and Edge, and none of them worked. The date value does pull inside of Survey123 Connect as well as the Survey123 app, and it is converted to the correct format (ex: 5/18/2021 in csv file comes in as 1262332800000). I know the pull data function in a browser is working as I can pull the date in the csv as a string type and view it inside of the survey without any issues.

Re: Pull data for dates not working in browser but works in Connect and mobile app

Waffle_House — Sat, 12 Jun 2021 08:07:27 GMT

Hi @MatthewBradbury, are there any blank columns in your CSV file?

Re: Pull data for dates not working in browser but works in Connect and mobile app

MatthewBradbury — Wed, 16 Jun 2021 16:32:35 GMT

Hi @Waffle_House , I was able to get it working, but I honestly do not know what was happening. I tried starting a brand new survey just pulling dates in various formats and some of them worked, and others did not. It's a bit odd, but I am at least moving forward.

Re: Pull data for dates not working in browser but works in Connect and mobile app

Waffle_House — Tue, 22 Jun 2021 04:48:22 GMT

Darn, well glad you got it working! Can you mark this post as answered?

Re: Pull data for dates not working in browser but works in Connect and mobile app

BrettCase — Tue, 06 Jul 2021 19:19:59 GMT

I am having this same issue.

it also seems that when i publish to ArcGIS Online that things are not being updated.

for instance i can completely delete the table that pulldata is referencing from my media folder. publish the form and somehow it is still pulling data from somewhere.

Re: Pull data for dates not working in browser but works in Connect and mobile app

KerryKang — Fri, 06 Aug 2021 20:36:42 GMT

Hello @MatthewBradbury

Could you share how you made it work? I posted a question yesterday, here is how I prepared my csv.

https://community.esri.com/t5/arcgis-survey123-questions/pulldata-with-dates/m-p/1086371#M36345

Thanks.

Re: Pull data for dates not working in browser but works in Connect and mobile app

MatthewBradbury — Mon, 09 Aug 2021 14:24:15 GMT

It would be beneficial if we could see the related media files after the service has been published, though I imagine they are being stored in a different format. It would also be very useful if we could create a table on ArcGIS Online, and reference that in the surveys instead of a local spreadsheet.

Re: Pull data for dates not working in browser but works in Connect and mobile app

BrettCase — Mon, 09 Aug 2021 18:38:05 GMT

Hello,

My problem was related to the date field in my .csv in the media folder not being compatible with the date format in the browser.

I just eliminated the date field and it worked. I did not find a good work around.

Re: Pull data for dates not working in browser but works in Connect and mobile app

Ramon_de_Leon — Mon, 25 Apr 2022 21:18:09 GMT

I am having the same problem now, have something that was working for a couple of years (both app and browser).... I just noticed that the "pulldata" when the survey is done through the browser stopped working... I never changed anything in my workflow and it is still working as expected on mobile apps and connect...

Has anyone solved this mystery?

Re: Pull data for dates not working in browser but works in Connect and mobile app

MatthewBradbury — Mon, 25 Apr 2022 21:22:32 GMT

I can't remember how I resolved this, or if it just solved itself. You might try being explicit with how data-time values are brought in using Decimal Date Time. I know that the bowser version of Survey123 can only work in the date(decimal-date-time()) function. You can read more about it here:

https://doc.arcgis.com/en/survey123/browser/create-surveys/decimaldatetime.htm

Good luck.

Re: Pull data for dates not working in browser but works in Connect and mobile app

Ramon_de_Leon — Tue, 26 Apr 2022 20:27:31 GMT

@MatthewBradbury just like you I do not know how I resolved it.... I just republished my survey a few times then it worked.... some thing you just can't explain 🙂

Re: Pull data for dates not working in browser but works in Connect and mobile app

JasonJordan00 — Tue, 07 Jun 2022 17:21:34 GMT

I've been fighting with this problem as well and after a lot of trial and error I've found pulldata only works in a web form if dates are formatted YYYY-MM-DD in the CSV.