Table with Attachments to Feature Class

1177
2
Jump to solution
02-15-2022 08:05 AM
MatthewMassey
New Contributor III

I'm struggling with a problem and I feel like I'm missing something obvious. I'm trying to migrate a non-spatial table with attachments to a feature class with those same attachments. I'm working in ArcGIS Pro 2.9.1, and the non-spatial table has the X and Y fields. I've tried several things...

  1. "Display XY data" with the non-spatial table. Unfortunately, this doesn't maintain attachments.
  2. "XY table to Point". Same problem...unable to maintain attachments
  3. Editing the relationship class between the non-spatial table and attachment table. Unable to change origin from non-spatial table to new feature class.

Any recommendations without going back to the original attachment images, creating new match tables, etc?

0 Kudos
1 Solution

Accepted Solutions
HuubZwart
Occasional Contributor

Going back to the original images may be quicker 🙂 

But it is possible... 

1. In your original table, make sure you have some sort of unique ID field

2. In the original attachments table, join this ID field to the attachment table using objectid

3. Use Display XY data as described on the original table

4. Enable attachments on the now created new feature class

5. Add the ID field to the new attachment table

6. Append the old attachment table to the new feature class attachment table

7. Join the objectids from the new feature class to the new attachment table using the ID field

8. Recalculate the parent objectids 

9. Delete the excessive fields from the feature class

Your new feature class now has the correct attachments!

View solution in original post

0 Kudos
2 Replies
HuubZwart
Occasional Contributor

Going back to the original images may be quicker 🙂 

But it is possible... 

1. In your original table, make sure you have some sort of unique ID field

2. In the original attachments table, join this ID field to the attachment table using objectid

3. Use Display XY data as described on the original table

4. Enable attachments on the now created new feature class

5. Add the ID field to the new attachment table

6. Append the old attachment table to the new feature class attachment table

7. Join the objectids from the new feature class to the new attachment table using the ID field

8. Recalculate the parent objectids 

9. Delete the excessive fields from the feature class

Your new feature class now has the correct attachments!

0 Kudos
MatthewMassey
New Contributor III

Yes, this worked! One of my problems was that I had GlobalIDs in the original tables, which were causing problems when trying to migrate attachments to a new feature class. But after creating a new GDB and deleting GlobalID, this worked perfect. Thanks!

0 Kudos