topic Re: Delete Features and Attachements in Python Questions

Delete Features and Attachements

kapalczynski — Tue, 19 Dec 2023 16:24:59 GMT

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

Re: Delete Features and Attachements

AlfredBaldenweck — Tue, 19 Dec 2023 16:32:37 GMT

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

Re: Delete Features and Attachements

kapalczynski — Tue, 19 Dec 2023 16:34:13 GMT

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

Re: Delete Features and Attachements

AlfredBaldenweck — Tue, 19 Dec 2023 16:37:40 GMT

Yes, run it twice.

Re: Delete Features and Attachements

kapalczynski — Tue, 19 Dec 2023 16:39:09 GMT

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

Re: Delete Features and Attachements

AlfredBaldenweck — Tue, 19 Dec 2023 16:44:08 GMT

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.

Re: Delete Features and Attachements

kapalczynski — Tue, 19 Dec 2023 17:14:22 GMT

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....

Re: Delete Features and Attachements

AlfredBaldenweck — Tue, 19 Dec 2023 17:23:59 GMT

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".

Re: Delete Features and Attachements

kapalczynski — Tue, 19 Dec 2023 17:37:01 GMT

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

Re: Delete Features and Attachements

kapalczynski — Tue, 19 Dec 2023 17:39:07 GMT

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.

Re: Delete Features and Attachements

AlfredBaldenweck — Tue, 19 Dec 2023 17:50:46 GMT

Why not just delete or overwrite the feature class/attachment table in the enterprise gdb? If you're willing to truncate it, I don't imagine it matters if you keep the original or not.

Exporting the data from AGOL is really easy, and as far as I recall, it should bring over all the attachments for you.

Re: Delete Features and Attachements

kapalczynski — Tue, 19 Dec 2023 17:57:37 GMT

Is the image from AGOL? I thought you could not preserve the GLOBALID when you export out of AGOL

Re: Delete Features and Attachements

RhettZufelt — Thu, 28 Dec 2023 20:43:16 GMT

Yes, at least with python 3, if you set the maintain attachments and preserve global id's environment variable, then the attachments will be appended with the features (as long as they are enabled on the fc also) and will retain the existing Global ID's.

I use this all the time. I published my SDE data to AGOL as hosted feature layer, have lots of editing on the AGOL version, run a script that looks at the Global ID's in my SDE data, and the AGOL data. Anything that is in the HFS, but not the SDE gets appended to the SDE so that I have a backup copy of the data, attachments and all (and, of course, one that responds much faster than any AGOL data).

This, does NOT, however, work the other way. Seems there is no 'simple' way to copy data from SDE to AGOL with the attachments.

Re: Delete Features and Attachements

AlfredBaldenweck — Thu, 28 Dec 2023 20:45:18 GMT

I guess the bigger question for this workflow is: Why not share it as a service from the enterprise GDB in the first place, rather than hosting it?

Re: Delete Features and Attachements

RhettZufelt — Thu, 28 Dec 2023 21:01:34 GMT

In my case, we don't have portal as of yet. Our 10.6.1 and 10.8.1 server, will not allow you to edit feature service without opening up to the world (and don't want public to be able to truncate/alter our data). we are using Window authentication, and ESRI tech support still can't figure out how to secure a feature service on our system.

Another big reason is for display/interaction with the data. At this point, it I want to have my images (attachments) show in the popup in web app/ex, either need to have Portal or AGOL, as they have limited the popup config with MapServices to only allow list view.

Users are used to seeing the image(s) in the popup itself without having to scroll down, click a link, open image in separate window. Among other things, but these two (mainly the first one) are work stoppers.