Latest Contributions by JeffBarrette

This is a known issue: NIM085743 - UpdateLayer will not update symbology if the source layer object is not in the map. We will address it in a future service pack. Thanks, Jeff ... View more

One of the common issues people have with AGO content is that they need to change their "show" setting from "Web Content" to "All. Try this, this will get you to the arcpy.mapping group where you can see many samples posted: Go to: http://www.arcgis.com/home/ Then click the Groups link In the search box, type "arcpy.mapping Click on the one resulting link. Make sure you change "Show" to all - it alone the top of the screen. You should see all the (9) samples The one you want is called "DDPwithDynamicTablesAndGraphs_10.1_v1" I really hope this works for you, Jeff ... View more

Ken, Data Driven Pages do not support dynamic tables.  This was something we hoped to accomplish in the UI for 10.1 (if time allowed).  But at 10.1 we were able to expand the arcpy.mapping API that allows us to build truly dynamic tables (graphically) using the new cloning capabilities.   The idea is to use scripting logic to dynamically build the graphic table by cloning horizontal and vertical lines that ultimately construct a table.  This logic is executed for each page in a series and therefore, each page can have a table that has a different number of rows, etc.  The text in the table is basic inserted text elements (not dynamic text in the sense of DDP but dynamic in the sense that you can alter it dynamically through code).  I typically have one text element for each column in a table.  Then using scripting logic, I populate that column of data by reading rows in a data source and concatenate each value with a new line in between each value. The best and newest sample available can be found at: http://www.arcgis.com/home/item.html?id=3a525b986b774a3f9cbbd8daf2435852 This method does not care what the data source is (e.g., DBF, excel).  If you can read the table in ArcMap, then you can write the information to the graphic table. Download it and take a look at the code. I really hope this helps, Jeff ... View more

I think the following script will do what you need.  Make sure to save the MXD with ALL group layers checked off (and all layers within the group layer checked on).  See attached screen shot. A field was added to the index layer called "GroupLayerName".  It has the values "GroupLayer1, GroupLayer2, etc).  After exporting to PDF, the script then turns the group layer back off again before going to the next DDP page. import arcpy mxd = arcpy.mapping.MapDocument(r"c:\Temp\test.mxd") ddp = mxd.dataDrivenPages for pageNum in range(1, mxd.dataDrivenPages.pageCount + 1):   mxd.dataDrivenPages.currentPageID = pageNum   fieldValue = mxd.dataDrivenPages.pageRow.GroupLayerName   for lyr in arcpy.mapping.ListLayers(mxd):     if lyr.name == fieldValue:       lyr.visible = True       arcpy.mapping.ExportToPDF(mxd, r"C:\\Temp\\" + fieldValue + ".pdf")       lyr.visible = False del mxd [ATTACH=CONFIG]18285[/ATTACH] Jeff ... View more

Could you provide screen shots and anything else that may be unique about your tables (e.g., source data, ole object, etc). Jeff ... View more

Are you saying that if you physically open an MXD in ArcMap, look at the layout, export to PDF, all is well.  But if you connect to an mxd via arcpy.mapping and export to PDF, you don't get the same results? import arcpy mxd = arcpy.mapping.MapDocument(path to mxd) arcpy.mapping.ExportToPDF(mxd, path to pdf) del mxd It would be nice to see your output PDFs. Jeff ... View more

Then try what Jake suggests.  In your original code, you reference an MXD but never a layer within it.  Rather you are referencing a layer file via the .Layer function.  You need to use ListLayers to reference a layer in an MXD.  Then you can switch out the data source. Jeff ... View more

Are you trying to change the workspace for a data source in a layer file or for a layer in an mxd?  Both scenarios are supported but the two snippets of code are doing different things? If you are trying to work with layer files you are missing one step.  Treat a layer file like an MXD.  Once you connect to it, you still need to search for the layers within it using ListLayers. #In example below, a layer file if pointing to a shapefile in c:\temp #It is redirected to a data source in c:\active #and then saved to a new layer file (in c:temp) #Old shapefile was usa.shp, new one is use2.shp import arcpy lyrFile = arcpy.mapping.Layer(r"C:\Temp\usa.lyr") for lyr in arcpy.mapping.ListLayers(lyrFile):                  #THIS IS THE MISSING PIECE   if lyr.name == "usa":     lyr.replaceDataSource(r"C:\Active", "SHAPEFILE_WORKSPACE", "usa2") lyrFile.saveACopy(r"C:\Temp\usa2.lyr") Jeff ... View more

Please refer to the following posts: http://forums.arcgis.com/threads/66365-how-to-dynamically-update-a-data-driven-page-excel-table http://forums.arcgis.com/threads/67743-Adding-table-to-layout-view Thanks, Jeff ... View more

Dynamic excel tables are not supported with DDP.  You must use one of the techniques provided in an earlier response. Jeff ... View more