replace data sources script not returning to for loop

Question

Original User: jgustine

I am having a problem with the attached script and was hoping someone sees something I don't. We did a large data migration from shapefiles in a fileshare to a single SDE database for one of our customers. My goal is to automate the repathing process with script that loops thru the MXD directories and uses the replaceDataSource method to insert the new data sources.

The attached script reads from a text file (also attached) to check for and change data source info. It sucessfully runs thru and replaces the 1st layer in each map document, but will not continue to the next?

Anyone see any syntax/indentation problems. Thanks

BatchReplaceDataSources_fromTxt2.py.zip

DOEREPATHTEST.txt.zip

3D_cityscape.png

appl_3D.png

ChristinaGnadinger · Answer

Any help someone could give me would by most appreciated!

I've replied with a few kinks I'm having here .. http://forums.arcgis.com/threads/49038-replaceDataSource-connecting-to-SDE-Instance?p=168862&viewfull=1#post168862

Anonymous User · Answer

Original User: cgnadinger

I am working on this right now and was having issues with the Database Connection to our servers.

This is working for the initial layer but I'm struggling with additional layers .. but it's progress further than where I was at least.

If you're still interested, I took this a little farther, maybe overkill but...

It will use a text file for input or from command line. It will also walk a directory structure.

c:\Temp>cls && python changedatasource.py --help to see the options.

Text file looks like:
# Layername or Source, Layername or SourcePath, Connect To, Featureclass
Layername,Artwork,Database Connections\PublicUser.sde,SDE.Artwork
Source,C:\Documents and Settings\user\Application Data\ESRI\ArcCatalog\publicuser.sde\SDE.BaseMap\SDE.Call_Box,Database Connections\user.sde,SDE.Call_Box

Syntax for file input would be:
c:\Temp>cls && python changedatasource.py --dirpath c:	emp --norecurse --infile c:	empeplace.txt --filelist c:	emp	est.mxd

Syntax for command line would be:
c:\Temp>cls && python changedatasource.py --dirpath c:	emp --norecurse --filelist c:	emp	est.mxd --dest "Layername,Artwork,Database Connections\PublicUser.sd
e,SDE.Artwork" --force

A note about the sample syntax. If --filelist is specified, --dirpath and --norecurse are ignored.

Anonymous User · Answer