topic Export attachment from database (Arcgis desktop 10.2) in Data Management Questions

Export attachment from database (Arcgis desktop 10.2)

BartoszBrzeziński1 — Tue, 12 Jul 2016 08:07:27 GMT

Hi everyone,

I would like to ask you about help. Maybe you have some solutions already. How could I export/extract few attachments for selected features from geodatabase? I tried use python scripts but no results. Thanks for help.

Re: Export attachment from database (Arcgis desktop 10.2)

JakeSkinner — Sat, 11 Dec 2021 23:36:47 GMT

Hi Bartosz,

Here is an example how to do this using python:

import os, arcpy
tbl = r"C:\Temp\Python\Test.gdb\Graffiti__ATTACH"
fldBLOB = 'DATA'
fldAttName = 'ATT_NAME'
outFolder = r"C:\Temp\Python\Attachments"

with arcpy.da.SearchCursor(tbl,[fldBLOB,fldAttName]) as cursor:
   for row in cursor:
      binaryRep = row[0]
      fileName = row[1]
      # save to disk
      open(outFolder + os.sep + fileName, 'wb').write(binaryRep.tobytes())

print 'Finished'

Re: Export attachment from database (Arcgis desktop 10.2)

BartoszBrzeziński1 — Tue, 12 Jul 2016 12:20:45 GMT

How should I excute it? I`m not good of using scripts.

Re: Export attachment from database (Arcgis desktop 10.2)

JakeSkinner — Tue, 12 Jul 2016 12:34:40 GMT

Attached is a zip file that contains a toolbox with a GP tool you can run to export the attachments.

Re: Export attachment from database (Arcgis desktop 10.2)

BartoszBrzeziński1 — Tue, 12 Jul 2016 12:48:58 GMT

I get something like this.

Re: Export attachment from database (Arcgis desktop 10.2)

BartoszBrzeziński1 — Tue, 12 Jul 2016 12:51:37 GMT

I change in script "GlobalID" for "ATTACHMENTID" and it worked. Thank you Jake for your help.

Re: Export attachment from database (Arcgis desktop 10.2)

JoeLivoti_II — Thu, 07 Jun 2018 15:44:53 GMT

Hi Jake,

This script worked beautifully except for one thing that I need. Is there anyway to augment the script to change the name of the file to a parcel number in a related table or to include the parcel number in the attributes for the exported file? Thank you for your help!

-Joe

Re: Export attachment from database (Arcgis desktop 10.2)

JakeSkinner — Mon, 11 Jun 2018 19:42:17 GMT

If the parcel number is in the feature class, then this would easy to do simply by updating the SearchCursor. If the parcel number is in a related table, it would require a lot more coding to obtain this value. I found the following post that may be of some help:

https://community.esri.com/thread/88195

Re: Export attachment from database (Arcgis desktop 10.2)

WilliamParco_GISP — Wed, 13 Feb 2019 19:55:46 GMT

Hello Jake,

Sorry for reviving a dead post, but you mention that if the parcel number is in the feature class, then it would take a simple update to the SearchCursor to have the exported attachments be named with that number.

Would you be willing to elaborate on what needs changing? I've used this script many times with success, but I now have to sort my attachments by municipality and it would be great if I could just have them named with a field from the feature class and my coding skills are lacking.

Any advice on what needs changing would be very helpful.

Re: Export attachment from database (Arcgis desktop 10.2)

JakeSkinner — Sat, 11 Dec 2021 23:36:49 GMT

William Parco GISP‌ you could do something like below:

import os, arcpy

fc = r"C:\PROJECTS\Collector\FieldData.gdb\ResidentialBuildings"
tbl = r"C:\PROJECTS\Collector\FieldData.gdb\ResidentialBuildings__ATTACH"
fldBLOB = 'DATA'
fldAttName = 'ATT_NAME'
attachRelate = 'REL_GLOBALID'
parcelField = 'OBJECTID'
parcelRelate = 'GlobalID'
outFolder = r"C:\Temp\Python\Attachments"

with arcpy.da.SearchCursor(tbl,[fldBLOB,fldAttName, attachRelate]) as cursor:
   for row in cursor:
      binaryRep = row[0]
      with arcpy.da.SearchCursor(fc, [parcelField], "{0} = '{1}'".format(parcelRelate, row[2])) as cursor2:
        for row2 in cursor2:
            fileName = str(row2[0]) + ".jpg"
      # save to disk
      open(outFolder + os.sep + fileName, 'wb').write(binaryRep.tobytes())

print 'Finished'‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

attachRelate = foreign key in attachment table (used for relationship)

parcelField = field you want the attachment to be called once exported

parcelRelate = primary key in feature class (used for relationship)

Re: Export attachment from database (Arcgis desktop 10.2)

WilliamParco_GISP — Thu, 14 Feb 2019 17:01:38 GMT

Ah, now I understand what you were getting at. Thank you for that. I've updated my script and saved a good few hours of sorting.

Re: Export attachment from database (Arcgis desktop 10.2)

ShelbyWeigand — Thu, 05 Mar 2020 17:51:37 GMT

Is there a way to do this without adding to the original attachment name? For example the original attachment name is image_downstream-0c6729a48c7f4735813318cbce71957b but when I run the tool all the attachments have a series of numbers at the end (image_downstream-0c6729a48c7f4735813318cbce71957b_{66F1D494-DBED-4B26-8E9B-F5627F862DCA}). Thanks!