For each .LYRX in a folder, if 0 rows returned, send email

Question

What would it take to do the following in a Python script? (script to be run weekly on a server as a Windows scheduled task)

* For each .LYRX layer file in a network folder* The layer file is based on an Oracle EGDB query layer that has a WHERE clause.

* If the query layer returns any rows in the attribute table
* Then send an email to me with the details.
For example:* Subject: Issues found in OutOfDateConstructionProjects.LYRX
* Body: Records were found in the OutOfDateConstructionProjects.LYRX query. Please investigate.

The assumption being my IT department will be able to set up SMTP.
ArcGIS Pro 3.1. ArcGIS Notebook Server is not an option.

I’m inexperienced with Python. So any help would be appreciated.

Anonymous User · Answer

I keep a list of mine in an .ini file (fancy txt file really) as fc | email distro list since we have different people to email based on the dataset.

anx_no | email one, email two, email three, email fouranx_on | email one, email two, email three

import arcpy
import smtplib
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText

iniFile = 'editNotifications.ini'
fclist = [line.rstrip('
') for line in open(iniFile)]

for l in fclist:
    fc_con = fr'path to lyrx maybe\{l.split(" | ")[0]}'

if int(arcpy.GetCount_management(fc_con).getOutput(0)) > 0:

# Create the body of the message (a plain-text and an HTML version).
        disclaim = "so they know its auto generated.
"
        # formatting lines
        text = "

" + f'{fc_con.split(".")[-1]} has {arcpy.GetCount_management(fc_con).getOutput(0)}'

# Create the root message and fill in the from, to, and subject headers
        msg = MIMEMultipart('related')

msg['From'] = 'spoofer@mydomain.gov'
        msg['To'] = ','.join([x.rstrip() for x in l.split(' | ')[1].split(', ')])
        msg['Subject'] = f'{l.split(" | ")[0]} has edits'

msgText = MIMEText(str(disclaim + text), 'plain')

# Send the email
        smtp = smtplib.SMTP('smtp.domain.gov')

smtp.send_message(msg, msg['From'], msg['To'])
        smtp.quit()

else:
        print('yuppers')

Kara_Shindle · Answer

I do something like that.  Below is a simple code I use to read a list of features (unique identifier is used) from a CSV and then do something with them (in this case, it just creates a selection).

import csv
import os
import arcpy

workspace = '[FILE PATH]'
selList = "selection.csv"

#opens up my csv
csvRead = open(os.path.join(workspace, selList), 'r') 
with csvRead as r:
# creates a list
	csvList = []
	reader = csv.reader(r, delimiter = ',')'
#reads the rows in the CSV from column A
#for every row in Col A, it adds the value to a list selecting only certain characters
	for row in reader:
		UPI = row[0]
		clippedUPI = UPI[0:23]
		csvList.append(clippedUPI)
#this part does something with my list of values, in this case adding it to #an existing selection
for x in csvList:
	selection = '"Name" = ' + "'" + x + "'"
	arcpy.SelectLayerByAttribute_management(r"Parcel Fabric\Parcels", "ADD_TO_SELECTION", selection)
print("Selection Completed")
del selList, csvRead

Bud · Answer

For my notes, the requirements in the original post are over-simplified -- just to keep things simple for a first attempt at the script. Ultimately, I think I'd need a table (CSV?) in the network folder that would store information like:

* DISTRIBUTION_LIST: jdoe@domain.com, jsmith@domain.com, jbrown@domain.com
* And possibly other columns:* DESCRIPTION
* MESSAGE
* EMAIL_SCHEDULE
* COMMENTS
* .LYRX layer file path/name

So eventually, the Python script would need to loop through the table and read the values.