topic Re: export map layout with loop definition query in Python Questions

export map layout with loop definition query

MahmoudHegazy — Wed, 15 Sep 2021 09:08:49 GMT

i would like to complete my script to zoom to layer per definition and export pdf but the script give me bugs when it export pdf and not zooming can any help me

import arcpy, os

arcpy.env.overwriteOutput = True
mxd = arcpy.mapping.MapDocument("CURRENT")
df = arcpy.mapping.ListDataFrames(mxd)[0]

layerName = arcpy.GetParameterAsText(0)
fieldName = arcpy.GetParameterAsText(1)
imgLocation = arcpy.GetParameterAsText(2)
whereList = []

layerFile = arcpy.mapping.Layer(layerName)
layerFile.definitionQuery = ""

print df.name

with arcpy.da.SearchCursor(layerName, fieldName) as cursor:
for row in cursor:
for item in row:
whereList.append(item)

for wl in whereList:
layerFile.definitionQuery = fieldName + "= '" + wl + "'"
df = layerFile.getExtent()
df.extent = outFile
outFile = imgLocation + "\\" + wl + ".pdf"

arcpy.mapping.ExportToPDF(mxd, outFile)

del mxd

Re: export map layout with loop definition query

DavidPike — Wed, 15 Sep 2021 12:52:08 GMT

This bit makes no sense

#variables are all messed up for wl in whereList: layerFile.definitionQuery = fieldName + "= '" + wl + "'" df = layerFile.getExtent() df.extent = outFile outFile = imgLocation + "\\" + wl + ".pdf" #should be for wl in whereList: layerFile.definitionQuery = fieldName + "= '" + wl + "'" new_extent = layerFile.getExtent() df.extent = new_extent arcpy.RefreshActiveView() outFile = imgLocation + "\\" + wl + ".pdf"

Re: export map layout with loop definition query

MahmoudHegazy — Wed, 15 Sep 2021 14:15:18 GMT

the extent run very well but still getting error to export pdf

File "c:\program files (x86)\arcgis\desktop10.4\arcpy\arcpy\mapping.py", line 1156, in ExportToPDF
layout.exportToPDF(*args)
AttributeError: Invalid destination path

Failed to execute (Script)

Re: export map layout with loop definition query

DavidPike — Wed, 15 Sep 2021 14:28:56 GMT

what path are you supplying for imgLocation?

I prefer to use the os.path.join() method when constructing paths:

outFile = os.path.join(imgLocation, wl + ".pdf") arcpy.AddMessage(outFile)

Re: export map layout with loop definition query

MahmoudHegazy — Wed, 15 Sep 2021 15:09:56 GMT

it worked thanks but when it get extent , the extent 100% i want to customize it to 115% to make the feature fully visible

Re: export map layout with loop definition query

DavidPike — Wed, 15 Sep 2021 15:32:01 GMT

probably adjust the scale factor e.g.

df.scale *= 1.15

Re: export map layout with loop definition query

MahmoudHegazy — Wed, 15 Sep 2021 21:34:59 GMT

this my layout and after i export the layout to pdf after i export it looked this

and the size page is A1

Re: export map layout with loop definition query

MahmoudHegazy — Thu, 16 Sep 2021 09:38:55 GMT

how i export the pdf from the layout ?

Re: export map layout with loop definition query

DavidPike — Fri, 17 Sep 2021 11:38:35 GMT

Can you share your final code?

You're saying that the second image is the pdf produced?

Are you sure you're specifying the same MXD which contains the layout?

The layout should be used as default in arcpy.mapping.ExportToPDF(mxd, outFile), but maybe try this just in case:

arcpy.mapping.ExportToPDF(mxd, outFile, "PAGE_LAYOUT")

and what if you try JPEG or PNG etc. ?

outFile = os.path.join(imgLocation, wl + ".jpg") arcpy.mapping.ExportToJPEG(mxd, outFile)

Re: export map layout with loop definition query

MahmoudHegazy — Fri, 17 Sep 2021 13:27:40 GMT

you helped me more thanks this the final script by DavidPike
i want use the dynamic table and this not in armap this onlyy in arcgis pro so i want convert my final script to arcgis pro

import arcpy, os

arcpy.env.overwriteOutput = True
mxd = arcpy.mapping.MapDocument("CURRENT")

df = arcpy.mapping.ListDataFrames(mxd)[0]

layerName = arcpy.GetParameterAsText(0)
fieldName = arcpy.GetParameterAsText(1)
imgLocation = arcpy.GetParameterAsText(2)
whereList = []

layerFile = arcpy.mapping.Layer(layerName)
layerFile.definitionQuery = ""

