Updating Feature Class Information from Excel

195
2
03-04-2024 10:06 AM
Labels (1)
kcole
by
New Contributor

I am creating a python script to update a feature class monthly from excel spreadsheet information. I have already worked out how to delete records that are no longer active as well as geocode and add new records, but I am also wanting to update any information that has changed without having to geocode it all again. I know the easiest way would be to just drop all the information and geocode and republish, but that will consume a lot of credits.

I have looked at a few different options like UpdateCursor or merging and dropping fields, but I have not gotten them to work. Does anyone have a better idea on how I could go about this?

0 Kudos
2 Replies
SeaRM
by
New Contributor III

XTools Pro Edit in Excel tool can do this.

https://xtools.pro/en/features/table-tools/edit-in-excel/

0 Kudos
kcole
by
New Contributor

I was hoping to have it be a standalone python script rather than having to use more tools. Thank you though!

0 Kudos