Delete Features and Attachements

[kapalczynski]

Which GeoProcessing Tool deletes all the Feature Class records and ALL the attachments?

[AlfredBaldenweck]

Assuming it's in a geodatabase, rather than AGOL, you want to use Truncate on both the feature class ("....gdb\exampleFc") and the attachment table ("....gdb\exampleFc__ATTACH") Note: There are two underscores before ATTACH

[kapalczynski]

OK so there is on tool that does both I have to address but the FC and Attach Table

Yes this is an enterprise GDB

[AlfredBaldenweck]

Yes, run it twice.

[kapalczynski]

If I use Append ... does that add Features and Attachments back ?

[AlfredBaldenweck]

It depends.

Append would definitely work to add the features back in to your feature class.

Attachments are a little more complicated. Appending from another Attachment table would get the records in, but you'd manually have to change the relGlobalID to make them match.

Using the Add Attachments (and generate match table) tool is slower, but it works on attachments sitting in a folder.

[kapalczynski]

Not really following the attachments part... 

Assuming the FC and Attachments in the target are EMPTY

• Do I need to run a process to create the match table
• Then append attachments using this table?

Not sure how that workflow works....

[AlfredBaldenweck]

To be honest, I'm not really sure what you're trying to accomplish here.

If you empty both tables, append in the features to the feature class.

From there, you have the following options:

• Manually add attachments to each feature using the Attribute Pane
• If you're trying to copy/paste attachments from another attachment table, you can just do that with Append, but you'll have to manually change the RELGLOBALID in the attachment table to actually make them correctly attach to the appropriate record in the feature class.
• OR, if your new attachments live in a folder, run "Generate Match Table" using the feature class and said folder, then run "AddAttachments".

[kapalczynski]

• I have 2 FC and 8 tables in AGOL... with relationships
• I have 2 FC and 8 Tables in Enterprise DB SDE ... with relationships
• I need to get the data from AGOL into SDE including the Attachments while retaining GLOBALIDs with relationships

[kapalczynski]

I have hundreds of attachments if not thousands... 

I dont understand this workflow

• If you're trying to copy/paste attachments from another attachment table, you can just do that with Append, but you'll have to manually change the RELGLOBALID in the attachment table to actually make them correctly attach to the appropriate record in the feature class.