Automate loading a table into SDE

Question

How can I automatically load a table stored on a network share into SDE when the original table is edited?

Environment is ESRI 10.1 ArcSDE on SQL Server. Preference for python or existing GP tools. Table would be a csv or xlsx.

Any ideas, info, or pointers would be helpful.

• travis: I know it isn't the question you asked, by why don't you just stop people from updating the table? SQL Server has a security for just that reason.

Answer 1

This could be implemented as a multiple steps process:

1. You could run a Python script that would evaluate a .csv or .xls file and compare it to the latest modified version you have loaded into an SDE geodatabase.

2. If there any changes found, then you would convert the source file into a table by using Table to Table (csv) or Excel to Table (since 10.2 only) (xls) GP tools (both of them of course available from Python too via arcpy site package). The output data could be stored in_memory or as an intermediate data somewhere on the disk.

3. You run Truncate Table GP tool on the SDE geodatabase table and then Append to move the created earlier table rows into an existing table.