topic Re: Schedule an Arcade Expression to run each day at a specified time using Python in Python Questions

Schedule an Arcade Expression to run each day at a specified time using Python

AlenO_Farrell — Fri, 18 Dec 2020 17:26:19 GMT

Hi, I am Calculating a Field with an Arcade Expression which compares the date in a given field with today’s date and provides a result in months. The result is calculated in to an existing field “Months at Current Stage”. I can run the Arcade Expression manually but I would like to automate this in Python. Is this possible in ArcGIS online Notebook using Python? New to Python, so any help would be appreciated!

Re: Schedule an Arcade Expression to run each day at a specified time using Python

JoeBorgione — Fri, 18 Dec 2020 17:48:41 GMT

Mixing metaphors; Arcade and Python. I suggest just doing it all in python and run the script as scheduled task or as you suggest a notebook.

Re: Schedule an Arcade Expression to run each day at a specified time using Python

AlenO_Farrell — Mon, 21 Dec 2020 10:51:26 GMT

Joe,

Thanks for the response to my question. I gather from your reply that this would be possible in Python which is great.

While I have the following, very simple, Arcade Expression, my difficulty is how to write a Python script that would achieve the same result.

var startDate = Date($feature.Start_Date_of_Current_Stage); var endDate = Date(Now()); var MACS = DateDiff(endDate, startDate, 'months'); return MACS;

I am completely new to Python and this will be my first Python script, so I appreciate the help.

Alen

Re: Schedule an Arcade Expression to run each day at a specified time using Python

JoeBorgione — Mon, 21 Dec 2020 15:28:42 GMT

You'll need to get familiar with the datetime module in python. Here are a couple of links to point you in the right direction:

https://www.kite.com/python/answers/how-to-get-the-number-of-months-between-two-dates-in-python

https://gist.github.com/amalgjose/c767a4846d6ecaa3b6d7

Re: Schedule an Arcade Expression to run each day at a specified time using Python

AlenO_Farrell — Mon, 21 Dec 2020 16:53:51 GMT

Thanks Joe,

Much appreciated. I will post my progress in the new year.