topic Re: how to dynamically update a data driven page excel table in Mapping Questions

how to dynamically update a data driven page excel table

KenLucas — Thu, 06 Sep 2012 18:49:26 GMT

I'm new to data driven pages. Is there a built-in function to update an excel table, embedded on a data driven page, from a linked table on my local drive or do I need a python script to do this?

Re: how to dynamically update a data driven page excel table

JeffBarrette — Fri, 07 Sep 2012 13:26:38 GMT

This is not built into DDP. In order to generate truely dynamic tables from one page to the next you will need to incorporate arcpy.mapping (a scripting API). There is a sample that demonstrates how to create dynamic tables with arcpy.mapping.

http://www.arcgis.com/home/item.html?id=3a525b986b774a3f9cbbd8daf2435852

Jeff

Re: how to dynamically update a data driven page excel table

KenLucas — Fri, 07 Sep 2012 15:18:14 GMT

Jeff,
I have ArcGis 10, service pack 5. I get an error message when I attmept to open that DDP enabled hispanic mxd, you gave me, saying I should save as copy. However, there is nothing in the table of contents in the mxd and catalog does not show the Toolbox.tbx. What do you suggest I try next; I'd really like to work thru this example today.
I'm new to DDP and seeking help on the forum. Thanks so much for your time and effort to answer my thread,
Ken

Re: how to dynamically update a data driven page excel table

JeffBarrette — Fri, 07 Sep 2012 20:53:03 GMT

This is a 10.1 sample. It used the new cloning functions that allow for creating dynamic tables.

A 10.0 sample that uses a static graphic table may be applicable for your work. See:
http://www.arcgis.com/home/item.html?id=af4fe32a93554eadbd3be3b0e55326be

Jeff

Re: how to dynamically update a data driven page excel table

KenLucas — Fri, 07 Sep 2012 21:43:34 GMT

Jeff,
That 10.0 sample mxd, you just gave me, opens with broken links. When I attempt to repair the links arc map does not even see any data in the downloaded folder, including the file geodbase that I see in windows explorer. I can't seem to extract anything from the downloaded folder. Is there something else I should be doing after I download the folder?
Ken

Re: how to dynamically update a data driven page excel table

JeffBarrette — Mon, 10 Sep 2012 15:44:08 GMT

I installed 10.0 on a new machine, downloaded the zip and it all just worked. I'm not sure why things are not working for you. Could it be a file permissions issue, the location of your copy has spaces in the path, etc. Over 100 people have downloaded this and there have been no other reports.

Jeff

Re: how to dynamically update a data driven page excel table

KenLucas — Tue, 11 Sep 2012 19:28:09 GMT

Jeff,
Reading your last thread, I was moved to keep trying to open the package and I finally got it open and working. Thank you so much for the patience. I'm new to using the forum and have overlooked some important details in managing the data. I'm working thru the readme instructions.
Ken

Re: how to dynamically update a data driven page excel table

KenLucas — Mon, 17 Sep 2012 17:18:01 GMT

I just worked thru MapbookwithGraphicTables 10v1 exercise. The section on the arcpy script for the tables seems to indicate that the 3 tables that show on the bottom center of the MXD were made from scratch and don't seem to reference Excel tables. Is there developer python script that allows us to embed a diff excel sheet for each different page of a DDP series? We can add an object to a DDP and even link that added ojbect table to an excel sheet, but this won't allow us to link diff DDP pages to diff excel sheets. What is the path for the place on the ESRI website where the developer python scripts are stored?
Ken

Re: how to dynamically update a data driven page excel table

JeffBarrette — Thu, 27 Sep 2012 19:30:13 GMT

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

Jeff