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

Single MXD Broken SDE Links

lelaharrington

i have a mxd that has broken SDE links ( well i have a lot of them) i am fine running a script one mxd at a time to repair the broken sources. some of the features are now in feature classes, to clean up the SDE location. some are still there. how do i write a script that will look to the mxd i want it to and repair the SDE connection to find the feature.

also if the feature had been renamed how do i tell the the script to look for (old) and replace with (new)

i have looked at the generic "repair broken sources script" and i just cannot wrap my head around how to use this.

タグ付けされた投稿をもっと見る

Accepted answers

All comments

RebeccaStrauch__GISP

I just posted a python addin Python addin for data inventory and “broken-link” repair. If nothing else, using the first three tools will help you see all the FGDBs, feature classes, and broken links.

There is no such thing as a once size fits all when it comes to fixing broken links, but this can fix changing types, changing paths, updating .sde and .ags layers, etc. The repair requires a modified .csv file that is output from the broken link tool. I do not have any good samples of the file yet, but will try to get something posted by end of business.

lelaharrington

yes! that is the script i am using however the part on it that says mxd.findAndReplaceWorkspacePaths(r"C:\Project\Old Connection.sde..."

that is the part i cannot seem to get right. if my SDE is a database connection in arc catalog how to i write the C:\Project. part?

JakeSkinner

You would need to write something like below:

<SPAN class="kn">import</SPAN> <SPAN class="nn">arcpy</SPAN>
<SPAN class="n">mxd</SPAN> <SPAN class="o">=</SPAN> <SPAN class="n">arcpy</SPAN><SPAN class="o">.</SPAN><SPAN class="n">mapping</SPAN><SPAN class="o">.</SPAN><SPAN class="n">MapDocument</SPAN><SPAN class="p">(</SPAN><SPAN class="s">r"C:\Project\Project_default.mxd"</SPAN><SPAN class="p">)</SPAN>
<SPAN class="n">mxd</SPAN><SPAN class="o">.</SPAN><SPAN class="n">findAndReplaceWorkspacePaths</SPAN><SPAN class="p">(</SPAN><SPAN class="s">r"C:\Project\Old Connection.sde"</SPAN><SPAN class="p">,</SPAN> <SPAN class="s">r"C:\Project\New Connection.sde"</SPAN><SPAN class="p">)</SPAN>
<SPAN class="n">mxd</SPAN><SPAN class="o">.</SPAN><SPAN class="n">save</SPAN><SPAN class="p">(</SPAN><SPAN class="p">)</SPAN>
<SPAN class="k">del</SPAN> <SPAN class="n">mxd</SPAN>

lelaharrington

i have and i honestly cant understand it.

i have the connection it needs to go to and the connection it came from but i an not sure how to actually write it

JakeSkinner

Hi Lela,

Have you taken a look at the following help doc?

Updating and fixing data sources with arcpy.mapping—Help | ArcGIS for Desktop

This will give you script examples for different scenarios.

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

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