topic Re: Using a Search Cursor to Update Map Text - Not getting all info in Python Questions

Using a Search Cursor to Update Map Text - Not getting all info

RachelAlbritton — Sat, 11 Dec 2021 07:34:39 GMT

I've written a python script that reads data from a related table and writes those field values into a text box within ArcMap. The script runs OK when I tell it to print to the command window (all fields are printed), but in the map instead of entering to the new line of text, it appears to be writing over itself. How can I stop this a get it to write in all this info?

import arcpy, os, traceback

mxd = arcpy.mapping.MapDocument(r"\\ad.utah.edu\sys\FM\gis\ags_directories\DDC_Web\Template.mxd")
StopsTable = r"\\csi-files\\fm\\gis\\ags_10_3\\ags_content\\sde_connection_files\\fm-agsDataReader@fm-gisdbtest0.fm.utah.edu.sde\\UUSD.DBO.DDC\\UUSD.DBO.DDC_Stops"

for elm in arcpy.mapping.ListLayoutElements(mxd,"TEXT_ELEMENT"):
    
    sc = arcpy.SearchCursor(StopsTable)
    for row in sc:
        if elm.name == "Report":
            print "Stops "+str(row.Stop_Number)+": "+row.Stop_Status+"\n"
            elm.text = "Stops "+str(row.Stop_Number)+": "+row.Stop_Status+"\n"

Python Shell Print Screen (to show me the script is doing what I want it to)

Final MXD after Script runs:

Re: Using a Search Cursor to Update Map Text - Not getting all info

DarrenWiens2 — Sat, 11 Dec 2021 07:34:42 GMT

Store the growing string in a variable, then write it to the element.

Untested:

my_string = ""
for row in sc:  
        if elm.name == "Report":  
            print "Stops "+str(row.Stop_Number)+": "+row.Stop_Status+"\n"  
            my_string += "Stops "+str(row.Stop_Number)+": "+row.Stop_Status+"\n" 
elm.text = my_string

Re: Using a Search Cursor to Update Map Text - Not getting all info

RachelAlbritton — Wed, 20 Jan 2016 19:06:29 GMT

great Idea, but I got the same results.

I've figured out that I can make each stop its own text box and that works - tedious though:

for elm in arcpy.mapping.ListLayoutElements(mxd,"TEXT_ELEMENT"):

sc = arcpy.SearchCursor(StopsTable)

for row in sc:

if elm.name == "Stop2" and row.Stop_Number == 2:

elm.text = "Stop "+str(row.Stop_Number)+": "+row.Stop_Status

elif elm.name == "Stop3" and row.Stop_Number == 3:

elm.text = "Stop "+str(row.Stop_Number)+": "+row.Stop_Statusy_string = "" for row in sc: if elm.name == "Report": print "Stops "+str(row.Stop_Number)+": "+row.Stop_Status+"\n" my_string += "Stops "+str(row.Stop_Number)+": "+row.Stop_Status+"\n" elm.text = my_strin

Re: Using a Search Cursor to Update Map Text - Not getting all info

JakeSkinner — Sat, 11 Dec 2021 07:34:44 GMT

Hi Rachel,

Each time you iterate through the table you are overwriting the text element. So the last row is always displayed. You will need to append the element's text each time. Ex:

for elm in arcpy.mapping.ListLayoutElements(mxd,"TEXT_ELEMENT"): 
        with arcpy.da.SearchCursor(StopsTable, ["Stop_Number", "Stop_Status"]) as cursor:
            for row in cursor:
                if elm.name == "Report": 
                    elm.text = elm.text + "Stops "+str(row[0])+": "+row[1] +"\n"

Note: I used the arcpy.da.SearchCursor in the above example.

Re: Using a Search Cursor to Update Map Text - Not getting all info

JimmyKroon — Wed, 20 Jan 2016 19:23:19 GMT

The problem is that line 12 overwrites elm.text during each cycle of the loop. You need to append the new text to the previous values without overwriting.

I would have thought changing = to += would work, but if not, try the append() string function.

mystring.append(new text to add)

Re: Using a Search Cursor to Update Map Text - Not getting all info

RachelAlbritton — Wed, 20 Jan 2016 19:25:28 GMT

Thanks Jake - That's what I needed. So my only issue is now, this will always add to whatever existing text is already in the text box. Each time I run the script I need the existing info to be deleted and the new info written in. Any suggestions?

Re: Using a Search Cursor to Update Map Text - Not getting all info

JakeSkinner — Sat, 11 Dec 2021 07:34:47 GMT

You could do something along the following:

firstTime = True

with arcpy.da.SearchCursor(StopsTable, ["Stop_Number", "Stop_Status"]) as cursor:
    for row in cursor:
        for elm in arcpy.mapping.ListLayoutElements(mxd,"TEXT_ELEMENT"):
            if elm.name == "Report":
                if firstTime:
                    elm.text = "Stops "+str(row[0])+": "+row[1] +"\n"
                    firstTime = False
                else:                                    
                    elm.text = elm.text + "Stops "+str(row[0])+": "+row[1] +"\n"

arcpy.RefreshActiveView()

Re: Using a Search Cursor to Update Map Text - Not getting all info

JimmyKroon — Wed, 20 Jan 2016 19:58:11 GMT

Find the text element first, set it's value to nothing, then search and append the report values.

for elm in arcpy.mapping.ListLayoutElements(mxd,"TEXT_ELEMENT"😞

if elm.name == "Report":

elm.text = ""

with arcpy.da.SearchCursor(StopsTable, ["Stop_Number", "Stop_Status"]) as cursor:

for row in cursor:

elm.text = elm.text + "Stops "+str(row[0])+": "+row[1] +"\n"

Re: Using a Search Cursor to Update Map Text - Not getting all info

RachelAlbritton — Wed, 20 Jan 2016 20:12:41 GMT

Yeah, I thought that would work as well, but unfortunately it doesn't...not sure why

I decided to clone the text box, and write the report to the clone. Then the clone can be deleted at the beginning of the script when it ran and a new clone will be created to write to.