How To: Batch export attachments from a feature class in ArcMap

Summary

There are no geoprocessing tools that allow users to export and save all attachments locally. The instructions provided below describe how to execute a possible solution by creating a script tool to accomplish the task.

Procedure

To batch export attachments from a feature class, create a script tool from a Python script using the workflow provided below, and run the created script tool.

Note:
This script requires that the input table be the standard attachment table created when attachments are enabled on a feature class. This is because the script relies on the DATA, ATT_NAME and ATTACHMENTID fields stored in this table. The typical naming convention should append _ATTACH to the end of the table name.

1. Copy and paste the following script into Notepad, and save it as ExportAttachments.py.

   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:
   This script iterates through the entire attachment table of a single feature class and copies all of the attachments (saved as BLOBs, or binary large objects) to a file.

2. In the Catalog window, navigate to Toolboxes, and right-click My Toolboxes > New > Toolbox.

3. Add a script tool in the new toolbox. Refer to Adding a script tool for steps to do this.
   1. For the Script File, navigate to the location where the ExportAttachments.py script is saved. Select the script, click OK, and click Next.

2. Type Attachments Table in the first row of the Display Name column, and set the Data Type as Table.
3. Add a second parameter and type Output Location for the Display Name, and set the Data Type as Folder.

4. Click Finish. A new script tool is added to the toolbox.

4. Double-click the created script tool to open the tool.

1. In the dialog box, select the attachments table containing the attachments to be extracted in the Attachments Table parameter.
2. Under Output Location, select a folder in which to save the exported attachments, and click OK.

3. Click OK to run the tool. The attachments are successfully exported in batch to the local folder defined in the Output Location parameter.

Related Information

• ArcMap Help: What is a script tool?
• ArcMap Help: Setting script tool parameters
• FAQ: Is it possible to view attachments added to related table records from a feature service in ArcMap?
• How To: Batch export attachments from a feature class in ArcGIS Pro

Last Published: 10/1/2020

Article ID: 000011912

Software: ArcMap 10.8.1, 10.8, 10.7.1, 10.7, 10.6.1, 10.6, 10.5.1, 10.5, 10.4.1, 10.4, 10.3.1, 10.3, 10.2.2, 10.2.1, 10.2, 10.1, 10