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

Adding multiple attachments to a single point using Generate Match Table and Add Attachments

Hayley

I am trying to automatically add multiple photo attachments to a point using Add Attachments.

First I need to use Generate Match Table to create the match table, and am struggling to create a photo path for multiple attachments. My working folder has photos 18_1a, 18_1b, and 18_1c and my matching field is 18. This path works when there is a single "18" named photo, but the rest of the photos do not get picked up. How do I name these so the tool recognizes multiple attachments for my singular "18" point?

Najděte více příspěvků označených jako

Accepted answers

JohannesLindner

The tool only generates a 1:1 table, the match field and file name have to be exactly the same.

With this little script, you can do what you want:

# same parameters as in the tool
in_table = "TestPoints"
in_folder = r"N:\ags1_daten\gewaesserkataster\Projekt\Bearbeitung\test"
out_match_table = r"memory\match2"
key_field = "OBJECTID"
input_data_filter = "*"  # eg "*.jpg"
relative_path = True


from pathlib import Path
# create match table
p = Path(out_match_table)
match_table = arcpy.management.CreateTable(str(p.parent), str(p.name))
arcpy.management.AddField(match_table, "Filename", "TEXT")
arcpy.management.AddField(match_table, "MatchID", "LONG")

# get all files that match your filter
in_files = list(Path(in_folder).glob(input_data_filter))

# for each row in in_table, get all files that match the key field or start with key field followed by "_"
with arcpy.da.InsertCursor(match_table, ["MatchID", "Filename"]) as i_cur:
    with arcpy.da.SearchCursor(in_table, [key_field]) as s_cur:
        for row in s_cur:
            key = str(row[0])
            for f in in_files:
                if f.stem == key or f.stem.startswith(key + "_"):
                    fn = f.name if relative_path else str(f)
                    i_cur.insertRow([row[0], fn])

All comments

AndrewPayne

Johannes,

Thanks for taking the time to answer everyone's questions. I have a layer that has multiple photos taken of a location with individual attachment columns. Please see below

The photos are all in a file location outside the gdb. I've enabled attachments. I've tried to create a match table but each time it only shows the headers and no rows underneath.

When I attempted the python script I was getting an error

File "C:\SubsurfaceMaps\ATTACHMENTS.pyt", line 13, in <module> match_table = arcpy.management.CreateTable(str(p.parent), str(p.name)) NameError: name 'arcpy' is not defined

Any help or insight would be very much appreciated.

Thank you

JohannesLindner

My guess is that your in_table is a layer that has a selection?

LMSID

Hi Johannes, thank you so much for your code and solution.

I seem to be running into an issue where only the first few records are imported into the match table (in your example, it would be as if only 1.txt, 1_a.txt and 1_b.txt were brought in and 2.txt and subsequent were ignored).

Do you have any idea why this might be happening?

Thanks so much!

Amelia

JohannesLindner

I'm not quite sure what you're doing here... This seem to be either a modified attachment table or the attachment table joined to the feature class. And now you want to add new attachments based on the name of the attachments that are already present?

Anyway, the original script matches files whose names (without extension) match the key field value or start with that value followed by an underscore. Your name field includes the extension, so the script doesn't find any matching files.

Change line 24 of the original script:

            key = str(row[0]).split(".")[0]

This will split the value in the key field at the dot and take that first part, which is the name without extension.

HeatherBell

Hi @JohannesLindner,

I've attached :

an image of the data fields
screenshot of the photos which correspond to the field 'name'
a screenshot of the attribute table of the layer - not all fields are visible because there are a lot.

Thank you so much.

Best wishes,

Heather.

fields_for_match_layer.png

attribute_table.JPG

JohannesLindner

Can you please post screenshots of

your in_table, at least the name field
the files in your photo folder, ideally showing some files that belong to the same row

HeatherBell

