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

6741
18
05-04-2010 02:38 PM
SharonMitchell
New Contributor
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?
0 Kudos
18 Replies
SharonMitchell
New Contributor
Editor Tracking worked perfectly. Thank you!
0 Kudos
RicFritz
New Contributor
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
0 Kudos
BrianZwilling
New Contributor
Is anybody aware of any arcgis 10 updates for editor tracking?
0 Kudos
JeffLedbetter
New Contributor II
I'll add my voice to the chorus of people looking for version 10 updates to either EditorID or Editor Tracking!
0 Kudos
luiscorea
New Contributor
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.
0 Kudos
Lake_Worth_BeachAdmin
Occasional Contributor III

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

0 Kudos
DerekLaw
Esri Esteemed Contributor
All,

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

Hold on Date and User when Editing

Hope this helps,
0 Kudos
nicogis
MVP Frequent Contributor
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.
0 Kudos