Automatecally update data in ArcGis when I update the excel sheet?

365
4
03-07-2021 08:19 AM
CharfeldineMahammedi
New Contributor

Hello, I am wondering if there is any option to automatecally update data in ArcGis when I update the excel sheet? 

Your help is appreciated. Thanks

0 Kudos
4 Replies
DavidPike
MVP Frequent Contributor

If you can link the feature class to the excel table/spreadsheet by a common field (e.g. the spreadsheet values referencing a matching ObjectID in the feature class), a Join might be a good option.  Add Join (Data Management)—ArcGIS Pro | Documentation

edit - not an AGOL solution

CharfeldineMahammedi
New Contributor

Thank you for your help

0 Kudos
jcarlson
MVP Notable Contributor

I'm assuming you mean in a hosted web layer? If that's the case, there's no way to do it "automatically", but there are ways to make it easier.

Published Standalone File

jcarlson_0-1615141171171.png

 

If your layer is published from a standalone excel file, as in the image above, you can choose to Append to the layer by re-uploading the same file. You can also overwrite the entire file, but if your source data has a unique identifier field, the Append option can be used to maintain existing features.

jcarlson_1-1615141325039.png

jcarlson_2-1615141404113.png

Slightly Easier Alternative: Cloud Drive

If you have the option, consider adding your data from a cloud drive, such as Google Drive or Microsoft OneDrive. The adding process works the same as when adding from a standalone layer. The key difference here is that the update process just looks for that same file in your cloud drive, and you don't have to maintain an offline copy.

jcarlson_3-1615141717150.png

 

This method is great if you're collaborating with other users on the data, or want to take advantage of the built-in versioning and sharing options of the cloud drive of your choice.

The "Automatically" Part

Finally, whichever option you choose, you can use the Python API to schedule a script which runs the append or overwrite function at regular intervals, thus making the hosted layer as close to a "live" copy of the Excel sheet as is feasible.

- Josh Carlson
Kendall County GIS
0 Kudos
CharfeldineMahammedi
New Contributor

Thank you for your help.

 

0 Kudos