topic Re: name 'cursor' not defined error in Python Questions

name 'cursor' not defined error

Anonymous User — Sat, 11 Dec 2021 08:34:29 GMT

I'm trying to run this script which searches for approval dates with the current date and sends out emailed alerts to each customer. I keep getting an error when running 'name cursor' is not defined.

import arcpy, datetime, smtplib
from arcgis import GIS
arcpy.env.overwriteOutput = True

#Location of ArcPro project with AGOL layer added into map content
prjPath = r'C:\Python\UtilityEncroachment_Active\Update\Update.aprx'

#Create layer object of service being updated.
proj = arcpy.mp.ArcGISProject(prjPath)
map = proj.listMaps()[0]
layer = map.listLayers()[0]
field = ['Date_Approved', 'Email', 'Applicant']
today = datetime.datetime.today()
tdy = datetime.datetime.strftime(today, '%Y-%m-%d')
        
with arcpy.da.SearchCursor(layer, field, "Date_Approved = {}".format(tdy)) as email_cursor:
    for row in cursor:
        print ("Match Found!")
        SERVER = "xxxxxxxxxxxxx"
        FROM = "xxxxx@xxxxxx.com"
        TO = "Applicant <{}>".format(row[1])
        CC = "xxxxxxxxxxxxx"
        SUBJECT = "Utility Encroachment Approach Approved"
        MSG = "\n {},\n".format(row[2]) + "        " + "This is to notify you that your utility encroachment has been approved. Please use the following link to view additional details www. .com"
        TEXT = (MSG)   
        MESSAGE = 'Subject: {}\n\n{}'.format(SUBJECT, TEXT)
        server = smtplib.SMTP(SERVER)
        server.sendmail(FROM, [TO]+[CC], MESSAGE)
        
server.quit()

print ("Email notifications sent.")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: name 'cursor' not defined error

JoeBorgione — Fri, 22 Feb 2019 22:43:02 GMT

Line 17 is your problem: you create a search cursor object on line 16 calling it

email_cursor

Either change line 17 to refer to email_cursor or change line 16 to cursor.....

Re: name 'cursor' not defined error

Anonymous User — Fri, 22 Feb 2019 23:09:43 GMT

I get the following error when I make that change. The script works if I delete line 17 but then I can't have the email populate each customers name and email address.

Re: name 'cursor' not defined error

Anonymous User — Sat, 11 Dec 2021 08:34:31 GMT

My current script is below along with the new error I'm receiving

import arcpy, datetime, smtplib
from arcgis import GIS
arcpy.env.overwriteOutput = True

#Location of ArcPro project with AGOL layer added into map content
prjPath = r'C:\Python\UtilityEncroachment_Active\Update\Update.aprx'

#Create layer object of service being updated.
proj = arcpy.mp.ArcGISProject(prjPath)
map = proj.listMaps()[0]
layer = map.listLayers()[0]
field = ['Date_Approved', 'Email', 'Applicant']
today = datetime.datetime.today()
tdy = datetime.datetime.strftime(today, '%Y-%m-%d')

with arcpy.da.SearchCursor(layer, field, "Date_Approved = {}".format(tdy)) as cursor:
        print ("Match Found!")
        SERVER = "xxxxxxxxxxx"
        FROM = "xxxxxxxxxxx"
        TO = "Applicant <{}>".format(cursor[1])
        CC = "xxxxxxxxxxxxxx"
        SUBJECT = "Utility Encroachment Approach Approved"
        MSG = "\n {},\n".format(cursor[2]) + "        " + "This is to notify you that your utility encroachment has been approved. Please use the following link to view additional details www. .com"
        TEXT = (MSG)   
        MESSAGE = 'Subject: {}\n\n{}'.format(SUBJECT, TEXT)
        server = smtplib.SMTP(SERVER)
        server.sendmail(FROM, [TO]+[CC], MESSAGE)
        
server.quit()

print ("Email notifications sent.")
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: name 'cursor' not defined error

RandyBurton — Sat, 11 Dec 2021 08:34:34 GMT

In your second script you dropped "for row in cursor:" (line 17 in first script). Then you need to change back lines 20 and 23 to "row[1]" and "row[2]".

with arcpy.da.SearchCursor(layer, field, "Date_Approved = {}".format(tdy)) as cursor:
    for row in cursor:
        print ("Match Found!")
        SERVER = "xxxxxxxxxxx"
        FROM = "xxxxxxxxxxx"
        TO = "Applicant <{}>".format(row[1])
        CC = "xxxxxxxxxxxxxx"
        SUBJECT = "Utility Encroachment Approach Approved"
        MSG = "\n {},\n".format(row[2]) + "        " + "This is to notify you that your utility encroachment has been approved. Please use the following link to view additional details www. .com"
        TEXT = (MSG)   
        MESSAGE = 'Subject: {}\n\n{}'.format(SUBJECT, TEXT)
        server = smtplib.SMTP(SERVER)
        server.sendmail(FROM, [TO]+[CC], MESSAGE)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: name 'cursor' not defined error

Anonymous User — Sat, 23 Feb 2019 00:02:28 GMT

I made the adjustment and now receive the following error

line 24 is referencing 'for row in cursor:'

Re: name 'cursor' not defined error

RandyBurton — Sat, 11 Dec 2021 08:34:37 GMT

The error also indicates line 24, but I would expect it to be around 17. Your other scripts have 31 and 32 lines. Did something else get added? You might try the first script you posted with just the change "email_cursor" to "cursor" in line 16. The only other issue I see at this time could be the where clause in that same line. The date may need to be in single quotes, but that depends on your database/server.

"Date_Approved = {}".format(tdy)
# or
"Date_Approved = '{}'".format(tdy)‍‍‍‍