Latest Contributions by JohnByrne

Hi folks, Rebecca - Yeah I made all though checks and they were ok. Bill - your solution worked perfectly until I had an mxd that had more than one database connection in there e.g: DARDOFMD@lpisapp.sde & DARDOFMD@suppapp.sde. So I get an mxd with only some of the layers replaced and others with broken links! So close... ... View more

Hi Dan, I am going to have a play with your advice now. Essentially my problems are (many but will simplify) 1. I need to create datadriven pages from a specific query, which I have managed to do at the minute. 2. The results of this query needs to be also shown in a seperate table hence why I am trying to export it to Excel. We have had a look at using Production mapping but there are too many varied results between queries to maintain a consistent look. 3. I am unsure, due to my inexperience if I should be changing the input and out when it appears in the script to get the results. Hope that makes sense and thanks for your help ... View more

This a view of the amended code, as per your advice import arcpy import os import sys import xlwt import datetime mxd=arcpy.mapping.MapDocument("current") BUSID_TEMP=arcpy.GetParameterAsText(0) LayersDF=arcpy.mapping.ListDataFrames(mxd, "Layers")[0] selLyr=arcpy.mapping.ListLayers(mxd, "FP_sample", LayersDF)[0] for elm in arcpy.mapping.ListLayoutElements(mxd):     if elm.name=="GridTable": GridTable = elm ddp=mxd.dataDrivenPages arcpy.AddMessage(BUSID_TEMP) pageID=mxd.dataDrivenPages.getPageIDFromName(str(BUSID_TEMP)) mxd.dataDrivenPages.currentPageID=pageID #excel export part of the script def table_to_excel(FP_sample, output, use_field_alias=False, use_domain_desc=False):     desiredFields=["Field1","Field3","Field4"] #desired fields for excel output     # Get the fields from the input     fields= arcpy.ListFields(in_table)     # Create a fieldinfo object     fieldinfo = arcpy.FieldInfo()     # Iterate through the fields and set them to fieldinfo     for field in fields:         if field in desiredFields:             fieldinfo.addField(field.name, field.name, "VISIBLE", "")     # The created view layer will have fields as set in fieldinfo object     arcpy.MakeTableView_management(FP_sample, "table_view", "", "", fieldinfo)     # To persist the layer on disk make a copy of the view     arcpy.TableToExcel_conversion("table_view", pop.xls) ... View more

It seems to work, unfortunately I don't know how to define the output ... View more

Hi Joshua, Thanks for replying, that certainly looks promising. I am actually trying to export the table based on a query I have already ran and linked to Data Driven Pages. How would I refernce that in the Make Table View? I am new to this so please excuse the silly question. I have linked my current attempt at the script, which works for the initial part of what I am trying to achieve, just failing at the output. I have attached my script so you can maybe see it easier. Thanks ... View more

Thanks Dan, silly error. I am struggling to get the script to run and the problem seems to lay in my query and Search Cursor. It is giving me an error which says Traceback (most recent call last):   File "D:\Profiles\jByrne\Documents\DARD GIS\TEST SCRIPT\GridMon16_help.py", line 13, in <module>     FP_sampleRows=arcpy.SearchCursor(GridTable.datasource, queryExp) AttributeError: 'TextElement' object has no attribute 'datasource' I have attached my code as well. I am running out of ideas and because I don't know it very well (started scripting friday!) I can't really see the wood for the trees. import arcpy, os, sys mxd=arcpy.mapping.MapDocument("current") BUSID_TEMP=arcpy.GetParameterAsText(0) LayersDF=arcpy.mapping.ListDataFrames(mxd, "Layers")[0] selLyr=arcpy.mapping.ListLayers(mxd, "FP_sample", LayersDF)[0] for elm in arcpy.mapping.ListLayoutElements(mxd):     if elm.name=="GridTable": GridTable = elm ddp=mxd.dataDrivenPages arcpy.AddMessage(BUSID_TEMP) pageID=mxd.dataDrivenPages.getPageIDFromName(str(BUSID_TEMP)) mxd.dataDrivenPages.currentPageID=pageID queryExp="\"BUSID_TEMP\"='"+BUSID_TEMP+"'" FP_sampleRows=arcpy.SearchCursor(GridTable.datasource, queryExp) revTable=arcpy.mapping.ListTableViews(mxd,"GridTable") arcpy.RefreshActiveView() arcpy.AddMessage("Process Completed") Thanks ... View more

Hi Jeff, I am a newbie to DynamicGraphicTables and Data Driven pages. Your links were really useful and seem to be exactly what I want to do, unfortunately I am not a guru on python and am struggling to edit the python script to use it for my own needs. Any advice? Thanks John ... View more

George, in fact your help was perfect. Thanks ... View more