topic Re: How to download all the photos only of the selected surveys and not all surveys. in ArcGIS Survey123 Questions

How to download all the photos only of the selected surveys and not all surveys.

ChristopherVan_de_Wyngard — Fri, 11 Jan 2019 16:53:33 GMT

When a record is selected I have tried to do a File Geodatabase export and it downloads all the records not just one or two being selected.

Re: How to download all the photos only of the selected surveys and not all surveys.

BrandonArmstrong — Fri, 11 Jan 2019 21:00:32 GMT

Hi Christopher,

Are you using the method highlighted in the screenshot below? I just tested by selecting once record and exporting, which worked as expected.

Re: How to download all the photos only of the selected surveys and not all surveys.

ChristopherVan_de_Wyngard — Tue, 15 Jan 2019 17:40:05 GMT

Brandon,

I verified that I was using the method as highlighted in the screenshot and when I download a File Geodatabase it downloads all the images from all records.

My method is to make sure that the “Selected records only” is selected, that only one record is selected, and then I click download “File Geodatabase”. Then I run the ArcMap script to get photos and it pulls all the photos for all records.

Thanks,

Chris

Re: How to download all the photos only of the selected surveys and not all surveys.

BrandonArmstrong — Tue, 15 Jan 2019 22:00:46 GMT

So, when you add the feature class from the exported file geodatabase to ArcMap, records other than those that were selected are present? Which ArcMap script are you referring too?

Thanks,

Brandon

Re: How to download all the photos only of the selected surveys and not all surveys.

ChristopherVan_de_Wyngard — Tue, 15 Jan 2019 22:06:13 GMT

The script that I am currently using is the one recommended by survey123, the arcpy code is below. When I use ArcMap to pull the images from the geodatabase then I still pull all the images from all the records and not just the one selected originally.

import arcpy

from arcpy import da

import os

inTable = arcpy.GetParameterAsText(0)

fileLocation = arcpy.GetParameterAsText(1)

with da.SearchCursor(inTable, ) as cursor:

for item in cursor:

attachment = item[0]

filenum = "ATT" + str(item[2]) + "_"

filename = filenum + str(item[1])

open(fileLocation + os.sep + filename, 'wb').write(attachment.tobytes())

del item

del filenum

del filename

del attachment

Re: How to download all the photos only of the selected surveys and not all surveys.

BrandonArmstrong — Wed, 16 Jan 2019 00:33:12 GMT

Thank you for clarifying, Chris.

As it turns out, the selection of records on the parent layer in the Survey123 website does not currently correspond to the the related table storing the attachments. This is why the exported related table contains all attachments within the related table.

We do have an open issue for this functionality and we are looking to include it in a future release of the Survey123 website. I have added your comments to the issue and will update you when this changes.

Best,

Brandon

Re: How to download all the photos only of the selected surveys and not all surveys.

ChristopherVan_de_Wyngard — Wed, 16 Jan 2019 00:37:25 GMT

Thanks Brandon,

I look forward for the future release of the Survey123.

Thanks for your time,

Chris