can an import be automated?

Question

I have a spreadsheet to table operation that will need to be done daily. Is there a way to create an automation? I am hoping that the joins will still remain intact. It is a weather update that will affect how settings will be set for sensitivity.

I would need ArcPRO, to retrieve the Spreadsheet from a shared folder online, replace the current sheet.. then if possible, export a Layout(s) to the same shared folder.

The Spreadsheet will have the same name each day...

The layout will show geographically how each area is expected to be affected. Because it is weather, those setting will change from the predicted forecast based on variation in actual weather.

RudraniChakraborty · Answer

You may also refer:

Automation with ArcGIS Pro

https://architecture.arcgis.com/en/framework/architecture-pillars/automation/automation-with-arcgis-pro.html

This can also be achieved through Model Builder

https://pro.arcgis.com/en/pro-app/latest/help/analysis/geoprocessing/modelbuilder/what-is-modelbuilder-.htm

BobBooth1 · Answer

This tutorial may get you part way there:

https://learn.arcgis.com/en/projects/schedule-automated-near-real-time-data-updates/

This one may help too:

https://learn.arcgis.com/en/projects/automate-a-geoprocessing-workflow-with-python/

You can use the arcpy module to interact with an ArcGIS Pro project, export layers.

https://pro.arcgis.com/en/pro-app/3.4/arcpy/mapping/introduction-to-arcpy-mp.htm

DavidSolari · Answer

If you're able to turn your process into a model or script tool, you can look at the Scheduled Tools documentation to get it running whenever you want. Pay attention to all the notes about licensing and keep an eye on your logs, it's easy for Pro to lose a license and grind your tasks to a halt.