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

How do you automatically timestamp new and edited records in an SDE feature class?

SharonMitchell

I would like to make it so that as a feature class is edited the "modifiedDate" and "user" fields will be updated automatically. Is there a way to do this?

Find more posts tagged with

Accepted answers

All comments

DerekLaw

Hi there,

These ArcScripts might be helpful:

1. EditorID 1.8.2 - Allows you to track who edits the features in your geodatabase, and at what time they were last edited.

2. Editor Tracking - This ArcMap extension enables feature classes and tables to track user edits at the feature/record level.

Hope this helps,

SharonMitchell

Editor Tracking worked perfectly. Thank you!

RicFritz

Has anyone updated the EditorID application to run in Windows 7?

Thank You,

Ric Fritz, GISP
GIS Technology Manager
Citrus County Property Appraiser's Office

352-341-6665
rfritz@mail.pa.citrus.fl.us

BrianZwilling

Is anybody aware of any arcgis 10 updates for editor tracking?

JeffLedbetter

I'll add my voice to the chorus of people looking for version 10 updates to either EditorID or Editor Tracking!

luiscorea

So do I. I don't understand why this tool is still not integrated with arcgis using SDE geodatabases. Please is any tool/script available to do the same for 10, that will help me a lot.

DerekLaw

All,

Please see this thread on a similar topic, specifically Craig G's post:

Hold on Date and User when Editing

Hope this helps,

nicogis

you can create a class extension in 10 (10.1 has included this functionality) .
Here you can see Timestamper class extension
http://resources.arcgis.com/en/help/arcobjects-net/conceptualhelp/index.html#//0001000003ps000000

1) compile this solution with vs2010.
2) Register dll with esriregasm
3) open arccatalog and create a feature class
4) select type class 'TimeStamper class'
5) select type of feature class (polygon, point ect)
7) add your fields of feature class
6) in feature class you have a new tab (Timestamp Settings) where you can set field created, filed updated and field user (you can also set 'not used')

For local geodatabases, user is the username as known by the operating system (in a domain\username format). For remote geodatabases, the IDatabaseConnectionInfo interface is utilized.

SrijanaTuladhar

I just enable editor tracking in the feature class, I noticed that in the LAST_EDITED_DATE field, the current time is incorrect (the date is correct though). Did any of you have the same experience? Thanks!

VinceAngelo

Is the system date on your client workstation correct?

- V

SrijanaTuladhar

Yes, we're in the Eastern time, but it records the Pacific time. Also when I query the current timestamp from the oracle database, it shows the correct timestamp. Thanks!

VinceAngelo

In which timezone is your server?

Are you using an application server connection, or Direct Connect?

- V

SrijanaTuladhar

In which timezone is your server?

Are you using an application server connection, or Direct Connect?

- V

Our server is in Eastern time zone. Please see below. We're using an application server connection. Thanks!

-bash-4.1$ date
Fri Oct 26 11:51:56 EDT 2012

VinceAngelo

Do you have the TZ environment variable set explicitly on both the Windows Desktop
host and the database server? Without an explicit TZ, there's a great deal of room
for interpretation.

- V

SrijanaTuladhar

Do you have the TZ environment variable set explicitly on both the Windows Desktop
host and the database server? Without an explicit TZ, there's a great deal of room
for interpretation.

- V

It does not seem like we have TZ enviroment variable set up. Could you tell what we need to set up? Thanks for your help!

VinceAngelo

This is complicated enough that you really need to research it yourself to be sure you know
what happens is what you want to hapen. A google on "tz oracle variable" will get you started.
If you were using Direct Connect I doubt this would be an issue.

- V

MichielStaessen1

Message when enabling editor tracking clearly states that dates are stored in UTC (as they should be!)

Lake_Worth_BeachAdmin

You can use it for SDE databases, my organization does.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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