topic How do I run a Python script inside ArcMap to change datasources in Python Questions

How do I run a Python script inside ArcMap to change datasources

JoseSanchez — Mon, 11 Jun 2018 11:32:11 GMT

Hello everyone,

I need to run the python script below that changes layer datasources inside ArcMap when the mxd is open.

How do I run the script with ArcMap Open?

import arcpy
from arcpy import env
from arcpy import mapping

newDataSource = r"Database Connections\NewSDEConnection.sde"
mapdoc = arcpy.mapping.MapDocument("CURRENT")
#mapdoc.findAndReplaceWorkspacePaths("<the directory you are changing from>" , newDataSource)

for df in mapping.ListDataFrames(mapdoc, "*"):
                    for lyr in mapping.ListLayers(mapdoc, "*", df):

                        try:
                            if lyr.supports("DATASOURCE"):
                                theData = lyr.dataSource
                                print "the Data " + theData
                                theWorkspacePath = lyr.workspacePath
                                print theWorkspacePath

                                if theData.find(".ImageServer") == -1:
                                    if ".sde" in theWorkspacePath.lower():
                                        mxd.findAndReplaceWorkspacePaths(theWorkspacePath,newDataSource,False)


                        except Exception as e:
                            print "The following error has occured:"
                            print e.message

except AttributeError:
pass

mapdoc.save()
del mapdoc

Re: How do I run a Python script inside ArcMap to change datasources

DanPatterson_Retired — Mon, 11 Jun 2018 12:05:50 GMT

Code Formatting the basics... to rule some apparent indentation errors.

Did you open the python window in arcmap and try to run it from there?

Re: How do I run a Python script inside ArcMap to change datasources

MichaelVolz — Mon, 11 Jun 2018 12:37:14 GMT

Are you doing this one mxd at a time? If not, why not use ArcCatalog Set Data Sources tool?

Re: How do I run a Python script inside ArcMap to change datasources

JoseSanchez — Tue, 12 Jun 2018 00:08:07 GMT

Michael, it does not work with ArcCatalog Change Datasource because maps are using a Modling extension and when we tried to change the datasource in ArcMap it reset the model, and the user looses everything. So I am gdoing this one mxd at a time for some specific users.

Where is the Python window in ArcMap? Can I load a python script?

Re: How do I run a Python script inside ArcMap to change datasources

DanPatterson_Retired — Tue, 12 Jun 2018 00:19:42 GMT

What is the Python window?—Help | ArcGIS Desktop covers the basics

Re: How do I run a Python script inside ArcMap to change datasources

Luke_Pinner — Sun, 24 Jun 2018 11:39:34 GMT

You should be able to use `execfile('path/to/script.py')` to run your script from the python window in ArcMap.