Send Alert EMails

Question

Just brainstorming right.  Looking for some sort of solution to Alert (email) individuals when my collected data meets certain criteria.  If some collected feature in a MapService or SDE FC is set to Yes or No, or some other specific value I want to grab that individual record(s) and email it to a few individuals.

Has anyone done this?  Thanks

blake.terhune · Answer

Here's the basic template we use for scheduled task scripts. It includes a lot more than just sending an email but I wanted to show it in context. I have some tweaks planned but this basic structure has served us well for years. We also log the success or failure to a table in SDE so we can report on everything but I left the logging part out. """Brief description of script here. More detailed description of script, dependencies, and purpose. Followed by a change log. """ # Required modules import arcpy import datetime from email.mime.multipart import MIMEMultipart ## Build email parts from email.mime.text import MIMEText ## Record email body type import os import smtplib ## Send email message from socket import gethostname def main(): # Connection variables ## SDE Connections sde_sdeconn = r"C:\GISConnections\SDE@GTEST.sde" gisviewer_sdeconn = r"C:\GISConnections\GISVIEWER@GTEST.sde" ## Network drive locations mytemp_gdb = r"\mynas\BlakeT\Work\Temp.gdb" # Email variables addr_from = "PythonScript@mydomain.com" addr_to = ["someone@mydomain.com", "anotherperson@mydomain.com"] addr_cc = [] addr_bcc = [] ## BCC is not used in the MIMEMultipart message but will be sent with SMTP recipients = addr_to+addr_cc+addr_bcc ## Create email message container and set message parts msg_root = MIMEMultipart('alternative') msg_root['From'] = addr_from msg_root['To'] = ", ".join(addr_to) msg_root['Cc'] = ", ".join(addr_cc) msg_root['Subject'] = os.path.basename(__file__) # Opening lines of email message body msg = "{scriptName} (TaskID {tID}) ran on {hostComputer}".format( scriptName = os.path.basename(__file__), tID = taskID, hostComputer = gethostname() ) istring = " Started {} ".format(datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")) msg += " {:~^64} ".format(istring) try: arcpy.env.overwriteOutput = True ## Optional """---------------- Main script processing code here ----------------""" # Get workspace factory ## This is the style for a secondary or inline comment msg += "Get workspace factory" msg += " Start {} ".format(datetime.datetime.now().strftime("%H:%M:%S")) print(arcpy.Describe(mytemp_gdb).workspaceFactoryProgID) if arcpy.GetMessages(1): ## Write arcpy warning message msg += arcpy.GetMessages(1) msg += "Finish {} ".format(datetime.datetime.now().strftime("%H:%M:%S")) """------------------------------------------------------------------""" # Complete email message with success ## Add closing line to email message istring = " Finished {} ".format(datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")) msg += "{:~^64} ".format(istring) except Exception as err: # Complete email message with error ## (sometimes the error has nothing in the .message property) if err.message and err.message in arcpy.GetMessages(2): ## All of the messages returned by the last ArcPy tool displayErr = " {}".format(arcpy.GetMessages()) else: ## Non-ArcPy error message displayErr = "{} ({})".format( unicode(err).encode("utf-8"), datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S") ) msg += displayErr finally: # Cleanup arcpy.ClearWorkspaceCache_management() ## Use if connecting to SDE # Close and send the email msg_body = MIMEText(msg, 'plain') ## Record the MIME type of email message body as plain text msg_root.attach(msg_body) ## Attach msg_body content to msg_root container s = smtplib.SMTP('COCMAIL01.CI.CHANDLER.AZ.US') s.set_debuglevel(1) ## Print smtp debug info in Python interpreter (optional) s.sendmail(addr_from, recipients, msg_root.as_string()) s.quit() # Script start if __name__ == '__main__': main()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ In reference to your question about monitoring data for certain criteria, you could schedule this script as a task in Windows for whatever interval you need. The script could check for your conditions and only send the email if the conditions are met.

DarrenWiens2 · Answer

It might help to describe where you are stuck, and go from there. Have you started?

For sending email, I'd start here: 18.1.11. email: Examples — Python 2.7.12 documentation