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; } } }

Change Data Source to new GDB

StuartBlumberg

Hello,

All I want to do is change the data source of all layers of all MXDs in a single folder from one FGDB to another. For example I want the data sources to be changed from "Project.gdb" to "Project2010.gdb"

I've tried all the python code from the help topics and can't seem to get the right script.

Thanks.

Vind meer berichten getagd met

Accepted answers

All comments

RDHarles

How does it know which folder the MXDs are in?

How are you running your scripts? (ArcToolBox, Pythonwin, command line, etc).
More than likely you just need to set the arcpy.env.workspace to where your .py scripts are.
e.g. arcpy.env.workspace = "c:/temp"
[I run my scripts from a windows command line so the workspace is always my current directory.]

What if the MXDs are in a different folder than the GDB?

Shouldn't matter as long as you use the correct replace path:
MapDocument.findAndReplaceWorkspacePaths(find_workspace_path, replace_workspace_path)

StuartBlumberg

Harles,

How does it know which folder the MXDs are in? What if the MXDs are in a different folder than the GDB? Thanks.

RDHarles

Try this, worked for me...:

import arcpy, os

# Set current workspace
arcpy.env.workspace = os.getcwd()

# For every mxd in the current directory
for mxd in os.listdir(''):
    if mxd.endswith('.mxd'):
        print "Changing paths in "+mxd+"..."
        mxd = arcpy.mapping.MapDocument(mxd)
        # Note: Back slashes seemed to be required for it to work.
        mxd.findAndReplaceWorkspacePaths(r"c:\junk\fgdb\python\b.gdb", r"c:\junk\fgdb\python\a.gdb")        
        mxd.save()
del mxd

StuartBlumberg

rdharles,

If I have multiple MXDs in a folder and I need to change them all at once how would I do this?

RDHarles

You can do it with python, but if you just have one mxd to fix, simply right-click on the mxd in ArcCatalog, click "Set Data Source(s)...", then click the "Select All" then the "Replace All" buttons. Finally, type the name of the new FGDB and save the mxd.

StuartBlumberg

I've gone through those examples multiple times, trying different variations to get it to change the FGDB with no luck. My problem is I don't know Python enough to correctly format the code. Is there code out there specifically for my purpose?

DonovanCameron

I need to change from one FGDB to another.

I am pretty sure you can, the script just needs to be modified to do so.

Look at the help on the syntax for Updating and fixing data sources with arcpy.mapping

Go down to the Usage section and find the header(s):
Data is migrated from one workspace type to another workspace type

Individual datasets are moved in and out of feature datasets

Also look at the Known Limitations in regards to these specific processes. They will offer pointers on writing your script with that you can and cannot do currently.

StuartBlumberg

The forum link you provided is for changing the data source from one folder path to another. I need to change from one FGDB to another.

DonovanCameron

There is a related forum on changing the data source using python.

There is a script offered there from the Resource Center, also note, that these scripts are offered as examples already installed as part of v10 in the toolbox.

Did that referred forum offer you your solution?

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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