topic Re: How is pull data updated? in ArcGIS Survey123 Questions

How is pull data updated?

deleted-user-4eCuGRDZm2v8 — Tue, 11 Jun 2019 13:35:45 GMT

I need to create a browser based survey that at first, searches through a list of addresses within our city. I understand I can do this using a CSV and the pull data function but how is the data updated? If I run a script to update the CSV do I have to republish the survey each time?

Scott

Re: How is pull data updated?

JamesTedrick — Tue, 11 Jun 2019 22:28:24 GMT

Hi Scott,

Yes, the survey will need to be republished when the CSV is updated. That can be done either manually or automatically; see Updating the media folder of a Survey123 Form item for information on how to automatically do this.

Re: How is pull data updated?

deleted-user-4eCuGRDZm2v8 — Wed, 12 Jun 2019 20:08:42 GMT

Thanks for the feedback James, I'll look into it.

Scott

Re: How is pull data updated?

deleted-user-4eCuGRDZm2v8 — Mon, 17 Jun 2019 17:03:11 GMT

Separately, I'm having issues using the csv for user selection. Do I need to do pulldata function and then select_one or can I just select_one and reference the csv?

Re: How is pull data updated?

deleted-user-4eCuGRDZm2v8 — Sun, 12 Dec 2021 10:32:25 GMT

I've created the file and uploaded it using Survey123 Connect but an error occurs when I run the script. Am I missing something?

Error:

...Starting
...Authenticating
...Querying
Runtime error 
Traceback (most recent call last):
  File "<string>", line 105, in <module>
KeyError: 'name'‍‍‍‍‍‍‍

Script:

102  print ("...Querying")
103  # get the name of the zip file
104  serviceInfo = getServiceDefinition(agol_helper.token, itemID)
105  zipFileName = serviceInfo['name']
106  print ("Zip file name: " + zipFileName)‍‍‍‍‍

Re: How is pull data updated?

JamesTedrick — Tue, 18 Jun 2019 22:46:00 GMT

I would suggest first having the pulldata function populate a text or note question to confirm that you are seeing teh values you expect - in particular, extra commas in the table can cause the wrong values to be retrieved.

Re: How is pull data updated?

JamesTedrick — Tue, 18 Jun 2019 22:49:39 GMT

Hi Scott,

That error indicates that the script had an issue getting information via the feature service. Is this using an existing feature service? You may want to create a hard-coded version with the name of the zip file (same as the XLS file) pre-set in that case.

Re: How is pull data updated?

deleted-user-4eCuGRDZm2v8 — Wed, 19 Jun 2019 12:56:55 GMT

I changed the links in the script to https and that seems to have fixed it.

However, the script doesn't seem to be updating the data. I'm using the external choice list option. The script completes successfully but the choice list isn't updated.

Re: How is pull data updated?

JamesTedrick — Fri, 21 Jun 2019 19:18:50 GMT

Just to confirm, you are not seeing the update after manually updating (or deleting and redownloading) the form on the device?

Re: How is pull data updated?

deleted-user-4eCuGRDZm2v8 — Fri, 21 Jun 2019 19:21:41 GMT

Yes that's correct, but I'm using the web form.

Re: How is pull data updated?

JamesTedrick — Thu, 27 Jun 2019 22:05:20 GMT

Hi Scott,

Thanks for the clarification. Even though you are using the web form, could I ask you to check via the field app (Windows/Mac)? You can access the files downloaded in <User Directory>/ArcGIS/My Surveys and see if they have been updated.

Re: How is pull data updated?

deleted-user-4eCuGRDZm2v8 — Fri, 28 Jun 2019 13:55:03 GMT

Ok, I installed the field app and ran the script again and it did put a new file in that folder but it's not providing any new addresses to select from. Do I need to name my file itemsets.csv so it overwrites the existing? Screenshot below.

Re: How is pull data updated?

JamesTedrick — Fri, 28 Jun 2019 15:35:44 GMT

Hi Scott,

The file needs to be named the same as specified in the pulldata function - if you are using the CSV file generated from the external choice list, then it would need to replace the itemsets.csv file

Re: How is pull data updated?

deleted-user-4eCuGRDZm2v8 — Fri, 28 Jun 2019 15:44:52 GMT

Maybe that's where my disconnect is, because I was under the impression that I didn't actually need a pull data function here. My understanding was that the XLS form has a external choice list tab which creates a CSV, which can then be updated via the script. Does the XLS form need to have the pull data function in it?

Re: How is pull data updated?

JamesTedrick — Fri, 28 Jun 2019 16:45:23 GMT

Hi Scott,

If you're trying to update an external select, then you need to replace the itemsets.csv file directly - that file is the one used for external selects.

Re: How is pull data updated?

deleted-user-4eCuGRDZm2v8 — Fri, 28 Jun 2019 16:54:00 GMT

Do you mean manually replace the file or just rename (to itemsets.csv) the csv that's being used in the script?

Re: How is pull data updated?

JamesTedrick — Fri, 28 Jun 2019 16:55:32 GMT

Using the script, it would probably be easiest to rename the CommunityAddresses to itemsets so that it overwrites the file.

Re: How is pull data updated?

deleted-user-4eCuGRDZm2v8 — Fri, 28 Jun 2019 17:01:04 GMT

I did that and the script runs successfully but the file doesn't update.

Re: How is pull data updated?

JamesTedrick — Fri, 28 Jun 2019 17:08:30 GMT

Hi Scott,

The file you are showing is interesting - it indicates that it was made tomorrow?

Re: How is pull data updated?

deleted-user-4eCuGRDZm2v8 — Fri, 28 Jun 2019 17:10:16 GMT

Yeah that obviously didn't make any sense either but wasn't sure it applied. Or maybe more accurately I was baffled by it so I decided to ignore it