nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Arc Py - Find Broken Data Sources For All Folders

AngeloLelekis

I just downloaded the arcpy.mapping sample script tools and was testing the Find Broken Data Sources Tool. It works great, however I was wondering if anyone knows how to search subfolders, or all folders on a drive for broken data sources?

We have many subfolders on our server and it would be a lot more efficient if I can run one report for the whole server instead of going several folders deep to the project level and then having to run countless reports. Any help would be greatly appreciated!

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

ChrisFox3

Thank you for the information, I think the next best step would be for you to log this issue with Technical Support so that the issue can be narrowed down further and potentially get a bug logged.

SebastianPawlak

I'm going from a .gdb to an SDE.

- I'm running ArcInfo 10 SP3 on my client; and
- ArcSDE 9.3 (not sure of the service pack) on the server.

ChrisFox3

Interesting, it may be a bug. I tested with some of my own data and your code and could not reproduce the issue, everything updated as expected. What workspace type are you going from for the layers you are updating? What version of SDE and DBMS are you going to?

SebastianPawlak

Hi Chris,

I've crafted this script to skip MXDs that have no broken links. Since the script only works through the first iteration I am forced to run the script multiple times until all my MXDs have their data sources fixed. Each time I run this script, the previously fixed MXD is skipped.

So, the issues seems to be with the "replaceDataSources" line only. It's as though this function is locked in the first iteration.

ChrisFox3

Based on your code and the exception I don't think there is a coding error that is causing this problem. My recommendation would be to try to isolate the MXD and the layer that this exception is being raised for and try to simplify the code to just run once on that MXD and layer. If you can reproduce the error, look into the layer and see if there is anything that might cause your code to fail.

For example does the brknItem.datasetName exist in the new workspace you are trying to update the dataset to or is the dataset type appropriate for the layer you are trying to update.

SebastianPawlak

The error I am getting is:

brknItem.replaceDataSource(workspace, "SDE_WORKSPACE", item)
File "C:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy\arcpy\utils.py", line 181, in fn_
    return fn(*args, **kw)
File "C:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy\arcpy\_mapping.py", line 585, in replaceDataSource
    return convertArcObjectToPythonObject(self._arc_object.replaceDataSource(*gp_fixargs((workspace_path, workspace_type, dataset_name, validate), True)))
ValueError: Layer: Unexpected error

ChrisFox3

What is the exact text in the exception that is raised?

SebastianPawlak

I would like to use this code, but it only works through the first iteration. Can someone find my error?

My error handlers catch errors only in this code block:

                    try:
                        brknItem.replaceDataSource(workspace, "SDE_WORKSPACE", item)
                        print "\t item successfully replaced"
                    except:
                        print "\t error occured replacing layer"

Code is pasted below:

# Import arcpy module
import arcpy, os

dir = "path to mxd files"
workspace = "path to new datasource"


for file in os.listdir(dir):

    if file.startswith("Sector"):
        file = os.path.join(dir, file)
        print "\n\n" + file
        mxd = arcpy.mapping.MapDocument(file)
        brknList = []
        brknList = arcpy.mapping.ListBrokenDataSources(mxd)

        if len(brknList) > 0:
            print "\nlist of broken data sources: "
            for lyr in brknList:
                print "\t" + lyr.datasetName

            print "\nreplacing layers"
            for brknItem in brknList:
                if brknItem.datasetName != "EPOISicCodeTABLE":
                    arcpy.AddMessage("\t" + brknItem.datasetName)
                    print "\t" + brknItem.datasetName

                    item = brknItem.datasetName

                    try:
                        brknItem.replaceDataSource(workspace, "SDE_WORKSPACE", item)
                        print "\t item successfully replaced"
                    except:
                        print "\t error occured replacing layer"
                        print arcpy.GetMessages(2)

        try:
            mxd.save()
        except:
            print "\t an error occured w/ saving %s" % file

        print "done"

        del mxd

AngeloLelekis

Thanks Chris! Sorry for the delay in responding. This is exactly what I needed.

ChrisFox3

Try this:

import arcpy,os

for dirname, dirnames, filenames in os.walk(r"C:\Temp"): 
    for filename in filenames: 
        path = os.path.join(dirname, filename)
        basename, extension = os.path.splitext(path)
        if extension == ".mxd":
            mxd = arcpy.mapping.MapDocument(path)
            print "MXD: " + path
            brknList = arcpy.mapping.ListBrokenDataSources(mxd)
            for brknItem in brknList:
                print "\t" + brknItem.name
            del mxd

-Chris

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.