nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Download attachments to survey in Survey123

Dionisiobattad

HI,

I was trying to download the attached photos from my Survey123 app. I exported the data as geodatabase which contains the point data and the attachments. I then copied and pasted the script in the Technical Support: How to batch export attachments from a feature class in ArcMap into a script tool. I followed exactly the How To but the photos were not export.

I have attached a copy of my geodatabase and the script that I used.

Any help is very much appreciated. I need the photos for a report.

Thanks.

ExportAttachments.py.zip

hazards.gdb.zip

Teresa_Blader_0-1655314871545.png

AgAdmin.PNG

Vind meer berichten getagd met

Accepted answers

DeonLengton

I used this script:


from arcpy import da
import arcpy
import os
import subprocess
arcpy.env.workspace = r"C:\Projects\Test\hazards.gdb"
inTable = "service_b_85814f635e42a59fcbf405bd_hazard_photos__ATTACH"

fileLocation = r"C:\Projects\Test\Photos"

with da.SearchCursor(inTable, ['DATA','ATT_NAME','GLOBALID'],r"") as cursor:
    for row in cursor:
        binaryRep = row[0]
        fileName = str(row[2]) + ".jpg"
        open(fileLocation + os.sep + fileName, 'wb').write(binaryRep.tobytes())

        del row
        del binaryRep
        del fileName

Attached is the photos exported. I usually use the GlobalID so that if i need to change photos and re-import them i can just use the GlobalID to reference the attachment record. Hope that helps.

hazard photos.zip

All comments

DeonLengton

I used this script:


from arcpy import da
import arcpy
import os
import subprocess
arcpy.env.workspace = r"C:\Projects\Test\hazards.gdb"
inTable = "service_b_85814f635e42a59fcbf405bd_hazard_photos__ATTACH"

fileLocation = r"C:\Projects\Test\Photos"

with da.SearchCursor(inTable, ['DATA','ATT_NAME','GLOBALID'],r"") as cursor:
    for row in cursor:
        binaryRep = row[0]
        fileName = str(row[2]) + ".jpg"
        open(fileLocation + os.sep + fileName, 'wb').write(binaryRep.tobytes())

        del row
        del binaryRep
        del fileName

Attached is the photos exported. I usually use the GlobalID so that if i need to change photos and re-import them i can just use the GlobalID to reference the attachment record. Hope that helps.

hazard photos.zip

Dionisiobattad

Thank very much, Don.

SabrinaLafrej

Hi, thank that was very helpfull !

I still have an issue that I can't solve, the picture definition, any idea how to improve image resolution when exporting with this script ?

Thanks !

AngelRomoSandoval

Hello,

I am not able to download the attachments:

My situation is:

I have a featureClass created with Arcgis Survey123 Connect from a Excel xlsmform.

After opening the FeatureClass from Portal in Arcgis Pro I use this script:

import arcpy
from arcpy import da
import os

inTable = arcpy.GetParameterAsText(0)
fileLocation = arcpy.GetParameterAsText(1)

with da.SearchCursor(inTable, ['DATA', 'ATT_NAME', 'ATTACHMENTID']) 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

But I have this Error:

Traceback (most recent call last):
File "T:\01_Software\02_ArcGIS\01_Datenbank\WaloBahn\ArcGIS PRO Python Codes\ExportAttachments.py", line 9, in <module>
for item in cursor:
RuntimeError: A Column was giben that does not exist [DATA]

Possible reason 1: When Survey123 Connect creates automatically a Featureclass from an Excel xlsform file does not create the standard 3 Columns with this name because used another method?: 'DATA', 'ATT_NAME', 'ATTACHMENTID'.

Possible reason 2: I am using as Input the Feature-Class created by Survey123 and I should use a Table (If this is the problem, I do not know how to access to this attachment Table).

Possible reason 3: Should I use as input something like the following? The problem is that I do not know how to find this info (my Feature class is stored in Arcgis Online).

arcpy.env.workspace = r"C:\Projects\Test\hazards.gdb"
inTable = "service_b_85814f635e42a59fcbf405bd_hazard_photos__ATTACH"

Can someone help me?

Regards

Angel

FernandaDiaz

I used this script:

import arcpy

from arcpy import da

import os

inTable = arcpy.GetParameterAsText(0)

fileLocation = arcpy.GetParameterAsText(1)

with da.SearchCursor(inTable, ['DATA', 'ATT_NAME', 'ATTACHMENTID']) 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

*note: the with contains the for

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.