nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

name 'cursor' not defined error

Anonymous User

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.

<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> datetime<SPAN class="punctuation token">,</SPAN> smtplib
<SPAN class="keyword token">from</SPAN> arcgis <SPAN class="keyword token">import</SPAN> GIS
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

<SPAN class="comment token">#Location of ArcPro project with AGOL layer added into map content</SPAN>
prjPath <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Python\UtilityEncroachment_Active\Update\Update.aprx'</SPAN>

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

<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Email notifications sent."</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

タグ付けされた投稿をもっと見る

Accepted answers

RandyBurton

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.

<SPAN class="string token">"Date_Approved = {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>tdy<SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># or</SPAN>
<SPAN class="string token">"Date_Approved = '{}'"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>tdy<SPAN class="punctuation token">)</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

RandyBurton

<SPAN class="string token">"Date_Approved = {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>tdy<SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># or</SPAN>
<SPAN class="string token">"Date_Approved = '{}'"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>tdy<SPAN class="punctuation token">)</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Anonymous User

I made the adjustment and now receive the following error

line 24 is referencing 'for row in cursor:'

RandyBurton

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]".

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

Anonymous User

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 = "xyz"
        FROM = "xyz"
        TO = "Applicant <{}>".format(cursor[1])
        CC = "xyz"
        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.")
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Anonymous User

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.

JoeBorgione

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.....

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.