Select to view content in your preferred language

Is there a way to do a Bulk Attribute Update and avoid updating the LastEdited Editor Tracking Information?

506
10
08-21-2024 05:09 AM
ShareUser
Esri Community Manager

This may be a bit of a silly ask, but I have a few Survey123 layers that we grab the information from to update our work management database. We are in the process of updating our approach, and I needed to add a field to flag rows that had already been entered. This means I have to update all of the existing data to flag them as already uploaded, which would overwrite the editor tracking information.

Is there a process to bulk update like this that can avoid changing the editor tracking information? This could be useful in a few different contexts for administrating datasets I feel like. I understand why this isn't preferred, but also it can remove the 'meaningful' editor tracking information in some cases.

10 Replies
ShareUser
Esri Community Manager

Hello Robert - I hope all is fine with *you*!
The idea I’d try is opening the layer in Pro; select the rows to update (I’d try on 2 or 5 at first!), then edit (or calculate field).

I’m also interested in additional ideas that you get, especially for only-AGO techniques. 
All the best - Dave 

ShareUser
Esri Community Manager

Oh hello stranger! All is good with me, just working away with everything I learned, I gotta get back out there to visit sometime soon!

I'm definitely thinking I will do the update in Pro as it is a way easier process, but in Pro the Editor tracking does update when you edit or calculate field I'm curious if there is a way to avoid that because I want to save the previous editor tracking information, not my bulk edit.

Finding ways to edit in bulk like this in AGO specifically would be cool as well!

0 Kudos
Bud
by
Esteemed Contributor

I don't have experience with AGOL. But I'll ask a couple of uneducated questions anyway:

  1. Could you temporarily disable editor tracking while batch populating the field?
  2. Or could you store this information in a related table that does not have editor tracking enabled?


For anyone who's using an enterprise geodatabase, not ArcGIS Online, this related question might be of interest: ApplyEdits without firing immediate attribute rules and editor tracking, is it possible?

RobertAnderson3
MVP Regular Contributor

I assume I could temporarily turn off the editor tracking, though I can't remember if that removes/resets that field anyways, I'll have to look or try on a test layer.

The related tables and the main layer share the editor tracking settings so I don't think this will work.

That other post could be handy for the near future when we move to Enterprise, though our Survey123 stuff is going to remain in AGOL.

Marisa_Kordecki
Occasional Contributor

I have the same question for my hosted layer. As the GIS staff fixing data that is collected in survey123 by field workers I would really prefer to keep myself from overwriting them as the last editor when I have to calculate a field for the entire layer. 

Bud
by
Esteemed Contributor

Are you able to temporarily disable editor tracking to perform your field calculation?

0 Kudos
Marisa_Kordecki
Occasional Contributor

I haven't tested out that option, but I have considered testing it out soon. It's not my ideal solution as the inspectors make edits to the data anytime over their work day and work week, meaning that turning it off would stop tracking of anything they happened to edit during that same time. 

0 Kudos
RobertAnderson3
MVP Regular Contributor

For what it's worth, I tried doing this with a test layer and it didn't seem to cause any issues turning the tracking off and back on.

That said, I don't know if because it's a Survey123 layer if it will cause unforeseen headaches.

I am going to attempt this with my data shortly, after the crews are all done for the day, just in case it messes something up.

Bud
by
Esteemed Contributor

@RobertAnderson3 Would there be a benefit in sharing your backup strategy here so that others can see it? Backing up the data in case something goes wrong...

0 Kudos