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; } } }

EXPORT ATTACHMENTS ArcTOOL per FILE TYPE

ModernElectric

I found the answer I was looking for previously on mass downloading and organizing attachments from an AGOL Hosted Feature Layer. I am using the Export Attachment geoprocessing tool and it works great.

However, there are a number of different types of attachments, PDFs, images, etc that I have on a variety of different hosted feature layers used in Workforce and Survey123.

Is there a way within the tool, or another tool, to choose which file type I want selected and exported, IE .JPEG versus .PDF? This would help on the export and organization workflow I am building.

Encuentra más publicaciones etiquetadas con

Content Management

Accepted answers

All comments

ryanuthoff

According to the tool documentation, it honors selections. Would you be able to pre-select all the records based on attachment type, and then use the tool? I haven't personally tried that before, but that's the first thought I had.

ModernElectric

Yes, the tool does allow for selection using the Select Layer by Attributes. I am using ArcGIS Pro, first building a model to select the records from a Hosted Feature Layer (ie, date range) and then using the Export Attachments tool.

However, unsure how I select the specific attachment type by file type, .JPEG or .PDF that are attached to the selected feature.

What I want to do is select all the .JPEG images and export those to a specific achieve folder on our network and do a separate export of .PDF attachments and export those to a different separate folder.

ryanuthoff

Well, I was thinking if there was any sort of standardization in the records where you can tell based off of something in the record of what file type it is, you could only select those records and export them. For example, if records that only have a specific attribute "A" are only associated with PDFs, then select all "A" records and export them. But, I totally realize that's probably not feasible. It's more of a long shot idea.

From what it sounds like, you have a single record with multiple file attachment types and want to filter out the attachments that way. Unfortunately in that case, I'm not aware of a way to do that.

ModernElectric

Appreciate the feedback. Yes, sounds like you understand exactly what I am trying to do.

Want to be able to write a series of scripts/models to export key attachments and organize into different folders for achieves. If I can figure out how to select certain file types, will save tons of hours of manually organizing the different files. In the future, I can run a batch file that will run the scripts to run a monthly data download, organization, sorting and achieving of field pictures and Survey PDF reports.

Just need this added step to progress with my design.

DavidSolari

If you can't filter up front, filter out back. Here's a sample that will remove all non-PDF/JPEG attachments from the folder you downloaded them to:

import os
out_dir = r"C:\path\to\folder\with\attachments"
extensions = [".pdf", ".jpeg", ".jpg"]
for root, _, files in os.walk(out_dir):
    for f in files:
        if not any(f.lower().endswith(e) for e in extensions):
            os.remove(os.path.join(root, f))

Feel free to tweak that third line to match your desired results.

Robert_LeClair

I think with some Python scripting you should be able to do this - CAVEAT - I have not tested this script as I don't have a feature class with attachments. Let me know how it goes.

import arcpy
import os

# Set paths
input_fc = r"C:\Path\To\Your\FeatureClass" # Feature class with attachments
output_folder = r"C:\Path\To\ExportedAttachments"

# Make sure output folder exists
if not os.path.exists(output_folder):
os.makedirs(output_folder)

# Get the name of the attachment table
desc = arcpy.Describe(input_fc)
attachment_table = desc.AttachmentTableName

# Check if the feature class has attachments
if not desc.HasAttachments:
raise Exception("This feature class does not have attachments.")

# Create a list of desired file types
valid_extensions = ['.pdf', '.tif', '.tiff', '.docx']

# Create a temporary table view of the attachment table
arcpy.management.MakeTableView(attachment_table, "attachment_view")

# Loop through each extension type and export attachments
for ext in valid_extensions:
# Build SQL query for this file type
where_clause = f"UPPER(NAME) LIKE '%.{ext.strip('.').upper()}'"

# Export matching attachments
arcpy.management.ExportAttachments(
input_fc,
"attachment_view",
output_folder,
"REL_GLOBALID", # Match field
"ATT_NAME",
"DATA",
where_clause
)
print(f"Exported all {ext.upper()} files.")

print("Done exporting attachments.")

DavidSolari

This is a fantastic idea unless you read the entire first sentence in the OP, then it's useless for this case.

ModernElectric

@DavidSolari @Robert_LeClair

Thank you for both suggestions, big big help. I am in the process of doing some experimentation and will see what works. Will publish my results once I get it figured out.

mjensenesri

This is a great idea for the Export Attachments tool! I have added this idea to future updates for the tool in a later release. In the meantime, the sample tool to download attachments in this blog has an update to the tool that will allow the user to check a box to export to a specific file type. For example, if you only want to download your .pdf attachments, then check the box and enter .pdf in the text field. The caveat to this updated tool is that it only works with feature classes and tables that have been enabled and have attachments. It does not support feature services. Feature services would have be downloaded to a file geodatabase first, then the new updated tool could download the desired attachments. Stay tuned as we work to implement these ideas in upcoming releases!

ModernElectric

@MikeJensen

Appreciate the feedback. Yes, I learned that the Hosted Feature Layer needs to be downloaded to a local GDB first, for it to work. I've built a Python script that does just that. After the new release, I will update my scripts. Is it possible that release will include the ability to download the attachments straight from a Hosted Feature Layer?

mjensenesri

Yes, the plan is that the export can occur with both feature classes and a hosted feature layer in a feature service. Stay tuned!

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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