topic Re: Store relative path for map documents in sub folders using Python in Python Questions

Store relative path for map documents in sub folders using Python

Brian_McLeer — Wed, 29 Nov 2017 18:57:50 GMT

I am trying to find a way to set relative paths in MXDs using Python for several sub folders within a main folder. Using this Tech Support article, it allows it to be done on MXDs in the folder listed as the workspace. What I am looking for is not only the folder listed in the workspace, but MXDs that exist in subfolders. The goal would be for the Python to open all MXDs under the parent folder and subfolder, check on Set Relative Path Name, Save and Close MXD.

Re: Store relative path for map documents in sub folders using Python

RandyBurton — Sat, 11 Dec 2021 08:25:15 GMT

Try this to find your mxd files:

import os
from glob import glob
PATH = r'C:\Start\Here'
result = [y for x in os.walk(PATH) for y in glob(os.path.join(x[0], '*.mxd'))]
for mxd in result:
    print mxd # continue here with processing your files‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Store relative path for map documents in sub folders using Python

Brian_McLeer — Sat, 11 Dec 2021 08:25:18 GMT

So combined code would be:

import os
import arcpy, os
from glob import glob
PATH = r'C:\Users\mclbr\Desktop\GIS_Maintenance'
result = [y for x in os.walk(PATH) for y in glob(os.path.join(x[0], '*.mxd'))]
for mxd in result:
 print mxd # continue here with processing your files


import arcpy, os
#workspace to search for MXDs
Workspace = r"C:\Users\mclbr\Desktop\GIS_Maintenance"
arcpy.env.workspace = Workspace
#list map documents in folder
mxdList = arcpy.ListFiles("*.mxd")
#set relative path setting for each MXD in list.
for file in mxdList:
 #set map document to change
 result = os.path.join(Workspace, file)
 mxd = arcpy.mapping.MapDocument(filePath)
 #set relative paths property
 mxd.relativePaths = True
 #save map doucment change
 mxd.save()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Store relative path for map documents in sub folders using Python

RandyBurton — Sat, 11 Dec 2021 08:25:20 GMT

I think it would be more like this, but I haven't tested the code:

import os
from glob import glob
import arcpy

PATH = r'C:\Users\mclbr\Desktop\GIS_Maintenance'
arcpy.env.workspace = PATH

result = [y for x in os.walk(PATH) for y in glob(os.path.join(x[0], '*.mxd'))]
for map in result:  # map will be complete path to map file
    print "Processing: {}".format(map) # keep track of what's happening
    mxd = arcpy.mapping.MapDocument(map)
    #set relative paths property
    mxd.relativePaths = True
    #save map doucment change
    mxd.save()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

You can add some additional print statements to help keep track of what's happening and to assist with debugging.

I'm not sure how the arcpy workspace plays into relative paths. You may need to move this into your for loop and set workspace equal to the path up to your mxd file.

Re: Store relative path for map documents in sub folders using Python

DanPatterson_Retired — Wed, 29 Nov 2017 23:48:10 GMT

Brian.... Code Fomatting the Basics++

to make your code easier to read like Randy's