Append New Records

Question

I would like to append records from a view to a table to serve as a log. I tried using the ArcGIS Append tool but it creates duplicate records. Is there a way to append only those records from the view that do not already exist in the table?

I'm looking for a way to log every time a checkout replica is created. I created a view that lists all the replicas and their creation date. The fields in the view include: "ReplicaName", "ReplicaVersion", "CreationDate". I want to append new records from the view to the table.

Answer 1

All table comparisons should be done using dictionaries and cursors. Load the table that has old records into a dictionary using a searchcursor making the key a tuple of the field values of the record. Then create an updatecursor for that table. Use another searchcursor to read through the table with new records and determine if they do not match your dictionary keys. If they don't, insert them into the table.

I don't have exact code for this problem, but the Geonet discussion below has many similarities to this problem and shows many of the coding structures you would need to adapt to your problem.

https://geonet.esri.com/thread/119381