topic Re: Text Element Questions in Python Questions

Text Element Questions

GeoffOlson — Wed, 14 Aug 2013 18:36:27 GMT

So I've got my text element function working in layout view, but it leaves me with two questions. Can multiple rows be concatenated into the row.getValue or can it only find single fields? Also, is it possible to return all feature records?

Here is the script I'm using to get the first result to fill the text box:

import arcpy  mxd = arcpy.mapping.MapDocument("Current") mapLyr = arcpy.mapping.ListLayers(mxd, "Detail_2013")[0]  concatElem = arcpy.mapping.ListLayoutElements(mxd, "TEXT_ELEMENT", "concat")[0]  rows = arcpy.SearchCursor(mapLyr.dataSource) row = rows.next()  typeElem.text = row.getValue("CONCAT")  mxd.save() del mxd, row, rows,

Any suggestions a much appreciated.

Re: Text Element Questions

MathewCoyle — Sat, 11 Dec 2021 15:27:31 GMT

There are a few ways you could go about it. You can create a string variable and insert as many row values as you want is one way.

Here is an example of taking all values in the 'CONCAT' field.

rows = arcpy.SearchCursor(mapLyr.dataSource)
text_var = str()
for row in rows:
    text_var += '{0}{1}'.format(row.getValue("CONCAT"), os.linesep)

typeElem.text = text_var

Re: Text Element Questions

GeoffOlson — Thu, 15 Aug 2013 11:07:08 GMT

Thanks for the reply. I'm so excited it works! As you can probably tell, I'm very new to scripting. To take that one step further, is it possible to add a second column to the text element after 5 rows of text? I don't expect you to script that, but just if you know it can be done and what functions would be used. I'm looking at using example 2 from the arcpy graphic element section in the help file. Now I'm really excited to work my way through the "Python Scripting for ArcGIS" workbook.

2 Text Elements for results

GeoffOlson — Sat, 11 Dec 2021 15:27:34 GMT

I've thought on this a little more and I think I figured out how to go about this. Right now I've got one text element that the search cursor is listing its results. By adding a second text element in the map layout, can the script start putting "overflow" rows in it? My goal would be to take my current script:

import arcpy

mxd = arcpy.mapping.MapDocument("Current")
mapLyr = arcpy.mapping.ListLayers(mxd, "Detail_2013")[0]

addrElem = arcpy.mapping.ListLayoutElements(mxd, "TEXT_ELEMENT", "concat1")[0]


rows = arcpy.SearchCursor(mapLyr.dataSource)
text_var = str()
for row in rows:
    text_var += '{0}{1}'.format(row.getValue("CONCAT"), os.linesep)

addrElem.text = text_var

mxd.save()
del mxd, row, rows,

and I would like to add a GetCount_management so the total number of records on the map page are returned, then divide that by two and the second half of the records returned would go to "concat2."

I tried using gp.GetCount_management, but the Python windows says it doesn't know what "gp" is. Is it part of the old arcgisscripting since import arcpy doesn't seem to know what it is?

Re: Text Element Questions

T__WayneWhitley — Thu, 15 Aug 2013 15:28:03 GMT

arcpy does recognize it:

arcpy.GetCount_management...

Re: Text Element Questions

GeoffOlson — Thu, 15 Aug 2013 15:31:06 GMT

Thank you, Wayne.

