findAndReplaceWorkspacePaths Not Working AND using Python to re-join tables

ShanaLowe — Sun, 29 Apr 2012 11:58:30 GMT

I am trying to use the Python findAndReplaceWorkspacePaths function, but apparently am doing something wrong. We recently rebuilt our SDE database and moved the data to a new user (was owned by SDE, which I know is a big no-no, so we moved the data to a different user). The FC names are the same, server is the same. Can anyone help me figure out what I am doing wrong? I was also wondering if there is a Python method for fixing the table joins that are lost now that the data is oned by the new user.
Thanks in advance for any help.

import arcpy
mxd = arcpy.mapping.MapDocument(r"B:\Temp\PYTHON\Test.mxd")
mxd.findAndReplaceWorkspacePaths(r"Database Connections\Connection to MVNPUSH as SDE.sde",
r"Database Connections\Connection to MVN as EDITOR.sde")
mxd.saveACopy(r"B:\Temp\PYTHON\Test2.mxd")
del mxd

Re: findAndReplaceWorkspacePaths Not Working AND using Python to re-join tables

JeffBarrette — Mon, 30 Apr 2012 16:18:36 GMT

Have you tried mxd.replaceWorkspaces? MXD.findAndReplaceWorkspacePaths doesn't work as well for changing owner information.

Jeff

topic Re: findAndReplaceWorkspacePaths Not Working AND using Python to re-join tables in Python Questions

findAndReplaceWorkspacePaths Not Working AND using Python to re-join tables

Re: findAndReplaceWorkspacePaths Not Working AND using Python to re-join tables