Hi @JohannesLindner, I've tried using your script to generate an Attachment Match Table for multiple jpgs per row which I want to attach to a feature layer. I'm only returning an empty match table but not recieving any errors. I'm using a field called 'name' in the 'in_table' which matches the photo filenames in the 'photos' folder. There are approximately 6000 images in the 'photo's' folder. I'm not sure why it isn't working, do you have any advice? Thank you.

# same parameters as in the tool
in_table = "NFM_for_match"
in_folder = r"C:\GIS\photos"
out_match_table = r"C:\GIS\working.gdb\matchtable"
key_field = "name"
input_data_filter = "*" # eg "*.jpg"
relative_path = True

from pathlib import Path
# create match table
p = Path(out_match_table)
match_table = arcpy.management.CreateTable(str(p.parent), str(p.name))
arcpy.management.AddField(match_table, "Filename", "TEXT")
arcpy.management.AddField(match_table, "MatchID", "LONG")

# get all files that match your filter
in_files = list(Path(in_folder).glob(input_data_filter))

# for each row in in_table, get all files that match the key field or start with key field followed by "_"
with arcpy.da.InsertCursor(match_table, ["MatchID", "Filename"]) as i_cur:
with arcpy.da.SearchCursor(in_table, [key_field]) as s_cur:
for row in s_cur:
key = str(row[0])
for f in in_files:
if f.stem == key or f.stem.startswith(key + "_"):
fn = f.name if relative_path else str(f)
i_cur.insertRow([row[0], fn])

Thank you,

Heather

JohannesLindner

open the Python window
Copy and paste the script
edit the variables at the start of the script
run with Enter

Hayley

You will need to enter it into the Python command window in ArcGIS Pro

MichaelBroderick

Hello Johannes,

I know this thread is old. But, I am attempting to do the same thing. I just can't figure out how to enter the script into the tool to be used. Any pointers?

Hayley

Ah oopsies, yes that makes sense, thank you!

JohannesLindner

You're confusing Add Attachments and Generate Attachment Match Table.

Your bullet point is from Add Attachments and is absolutely correct. This tool can add multiple attachments for the same feature. For that to happen, the feature's key has to occur in multiple records of the match table. This is what my second screenshot shows: ID 1 is there multiple times.

What I was talking about is Generate Attachment Table, which... generates an attachment table. This tool is only able to perfectly match ID and file name. The only way you get multiple records with the same ID here is to have the same filenames, but different file extensions (1.jpg, 1.jpeg, 1.png, etc).

Hayley

That worked perfectly thank you so much!!!!

Do you know why in the help documentation for the Add Attachments tool it says you can do multiple? "

Multiple files can be attached to a single feature class or table record. To accomplish this the Match Table should contain multiple records for that input ID (for example, record 1 has an InputID of 1 and a pathname pic1a.jpg, and record 2 has an InputID of 1 and a pathname pic1b.jpg).

JohannesLindner

The tool only generates a 1:1 table, the match field and file name have to be exactly the same.

With this little script, you can do what you want:

# same parameters as in the tool
in_table = "TestPoints"
in_folder = r"N:\ags1_daten\gewaesserkataster\Projekt\Bearbeitung\test"
out_match_table = r"memory\match2"
key_field = "OBJECTID"
input_data_filter = "*"  # eg "*.jpg"
relative_path = True


from pathlib import Path
# create match table
p = Path(out_match_table)
match_table = arcpy.management.CreateTable(str(p.parent), str(p.name))
arcpy.management.AddField(match_table, "Filename", "TEXT")
arcpy.management.AddField(match_table, "MatchID", "LONG")

# get all files that match your filter
in_files = list(Path(in_folder).glob(input_data_filter))

# for each row in in_table, get all files that match the key field or start with key field followed by "_"
with arcpy.da.InsertCursor(match_table, ["MatchID", "Filename"]) as i_cur:
    with arcpy.da.SearchCursor(in_table, [key_field]) as s_cur:
        for row in s_cur:
            key = str(row[0])
            for f in in_files:
                if f.stem == key or f.stem.startswith(key + "_"):
                    fn = f.name if relative_path else str(f)
                    i_cur.insertRow([row[0], fn])

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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