print df.name

with arcpy.da.SearchCursor(layerName, fieldName) as cursor:
for row in cursor:
for item in row:
whereList.append(item)

for wl in whereList:
layerFile.definitionQuery = fieldName + "= '" + wl + "'"

new_extent = layerFile.getExtent()
df.extent = new_extent
df.scale *= 1.5
arcpy.RefreshActiveView()
outFile = os.path.join(imgLocation, wl + ".pdf")
arcpy.AddMessage(outFile)
outFile = imgLocation + "\\" + wl + ".pdf"
arcpy.mapping.ExportToPDF(mxd, outFile, "PAGE_LAYOUT")

del mxd

Re: export map layout with loop definition query

DavidPike — Fri, 17 Sep 2021 13:45:06 GMT

Did what I say work? If so what was the issue and what solved it?

Re converting it to Pro, it will be more than a simple changing of a few things, as there's a different mapping class, camera objects etc. I'd recommend putting this thread to rest and posting an entirely new question.

Re: export map layout with loop definition query

MahmoudHegazy — Fri, 17 Sep 2021 14:34:49 GMT

thanks i will do it but befor i want to add a dynamic text in arcmap each layout want the dynamic lebel change i tried to this but not organized my code

import arcpy, os

arcpy.env.overwriteOutput = True
mxd = arcpy.mapping.MapDocument("CURRENT")

df = arcpy.mapping.ListDataFrames(mxd)[0]

layerName = arcpy.GetParameterAsText(0)
fieldName = arcpy.GetParameterAsText(1)
imgLocation = arcpy.GetParameterAsText(2)
whereList = []

layerFile = arcpy.mapping.Layer(layerName)
layerFile.definitionQuery = ""

print df.name

with arcpy.da.SearchCursor(layerName, fieldName) as cursor:
for row in cursor:
for item in row:
whereList.append(item)
mxd.activeView = "PAGE_LAYOUT"
for elm in arcpy.mapping.ListLayoutElements(mxd, "TEXT_ELEMENT"):
for wl in whereList:
if elm.text == "title":
elm.text = elm.text.replace(elm,wl)
arcpy.RefreshActiveView()
mxd.save()
layerFile.definitionQuery = fieldName + "= '" + wl + "'"
new_extent = layerFile.getExtent()
df.extent = new_extent
df.scale *= 1.5
arcpy.RefreshActiveView()
outFile = os.path.join(imgLocation, wl + ".pdf")
arcpy.AddMessage(outFile)
outFile = imgLocation + "\\" + wl + ".pdf"
arcpy.mapping.ExportToPDF(mxd, outFile, "PAGE_LAYOUT")

del mxd

Re: export map layout with loop definition query

DavidPike — Fri, 17 Sep 2021 14:55:17 GMT

If you properly format your code I might be able to assist. Code formatting ... the Community Version - Esri Community

Re: export map layout with loop definition query

MahmoudHegazy — Fri, 17 Sep 2021 16:09:41 GMT

import arcpy, os arcpy.env.overwriteOutput = True mxd = arcpy.mapping.MapDocument("CURRENT") df = arcpy.mapping.ListDataFrames(mxd)[0] layerName = arcpy.GetParameterAsText(0) fieldName = arcpy.GetParameterAsText(1) imgLocation = arcpy.GetParameterAsText(2) whereList = [] layerFile = arcpy.mapping.Layer(layerName) layerFile.definitionQuery = "" print df.name with arcpy.da.SearchCursor(layerName, fieldName) as cursor: for row in cursor: for item in row: whereList.append(item) #the code blow for lebel Dynamic in the layout mxd.activeView = "PAGE_LAYOUT" for elm in arcpy.mapping.ListLayoutElements(mxd, "TEXT_ELEMENT"): for wl in whereList: if elm.text == "title": elm.text = elm.text.replace(elm,wl) arcpy.RefreshActiveView() mxd.save() layerFile.definitionQuery = fieldName + "= '" + wl + "'" new_extent = layerFile.getExtent() df.extent = new_extent df.scale *= 1.5 arcpy.RefreshActiveView() outFile = os.path.join(imgLocation, wl + ".pdf") arcpy.AddMessage(outFile) outFile = imgLocation + "\\" + wl + ".pdf" arcpy.mapping.ExportToPDF(mxd, outFile, "PAGE_LAYOUT") del mxd

Re: export map layout with loop definition query

DavidPike — Fri, 17 Sep 2021 16:27:12 GMT

Having the for loop for the text element as the initial loop is a bit off imho. also note your element would have to be named 'title' (in the text element properties on your layout there is a name box where you can specify this)

