topic Re: How to Set Data Source of a Layer In an MXD From SDE connection in Python Snippets Questions

How to Set Data Source of a Layer In an MXD From SDE connection

BehrouzHosseini — Sun, 12 Dec 2021 09:28:32 GMT

Can you please take a look at this example and let me know how to I can replace Data Source data of a layer in a saved mxd map (Fuse) to a layer called SDEElectric.DBO.Fuse which is in an enterprise geodatabase through database connection

I tried this code but it didnt work

import arcpy
mxd = arcpy.mapping.MapDocument(r"C:\GIS\Maps\Electric.mxd")
src =r"C:\Users\xxx\AppData\Roaming\ESRI\Desktop10.4\ArcCatalog\SDEElectric.sde\SDEElectric.DBO.Dataset\SDEElectric.DBO.Fuse"
df = arcpy.mapping.ListDataFrames(mxd, "")[0]
for lyr in arcpy.mapping.ListLayers(mxd, "", df):
 if lyr.name == "Fuse":
 lyr.replaceDataSource(src, "FILEGDB_WORKSPACE", "")
mxd.save()
del mxd
print "done"‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: How to Set Data Source of a Layer In an MXD From SDE connection

Asrujit_SenGupta — Tue, 29 Aug 2017 05:51:39 GMT

Not a Python expert, but

lyr.replaceDataSource(src, "FILEGDB_WORKSPACE", "")‍‍

Shouldn't the above reflect an Enterprise gdb, like below:

lyr.replaceDataSource(src, "SDE_WORKSPACE", "")‍‍

If the above doesn't help, share the errors you receive and that may also help someone to provide an answer....

Re: How to Set Data Source of a Layer In an MXD From SDE connection

BehrouzHosseini — Tue, 29 Aug 2017 06:04:39 GMT

Thanks Asrujit SenGupta

but still getting same error

Re: How to Set Data Source of a Layer In an MXD From SDE connection

Asrujit_SenGupta — Tue, 29 Aug 2017 06:17:28 GMT

What errors do you receive?

Re: How to Set Data Source of a Layer In an MXD From SDE connection

RebeccaStrauch__GISP — Tue, 29 Aug 2017 15:16:23 GMT

you may want to look at /blogs/myAlaskaGIS/2015/08/31/python-addin-for-data-inventory-and-broken-link-repair?sr=search&searchId=4a7b91b5-3f90-419f-b392-6b2547e79261&searchIndex=6‌ to see samples of how I view and replace sources in mxd. It's based mainly on broken-links, so may not work for you, but just in case.

Re: How to Set Data Source of a Layer In an MXD From SDE connection

BehrouzHosseini — Tue, 29 Aug 2017 15:20:39 GMT

Thanks Rebecca, I already spend some time there but it was not really helpful as it mainly focus was on fixing broken links