Changing LYR from absolute to relative path through ArcPy

Question

I need to change thousands of LYR files to use relative paths instead of absolute.  Following the example in help I got this:

import arcpy, os
folderPath = r"C:\Testing\ArcGIS10_release\paths"
for filename in os.listdir(folderPath):
    fullpath = os.path.join(folderPath, filename)
    if os.path.isfile(fullpath):
        basename, extension = os.path.splitext(fullpath)
        if extension.lower() == ".lyr":
            lyr = arcpy.mapping.Layer(fullpath)
            lyr.findAndReplaceWorkspacePath (r"C:\Testing\ArcGIS10_release\paths", r"\ Testing\ArcGIS10_release\paths ")
            lyr.save()
del lyr

The paths are coming out as broken when I move them to the same path but a different directory (D:\Testing\ArcGIS10_release\paths).  I think I need to append the file name on the end of the path for this to work - but am not sure how.

Any help?

jayshukla · Answer

Hi Jeffery, 
Thanks for your reply. This is the script that I am using. I am having mixed success. Script fails sometimes, giving some Utility.py error.

I would appreciate any suggestions.

Thanks
Jay

import arcpy, datetime, os, io, sys

try:

#Read input parameters from GP dialog
  
    # Prod Setting...
    folderPath = arcpy.GetParameterAsText(0)
    output = arcpy.GetParameterAsText(1)
    sourceString = r"P:\Local" # arcpy.GetParameterAsText(1)
    replacmentString = r"\hq\share" # arcpy.GetParameterAsText(2)
    
    #Create an output file
    outFile = open(output, "w")

#Loop through each "LYR" file
    count = 0
    for path, dires, files in os.walk(folderPath): 
        for filename in files:
            fullpath = os.path.join(path, filename)

if os.path.isfile(fullpath):
                if filename.lower().endswith(".lyr"):
                    groupLayerName = ""
                    layerFile = arcpy.mapping.Layer(fullpath)

#Reference each layer in a layer file
                    count = 1
                    for lyr in arcpy.mapping.ListLayers(layerFile):
                        if lyr.isGroupLayer:
                            groupLayerName = lyr.name

if lyr.supports("DATASOURCE"):
                            
                            oldLoc = sourceString
                            newLoc = replacmentString
                            
                            if lyr.dataSource.find(oldLoc) != -1:
                                
                                ds = lyr.dataSource.replace(oldLoc, newLoc)

index = ds.find(lyr.datasetName)
                                newds = ds[0:index-1]

if lyr.dataSource.find(".shp") >= 0:
                                    lyr.replaceDataSource(newds, 'SHAPEFILE_WORKSPACE', lyr.datasetName)
                                    outFile.write(fullpath + "	" + "SHP" + "	" + lyr.longName + "	" + groupLayerName + "	" +lyr.name + "	"  + lyr.datasetName + "	" + str(newds) + "	" + "SHP" "
")
                                elif lyr.dataSource.find(".mdb") >= 0:
                                      lyr.replaceDataSource(newds, 'ACCESS_WORKSPACE', lyr.datasetName)
                                    outFile.write(fullpath + "	" + "PGDB" + "	" + lyr.longName + "	" + groupLayerName + "	" +lyr.name + "	"  + lyr.datasetName + "	" + str(newds) + "	" + "PGDB" "
")
                                elif lyr.dataSource.find(".gdb") >= 0:
                                    lyr.replaceDataSource(newds, 'FILEGDB_WORKSPACE', lyr.datasetName)
                                    outFile.write(fullpath + "	" + "FGDB" + "	" + lyr.longName + "	" + groupLayerName + "	" +lyr.name + "	"  + lyr.datasetName + "	" + str(newds) + "	" + "FGDB" "
")
                                                
                    layerFile.save()
                    del layerFile

outFile.close()

#Open the resulting text file
    os.startfile(output)

#Delete variables that reference data on disk
    del outFile
    
except Exception, e:
  import traceback
  map(arcpy.AddError, traceback.format_exc().split("
"))
  arcpy.AddError(str(e))

JeffreyBarrette · Answer

Please provide examples of what you have and what you are trying to go to.

Thanks,
Jeff

jayshukla · Answer

Hi Jeffrey , 
I am having a similar issue and and I am able to set the path to UNC path. The issue that I am getting is with Layer files with nested data sources.

Would you have any input on how to make this happen.

Thanks
Jay  I need to change thousands of LYR files to use relative paths instead of absolute.  Following the example in help I got this:

import arcpy, os
folderPath = r"C:\Testing\ArcGIS10_release\paths"
for filename in os.listdir(folderPath):
    fullpath = os.path.join(folderPath, filename)
    if os.path.isfile(fullpath):
        basename, extension = os.path.splitext(fullpath)
        if extension.lower() == ".lyr":
            lyr = arcpy.mapping.Layer(fullpath)
            lyr.findAndReplaceWorkspacePath (r"C:\Testing\ArcGIS10_release\paths", r"\ Testing\ArcGIS10_release\paths ")
            lyr.save()
del lyr

The paths are coming out as broken when I move them to the same path but a different directory (D:\Testing\ArcGIS10_release\paths).  I think I need to append the file name on the end of the path for this to work - but am not sure how.

Any help?