Latest Contributions by GeoffOlson

I have a full working script!  Mzcoyle and Wayne, I couldn't have done this without you guys, so thank you so much for your patience and help!  I have to also thank South Kingstown, RI for their ESRI example, I wouldn't have been able to figure this out without their template.  Only one parameter was created and that was for the page number selection. The tool takes the features in the data driven page map extent and lists the "CONCAT" field into two text elements on the screen.  The "CONCAT" field is a concatenated field of the feature's number on the map and the feature description.  Each feature's string is listed on a new line and the lines are divided so it appears as though there are two columns of text.  If there are an uneven number of lines, then the first column will have one more line than the second. Here's the python code: import arcpy, os  #set map doc and the layer to be used mxd = arcpy.mapping.MapDocument("Current") mapLyr = arcpy.mapping.ListLayers(mxd, "Detail_2013")[0]  #Get page number from data driven page - specified in the tool parameter dialogue box pageNum = arcpy.GetParameterAsText(0) ddp = mxd.dataDrivenPages arcpy.AddMessage(pageNum) pageID = mxd.dataDrivenPages.getPageIDFromName(pageNum) mxd.dataDrivenPages.currentPageID = pageID  #Set layer definition query, this contols the rowcount variable pageFieldValue = pageNum mapLyr.definitionQuery = '"pageNum" = %s' % pageNum  #Listing the text elements on the page concatElem1 = arcpy.mapping.ListLayoutElements(mxd, "TEXT_ELEMENT", "concat1")[0] concatElem2 = arcpy.mapping.ListLayoutElements(mxd, "TEXT_ELEMENT", "concat2")[0]  #Finds the number of features in the map and sets up the lists to evenly distribute into the two text elements/columns rowcount = int(arcpy.GetCount_management("Detail_2013").getOutput(0)) percolumn = round(rowcount / 2.0) count1 = 1 count2 = rowcount  #Specifies the features being used for the SearchCursor rows = arcpy.SearchCursor(mapLyr, "", "", "CONCAT") fieldrow  = arcpy.SearchCursor(mapLyr, "", "", "pageNum") currentpage = ""  text_var1 = str() text_var2 = str()  #The first for and if block limits the searched rows to the definition query #The seconded/indented for and if block adds the text fields to the text elements for row in fieldrow:     if currentpage != row.pageNum:         currentpage = row.pageNum         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     else:         pass  #Removed the definition query so all page numbers appear when the script is run next and refresh he layout view mapLyr.definitionQuery = "" arcpy.RefreshActiveView() del mxd, row, rows, rowcount, percolumn, count1, count2 And this part is what is in the validation field of the script tool: class ToolValidator:   """Class for validating a tool's parameter values and controlling   the behavior of the tool's dialog."""    def __init__(self):     """Setup the Geoprocessor and the list of tool parameters."""     import arcpy     self.params = arcpy.GetParameterInfo()    def initializeParameters(self):     """Refine the properties of a tool's parameters.  This method is     called when the tool is opened."""     import arcpy, os, sys      #Reference Plat Index Layer to get unique Plat Numbers     mxd = arcpy.mapping.MapDocument("CURRENT")     mapLyr = arcpy.mapping.ListLayers(mxd, "Detail_2013")[0]      #Iterate rows in Plat Index Layer to generate unique name list     rows = arcpy.SearchCursor(mapLyr)     row = rows.next()      #Create and populate list     uniqueList = []     while row:       #If the value is not already in the list, append it       if row.getValue("pageNum") not in uniqueList:         uniqueList.append(row.getValue("pageNum"))       row = rows.next()            #Sort the list alphanumerically         uniqueList.sort()     self.params[0].filter.list = uniqueList     self.params[0].value = uniqueList[0]     return    def updateParameters(self):     """Modify the values and properties of parameters before internal     validation is performed.  This method is called whenever a parmater     has been changed."""     return    def updateMessages(self):     """Modify the messages created by internal validation for each tool     parameter.  This method is called after internal validation."""     return ... View more