findAndReplaceWorkspacePaths for different ArcSDE connections in an mxd

GordonSumerling

Hi,

I am using the findAndReplaceWorkspacePaths for ArcSDE databases in mxd's in a series of folders to update the 3 teir connections to Direct connections. The command I am using is:

mxd.findAndReplaceWorkspacePaths(find_workspace_path=r"", replace_workspace_path=r"C:\Temp\arcsde_DIRECT.sde")

This works fine if I want to replace all the connections in the MXD.

I have the situation though where I have multiple people make mods to the mxd's and have the following list of connections strings:
C:\Documents and Settings\Fred\Application Data\ESRI\ArcCatalog\Direct_vector.sde
C:\Documents and Settings\Fred\Application Data\ESRI\ArcCatalog\Direct_raster.sde
C:\Documents and Settings\Johnathon\Application Data\ESRI\ArcCatalog\Direct_vector.sde
SERVER=production;INSTANCE=port:5152;USER=Johnathon;

Connections 1,3,4 are all the same database while 2 is a different database.

Is there a way I can wildcard search for the direct_vector.sde (1,3,4) connection without Explicitly stating the path? For example:
mxd.findAndReplaceWorkspacePaths(find_workspace_path=r"*\ArcCatalog\Direct_vector.sde", replace_workspace_path=r"C:\Temp\arcsde_DIRECT.sde")

and how can I use the findAndReplaceWorkspacePaths to update the 4th connection?

Cheers
Gordon

JakeSkinner

You can use a wildcard to select the layers, for example by specify the database name.  Below is an example:

lstMXDs = glob.glob(env.workspace + "\\" + "*.mxd")

for mxd in lstMXDs:
    mxd = mapping.MapDocument(mxd)
    for df in mapping.ListDataFrames(mxd, ""):
        lstLayers = mapping.ListLayers(mxd, "*", df)
        for lyr in lstLayers:
            if "vector" in lyr.dataSource:
                print lyr.dataSource
                lyr.replaceDataSource("arcsde_DIRECT.sde", "SDE_WORKSPACE", "")
                print "Successfuly updated data sources"
            else:
                print lyr.dataSource
                lyr.replaceDataSource("RASTER.sde", "SDE_WORKSPACE", "")
                print "Successfully updated data sources"
    mxd.save()
del mxd

I'm using the wildcard "vector" to find all data sources in my VECTOR database and replacing the datasource to my SDE direct connection.  If the layer is not in my VECTOR database, I replace it with a new connection to my RASTER database.

AlexGomez1_0-1771611580639.png