<--Noob.:(

Re: Text Element Questions

T__WayneWhitley — Sat, 11 Dec 2021 15:27:36 GMT

...not really - I'm the noob for having to keep looking up the trick to get the result, as to convert to integer (I think directly a result object is returned), see this where the 'result' variable is the integer conversion:

result = int(arcpy.GetCount_management(lyrfile).getOutput(0))

http://resources.arcgis.com/en/help/main/10.1/index.html#//0017000000n7000000

Tricks!

Enjoy,
Wayne

EDIT-
Maybe this isn't directly relevant, then again maybe it is -- another trick I saw again today (which I had forgotten was available) is interactive help call:

>>> help(arcpy.GetCount_management)
Help on function GetCount in module arcpy.management:
 
GetCount(in_rows=None)
    GetCount_management(in_rows)
    
       Returns the total number of rows for a feature class, table, layer, or raster.
    
    INPUTS:
     in_rows (Table View or Raster Layer):
         The input feature class, table, layer, or raster. If a selection is defined on
         the input, only its rows are returned.
 
>>>

Re: Text Element Questions

GeoffOlson — Sat, 11 Dec 2021 15:27:39 GMT

Haha, yeah I just found that when I couldn't divide my result in half. 🙂

I just added these rows to the script:

rowcount = int(arcpy.GetCount_management("Detail_2013").getOutput(0))
percolumn = round(rowcount / 2.0)

I'm making improvements. 🙂

Now I just need to find out how to split the results.

Re: Text Element Questions

GeoffOlson — Sat, 11 Dec 2021 15:27:42 GMT

So I've tried different ways of limiting the iterations for the text element results and I've made a little bit of progress. I added an if statement to try and control which iterations go to which text element, but it didn't do what it was supposed to. Instead, I just have two copies of the full text elements.

import arcpy, os

mxd = arcpy.mapping.MapDocument("Current")
mapLyr = arcpy.mapping.ListLayers(mxd, "Detail_2013")[0]

concat1Elem = arcpy.mapping.ListLayoutElements(mxd, "TEXT_ELEMENT", "concat1")[0]
concat2Elem = arcpy.mapping.ListLayoutElements(mxd, "TEXT_ELEMENT", "concat2")[0]

rowcount = int(arcpy.GetCount_management("Detail_2013").getOutput(0))
percolumn = round(rowcount / 2.0)


rows = arcpy.SearchCursor(mapLyr.dataSource)



crnum = int()
for crashnum in rows:
    crnum = row.getValue("Crash_Num")

if crnum <= percolumn:
    text_var = str()
    for row in rows:
        text_var += '{0}{1}'.format(row.getValue("CONCAT"), os.linesep)
    concat1Elem.text = text_var
else:
    text_var = str()
    for row in rows:
        text_var += '{0}{1}'.format(row.getValue("CONCAT"), os.linesep)
    concat2Elem.text = text_var

mxd.save()
del mxd, row, rows, crnum,

print "First column should have :" + str(percolumn) + " rows." #used to check that it calculated properly

I tried to use while and where but I couldn't figure out how or where to place those to get the script to run.

Re: Text Element Questions

MathewCoyle — Sat, 11 Dec 2021 15:27:45 GMT

If you want to split the items half between each text element you can add a counter and if statement to your cursor to only do half the rows as defined by your getcount method previously. I'm sure there is a better way of doing this but I just can't think of it right now.

text_var = str()
count = 0
for row in rows:
    if count < percolumn:
        text_var += '{0}{1}'.format(row.getValue("CONCAT"), os.linesep)
        count += 1
    elif count == percolumn:
        concat1Elem.text = text_var
        text_var = str()
    else:
        text_var += '{0}{1}'.format(row.getValue("CONCAT"), os.linesep)
concat2Elem.text = text_var

Re: Text Element Questions

T__WayneWhitley — Sat, 11 Dec 2021 15:27:47 GMT

I'm just thinking maybe the range function would apply here?

Since you know the total count couldn't you just run a loop, branching for the part of each half of the range?

In general, illustrated by:

>>> rowcount = 10
>>> for rows in range(rowcount):
 if rows in range(rowcount/2):
  print 'row ' + str(rows) + ' in range 1.'
 elif rows in range(rowcount/2, rowcount):
  print 'row ' + str(rows) + ' in range 2.'

  
row 0 in range 1.
row 1 in range 1.
row 2 in range 1.
row 3 in range 1.
row 4 in range 1.
row 5 in range 2.
row 6 in range 2.
row 7 in range 2.
row 8 in range 2.
row 9 in range 2.
>>>

Re: Text Element Questions

MathewCoyle — Sat, 11 Dec 2021 15:27:50 GMT

I'm just thinking maybe the range function would apply here?

Yes that's a nice method when you know the number of columns. Would need a slight tweak for odd numbers of rows.

rowcount = 9
for rows in range(rowcount):
    if rows in range(rowcount / 2 + 1):
        print 'row ' + str(rows) + ' in range 1.'
    elif rows in range(rowcount / 2, rowcount):
        print 'row ' + str(rows) + ' in range 2.'

There was also this for a tool that can take a dynamic number of text columns (as long as they are already created and follow the naming/number convention).

import os
import arcpy


def main():

    layer_name = arcpy.GetParameterAsText(0)
    field = arcpy.GetParameterAsText(1)
    number_columns = float(arcpy.GetParameterAsText(2))

    mxd = arcpy.mapping.MapDocument("Current")
    mapLyr = arcpy.mapping.ListLayers(mxd, layer_name)[0]

    rowcount = int(arcpy.GetCount_management(layer_name).getOutput(0))
    percolumn = round(rowcount / number_columns)

    text_var = str()
    item_count = 0
    column_count = 1
    for row in arcpy.SearchCursor(mapLyr.dataSource, sort_fields='{0} A'.format(field)):
        text_var += '{0}{1}'.format(row.getValue(field), os.linesep)
        item_count += 1
        column = 'concat{0}'.format(column_count)
        arcpy.AddMessage(item_count)

        if item_count == percolumn and column_count != number_columns:
            arcpy.AddMessage('next column')
            arcpy.mapping.ListLayoutElements(mxd, "TEXT_ELEMENT", column)[0].text = text_var
            text_var = str()
            column_count += 1
            item_count = 0

    arcpy.mapping.ListLayoutElements(mxd, "TEXT_ELEMENT", column)[0].text = text_var

    arcpy.RefreshActiveView()
    mxd.save()
    del mxd

    arcpy.AddMessage("First column should have : {0} rows.".format(percolumn))  #used to check that it calculated properly

if __name__ == '__main__':
    main()

Re: Text Element Questions

GeoffOlson — Fri, 16 Aug 2013 12:40:38 GMT

Thanks for all the help, guys! I have the if statement almost working. The second column works fine, but the first column is only returning the last result. I have a field that numbers each row in the table, besides the FID, so that way on each map page each row of text is numbered and it matches the label in the map. Instead of using a counter += 1, can an attribute field be used instead? I have the field "Crash_Num" that numbers each feature in the map for each page but I don't know how to use a searchcursor and getValue.

Re: Text Element Questions

T__WayneWhitley — Sat, 11 Dec 2021 15:27:52 GMT

Are you using Mathew's code? (If so, you should award him points and/or the answer when you finally get things running.)

As 'extra' help, this is where the row from your table value for the 'field' is passed (from Mathew's last posted code):

for row in arcpy.SearchCursor(mapLyr.dataSource, sort_fields='{0} A'.format(field)):
        text_var += '{0}{1}'.format(row.getValue(field), os.linesep)

EDIT:
Actually, in that 1st line above, all your table fields are being passed in, just that the one specified as 'field' (assigned at the SetParam statement at the beginning) is used for sorting.

So you could 'look up' other field values by inserting a line within the loop such as:

aNewTxtVar = row.getValue('yourDesignatedFieldname')

(see getValue for the SearchCursor in the webhelp)
Anyway, hope that helps!

Enjoy,
Wayne

Re: Text Element Questions

GeoffOlson — Sat, 11 Dec 2021 15:27:55 GMT

I think I just got it working. Here's the final script:

import arcpy, os

mxd = arcpy.mapping.MapDocument("Current")
mapLyr = arcpy.mapping.ListLayers(mxd, "Detail_2013")[0]

concatElem1 = arcpy.mapping.ListLayoutElements(mxd, "TEXT_ELEMENT", "concat1")[0]
concatElem2 = arcpy.mapping.ListLayoutElements(mxd, "TEXT_ELEMENT", "concat2")[0]

rowcount = int(arcpy.GetCount_management("Detail_2013").getOutput(0))
percolumn = round(rowcount / 2.0)
count1 = 1
count2 = rowcount

rows = arcpy.SearchCursor(mapLyr.dataSource)

text_var1 = str()
text_var2 = str()

for row in rows:
    if count1 <= percolumn:
        text_var1 += '{0}{1}'.format(row.getValue("CONCAT"), os.linesep)
        concatElem1.text = text_var1
        count1 += 1
    elif count2 > percolumn:
        text_var2 += '{0}{1}'.format(row.getValue("CONCAT"), os.linesep)
        concatElem2.text = text_var2
        count2 - 1
    else:
        pass
mxd.save()
del mxd, row, rows,

Python disregarding DDP Page Query

GeoffOlson — Fri, 16 Aug 2013 14:50:59 GMT

The only problem I have now is the script isn't following the page definition query. Only the queried features appear in the attribute table, but the script lists all features, even the ones that are queried out.

Re: Text Element Questions

T__WayneWhitley — Fri, 16 Aug 2013 15:05:01 GMT

Well you have options - that's the good news. The searchcursor input parameter works on a layer (the 1st param)...or you could optionally enter a query filter...see the syntax and explanation at the link below:

usage:
SearchCursor (in_table, field_names, {where_clause}, {spatial_reference}, {explode_to_points}, {sql_clause})

http://resources.arcgis.com/en/help/main/10.1/index.html#//018w00000011000000

oops, that one was for the da (data access) search cursor.... you need this one:

SearchCursor (dataset, {where_clause}, {spatial_reference}, {fields}, {sort_fields})

http://resources.arcgis.com/en/help/main/10.1/index.html#//018v00000050000000

Re: Text Element Questions

GeoffOlson — Fri, 16 Aug 2013 16:26:10 GMT

Using a SearchCursor should filter out which rows are being returned? Can multiple row.getValue functions be used? I was concerned the "for row from rows:" would have assigned a value to row and couldn't be used twice, and a different variable be created in place of row?

Manually setting a definition query also fails to limit which rows get searched.

Re: Text Element Questions

T__WayneWhitley — Fri, 16 Aug 2013 16:35:15 GMT

You should post your code and any error msgs you're receiving...

In short, yes you can get another field value from the row object.
Incidentally, you could say 'for browncow in rows' and you are still implicitly getting a row object from the cursor. (why simply using 'row' is often used)

I suspect your where_clause query is faulty, but have no idea since there's no posted code, etc. Don't forget to post the error msg too!

Re: Text Element Questions

GeoffOlson — Sat, 11 Dec 2021 15:27:58 GMT

I added this to get the page name:

pageNum = arcpy.GetParameterAsText(0)
ddp = mxd.dataDrivenPages
arcpy.AddMessage(pageNum)
pageID = mxd.dataDrivenPages.getPageIDFromName(str(pageNum))
mxd.dataDrivenPages.currentPageID = pageID

and I changed the SearchCursor to this:

rows = arcpy.SearchCursor(mapLyr.dataSource, "PageID = \'Intersec\'")

but I get an error saying the fields in the search cursor do not exits. I'm trying to set the field value to the page name. The other thing that happens is the page name seems to only be stored as a page number and not the specified index layer field.