for wl in whereList: arcpy.RefreshActiveView() mxd.save() layerFile.definitionQuery = fieldName + "= '" + wl + "'" new_extent = layerFile.getExtent() df.extent = new_extent df.scale *= 1.5 for elm in arcpy.mapping.ListLayoutElements(mxd, "TEXT_ELEMENT"): if elm.text == "title": elm.text = wl arcpy.RefreshActiveView() outFile = os.path.join(imgLocation, wl + ".pdf") arcpy.AddMessage(outFile) outFile = imgLocation + "\\" + wl + ".pdf" arcpy.mapping.ExportToPDF(mxd, outFile, "PAGE_LAYOUT")

Re: export map layout with loop definition query

MahmoudHegazy — Fri, 17 Sep 2021 18:24:23 GMT

i made test and change the lebel to "title" as you see in the screen shot but the pdf exportefd without chang

e the dynamic lebel can you retest the code and see it again

my final look code is this

import arcpy, os arcpy.env.overwriteOutput = True mxd = arcpy.mapping.MapDocument("CURRENT") df = arcpy.mapping.ListDataFrames(mxd)[0] layerName = arcpy.GetParameterAsText(0) fieldName = arcpy.GetParameterAsText(1) imgLocation = arcpy.GetParameterAsText(2) whereList = [] layerFile = arcpy.mapping.Layer(layerName) layerFile.definitionQuery = "" print df.name with arcpy.da.SearchCursor(layerName, fieldName) as cursor: for row in cursor: for item in row: whereList.append(item) for wl in whereList: arcpy.RefreshActiveView() mxd.save() layerFile.definitionQuery = fieldName + "= '" + wl + "'" new_extent = layerFile.getExtent() df.extent = new_extent df.scale *= 1.5 for elm in arcpy.mapping.ListLayoutElements(mxd, "TEXT_ELEMENT"): if elm.text == "title": elm.text = wl arcpy.RefreshActiveView() outFile = os.path.join(imgLocation, wl + ".pdf") arcpy.AddMessage(outFile) outFile = imgLocation + "\\" + wl + ".pdf" arcpy.mapping.ExportToPDF(mxd, outFile, "PAGE_LAYOUT") del mxd

Re: export map layout with loop definition query

DavidPike — Fri, 17 Sep 2021 19:26:51 GMT

ah I think I made a silly error, I'm unable to test this.

side note - why are you using mxd.save() and why have you got outFile variable created then overwritten 2 lines later?

import arcpy, os arcpy.env.overwriteOutput = True mxd = arcpy.mapping.MapDocument("CURRENT") df = arcpy.mapping.ListDataFrames(mxd)[0] layerName = arcpy.GetParameterAsText(0) fieldName = arcpy.GetParameterAsText(1) imgLocation = arcpy.GetParameterAsText(2) whereList = [] layerFile = arcpy.mapping.Layer(layerName) layerFile.definitionQuery = "" print df.name with arcpy.da.SearchCursor(layerName, fieldName) as cursor: for row in cursor: for item in row: whereList.append(item) for wl in whereList: arcpy.RefreshActiveView() mxd.save() layerFile.definitionQuery = fieldName + "= '" + wl + "'" new_extent = layerFile.getExtent() df.extent = new_extent df.scale *= 1.5 for elm in arcpy.mapping.ListLayoutElements(mxd, "TEXT_ELEMENT", "title"): if elm.name == "title": elm.text = wl arcpy.RefreshActiveView() outFile = os.path.join(imgLocation, wl + ".pdf") arcpy.AddMessage(outFile) outFile = imgLocation + "\\" + wl + ".pdf" arcpy.mapping.ExportToPDF(mxd, outFile, "PAGE_LAYOUT") del mxd

Re: export map layout with loop definition query

MahmoudHegazy — Fri, 17 Sep 2021 20:06:59 GMT

firstly i would like to thank a lot for your effort

i made in mxd save and overwrite beacouse the code write from the field have char like )(.\ and the code run out while was running so

saving mxd to know the last extent while the cod was run

what iam thinking now to put the function .strip() int outfile name to clear char like this ()\|?

Re: export map layout with loop definition query

MahmoudHegazy — Fri, 17 Sep 2021 20:07:25 GMT

the code worked

Re: export map layout with loop definition query

DavidPike — Fri, 17 Sep 2021 21:03:23 GMT

.strip() would only remove trailing and leading stuff. Probably best to do something like this:

name = '' for char in wl: if char.isalpha(): name+=char outFile = imgLocation + '\\' + name + '.pdf'