slowe

findAndReplaceWorkspacePaths Not Working AND using Python to re-join tables

Discussion created by slowe on Apr 29, 2012
Latest reply on Apr 30, 2012 by jbarrette-esristaff
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

Outcomes