topic Updating a hosted csv linked to Survey123 in ArcGIS Survey123 Questions

Updating a hosted csv linked to Survey123

Iron_Mark — Thu, 15 Dec 2022 11:49:11 GMT

Hi,

I need to use pulldata for my survey to retrieve multiple columns of a spreadsheet.

Everything works correctly: the csv is hosted online and linked to the form.

Question is: how can I delegate somebody to update it instead of me? I am the administrator and I have data editor users (mobile workers) and viewers. I see that there are publisher roles but I don't want to ask the company to buy it only to add few rows on a spreadsheet from time to time (The department using the form need to update the spreadsheet and want to deal with it themself).

Is there any other way to update a csv file having mobile worker users and viewers? Or maybe setting like an automatic method of external update like python or something?

Re: Updating a hosted csv linked to Survey123

DougBrowning — Thu, 15 Dec 2022 15:14:48 GMT

I think this is it.

https://github.com/Esri/Survey123-tools/tree/main/Update_CSV_Item

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-external-choice/ba-p/1055534

Hope the helps

Re: Updating a hosted csv linked to Survey123

Iron_Mark — Wed, 21 Dec 2022 10:09:21 GMT

This seems to be the way to go, unfortunately I am not having success to make it work.

Have you already tried it? Are you able to guide me on how to use this notebook? Never had to use one before.

Thanks

Re: Updating a hosted csv linked to Survey123

DougBrowning — Wed, 21 Dec 2022 14:36:41 GMT

No sorry never used notebooks always regular scripts. You should be able to use the code in Python stand alone though. Usually it is a login issue. easiest way is to have Pro logged in then call gis = GIS('pro') at the top of the script.