topic Re: Survey 123 Photo question. in ArcGIS Survey123 Questions

Survey 123 Photo question.

RyanPiper — Wed, 15 Dec 2021 17:34:56 GMT

Hello all, I have been collecting a lot of data using survey123. Part of my data collection includes photos specific to each point I'm collecting. Moving forward I have exported the dataset and opened it within ArcGIS Pro in order to work with it further. I'd like to export the data as a table and make some changes in Excel and then work with it again in Pro.

However, I want to maintain the connection to the photos that I took, so that we I upload the data onto ArcGIS Online I have the updated table data that I modify in excel and the photos attached to each field as they were originally. I have spent a little time trying to figure this out but can't quite figure out the correct path to do this.

Any help would be much appreciated. Thank you!

Re: Survey 123 Photo question.

ZacharySutherby — Thu, 16 Dec 2021 23:53:00 GMT

Hello @RyanPiper,

This can be accomplished using the ArcGIS API for Python, you can use the export method to export your feature service as an Excel table. When it's exported you can then download the attachments using the sample Michael Kelly provides here. From there you can use a module called openpyxl to map the attachment paths to the associated features in the Excel file.

Re: Survey 123 Photo question.

MicZatorsky_AEC — Tue, 21 Dec 2021 03:15:10 GMT

Assuming

the hosted feature layer is your point of truth and has the attachments
there are calculations and changes want to make in Excel
you have a PK in your data (like a GUID)

You can skip the FGDB download entirely and:

in Pro run Table to Excel using the hosted layer
edit the XLSX as required - noting which records or fields you modified (optional)
Add Join it back to the hosted feature layer on your primary key
update hosted data using selections and Calculate Field to suit your requirements

You can do the lot either as point 'n click or in python.