Help with repairing data source

Question

Hi,

I have been trying to get this code to work for the last couple of hours, if anyone could give me some help that would be great.

I would like to repoint any broken links to a new table that lies within a personal geodatabase. The code I have is:

import arcpy, os
path = r"N:\Temporary_Work\Oliver Morris\EDCOLLINS_ISOPACH"
for fileName in os.listdir(path):
    fullPath = os.path.join(path, fileName)
    if os.path.isfile(fullPath):
        basename, extension = os.path.splitext(fullPath)
        if extension == ".mxd":
            mxd = arcpy.mapping.MapDocument(fullPath)
            print "MXD: " + fileName
            brknList = arcpy.mapping.ListBrokenDataSources(mxd)
            for brknItem in brknList:
                 lyr.replaceDataSource (r" N:\Temporary_Work\mapping_2011.mdb",        "ACCESS_WORKSPACE", SEA_110617)
                 print "	" + brknItem.name
del mxd

When I run this I get the error - Runtime error <type 'exceptions.NameError'>: name 'SEA_110617' is not defined

Can you please point me in the right directions.

Thanks,

Oliver

JeffreyBarrette · Answer

The error message says it all "lyr" not defined.

You have lyr.replaceDataSource when it should be brknItem.replaceDataSource

Jeff

OliverMorris · Answer

Hi,

Thank you for your continued help with this. I ran your code but it returned an error any idea why.

Many Thanks,

Oliver

>>> import arcpy, os
... path = r"N:\Temporary_Work\Oliver Morris\EDCOLLINS_ISOPACH"
... for fileName in os.listdir(path):
...     fullPath = os.path.join(path, fileName)
...     if os.path.isfile(fullPath):
...         basename, extension = os.path.splitext(fullPath)
...         if extension == ".mxd":
...             mxd = arcpy.mapping.MapDocument(fullPath)
...             print "MXD: " + fileName
...             brknList = arcpy.mapping.ListBrokenDataSources(mxd)
...             for brknItem in brknList:
...                 if brknItem.supports("DATASOURCE"):
...                     lyr.replaceDataSource(r" N:\Temporary_Work\Oliver Morris\EDCOLLINS_ISOPACH\Isopach_mapping_2011.mdb","ACCESS_WORKSPACE","SEA_ODM_ISOPACH_110617")
...                     print "	" + brknItem.name
... del mxd
... 
MXD: ISOPACH_EDIT1_EDCOLLINS.mxd

Runtime error <type 'exceptions.NameError'>: name 'lyr' is not defined

JeffreyBarrette · Answer

That is most likely because you have a layer type (e.g., group layer) that doesn't support "replaceDataSource".  You should look at the help topic for layers, specifically the "supports" parameters.  It explains all of this.  I modified the code below (and removed an unnecessary if statement).import arcpy, os
path = r"N:\Temporary_Work\Oliver Morris\EDCOLLINS_ISOPACH"
for fileName in os.listdir(path):
    fullPath = os.path.join(path, fileName)
    if os.path.isfile(fullPath):
        basename, extension = os.path.splitext(fullPath)
        if extension == ".mxd":
            mxd = arcpy.mapping.MapDocument(fullPath)
            print "MXD: " + fileName
            brknList = arcpy.mapping.ListBrokenDataSources(mxd)
            for brknItem in brknList:
                if brknItem.supports("DATASOURCE"):
                    lyr.replaceDataSource(r" N:\Temporary_Work\Oliver Morris\EDCOLLINS_ISOPACH\Isopach_mapping_2011.mdb","ACCESS_WORKSPACE","SEA_ODM_ISOPACH_110617")
                    print "	" + brknItem.name
del mxd