topic Re: Replace parts of a data source string in Layer files? in Python Questions

Replace parts of a data source string in Layer files?

JohannesBierer — Sun, 12 Dec 2021 04:10:03 GMT

Why does this code replace only things like c:\temp\data through c:\tempXXX\data and not the beginning of c:\temp\data\1\2\3 ?

import arcpy, os
# Pfade definieren
folderPath = r"R:\SG-C\8850.20-6 FFH-Gebiete\04 MaP\7218-341_Calwer_Heckengaeu"
oldPath = r"R:\natura 2000\8847.04 MaP\7218-341_Calwer_Heckengäu"
# mxd definieren
path = r"R:\SG-C\8850.20-6 FFH-Gebiete\04 MaP\7218-341_Calwer_Heckengaeu\7218341.mxd"
mxd = arcpy.mapping.MapDocument(path)  
for df in arcpy.mapping.ListDataFrames(mxd):  
    for lyr in arcpy.mapping.ListLayers(mxd): 
        print (lyr)
        lyr.findAndReplaceWorkspacePath(oldPath, folderPath, "")
arcpy.RefreshTOC()  
arcpy.RefreshActiveView()  
mxd.save
del mxd

Re: Replace parts of a data source string in Layer files?

Zeke — Tue, 10 Feb 2015 21:04:18 GMT

I think you may want ListLayers(df), not ListLayers(mxd).

Re: Replace parts of a data source string in Layer files?

JoshuaBixby — Tue, 10 Feb 2015 21:28:56 GMT

You can't pass ListLayers only a dataframe object, it will fail. At a minimum, and map document or layer needs to be passed. That said, the code still has an issue.

Re: Replace parts of a data source string in Layer files?

JoshuaBixby — Tue, 10 Feb 2015 21:35:09 GMT

I am not understanding your predicament. Could you post a screenshot or some specific examples of what you would like to see and what you are actually seeing?

Regarding your code, you don't have to loop over the dataframes if you aren't going to pass them to ListLayers. Calling ListLayers without a dataframe object will list the layers in all of the dataframes.

Re: Replace parts of a data source string in Layer files?

JohannesBierer — Wed, 11 Feb 2015 06:37:57 GMT

Ok, the code was working to replace c:\temp\data through c:\tempXXX\data. But not if there are more subfolders like c:\tempYYY\datax\dataY\dataZ it failed?

Have tested it with only listlayer. Somehow it steps out. After printing Projektgewaesser ..

File "C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy\arcpy\_mapping.py", line 695, in findAndReplaceWorkspacePath

return convertArcObjectToPythonObject(self._arc_object.findAndReplaceWorkspacePath(*gp_fixargs((find_workspace_path, replace_workspace_path, validate), True)))

ValueError: Layer: Unexpected error

Re: Replace parts of a data source string in Layer files?

XanderBakker — Sun, 12 Dec 2021 04:10:05 GMT

I see the oldPath has "ä" in the name. Python normally doesn't like that and other functions may not work well with these type of characters (for instance working with the raster calculator). Personally I would reconsider if the path should be named like this (also spaces, points, dashes, etc will be a sources or problems when working with rasters calculations).

oldPath = r"R:\natura 2000\8847.04 MaP\7218-341_Calwer_Heckengäu"

You may have to use the next line as first line in your script:

# -*- coding: utf-8 -*-

If that doesn't work, maybe you should enclose your script by:

import sys
reload(sys)
# read system settings and set utf8
def_enc = sys.getdefaultencoding()
sys.setdefaultencoding('utf8')

# script logic goes here ...

# restore settings
sys.setdefaultencoding(def_enc)

But my recommendation is to reconsider the folder names

Re: Replace parts of a data source string in Layer files?

Zeke — Wed, 11 Feb 2015 13:13:15 GMT

Yes, that's correct, my bad. ListLayers(mxd, "", df) would be more correct.