Hello,
We are trying to create a tool that iterates through a list of commonly edited feature classes in our SDE and based on the field LAST_EDITOR and LAST_UPDATE, it should export the records that have been edited within a version in the last 7 days. We have got the process down to do single feature exports but we would like to have an end product in python that we can have windows scheduler run weekly prior to our reconcile and post process. The problem I am having is in model builder, I am not sure if my 'Iterate Multivalue' iterator is actually running through each time. We are also going to have a problem with the output name of the file geodatabase we're running the feature class backups to after one time running through will have the same name and thus will most likely error out. We thought of adding a timestamp to the export name everytime it's ran. After a session with an ESRI analyst on the phone we figured out that the modelbuilder tool must be ran through ArcGIS as when the expression is applied it can only be exported to a feature layer first, then to a feature class. The python script is attached to this post. Any help here would be GREATLY appreciated.
Thank you,
Brett Rosso
GIS Mapping Technician
City of Longmont, Colorado
[ATTACH=CONFIG]26307[/ATTACH]