AnsweredAssumed Answered

Update or delete only certain rows using CSV file

Question asked by danielkmog on Jan 21, 2015
Latest reply on Jan 26, 2015 by rzufelt

I’m trying to create a Python script that runs after hours to update a standalone GIS table (SDE MSSQL). Currently all of the rows are deleted and an updated CSV file is appended to the GIS table, basically a wipe and replace. That will no longer be an option because we’re only exporting out the current year, so prior years must remain in the GIS table. Is it possible to append new and either update or delete existing rows within the GIS table using the CSV, if so could someone provide some guidance?

 

I have a ticket number field that can be used as a reference between the GIS and the export.

 

Thank you,

Daniel

Outcomes