Latest Contributions by MichaelVolz

‎02-03-2012

Thanks Jake. Do you have any idea why I need to employ this more complicated workaround than your original simpler code?

‎02-03-2012

Jake: Do you think it might matter how the SDE connection is broken? I created a new SDE version owned by myself off the default version. I added data from SDE with this version to an mxd and saved the mxd. I then deleted the SDE version in ArcCatalog which breaks the link. I then ran my python script on this mxd with the broken SDE link.

‎02-03-2012

Jake: As requested, here is my code that returns different results from your code: import os, arcpy, sys from arcpy import env env.overwriteOutput = True mxd_match = ".mxd" for root, dirs, files in os.walk(arcpy.GetParameterAsText(0)): fListLength = len(files) if (fListLength != 0): n = 0 for f in files: if f.endswith(mxd_match): full_path = root + "\\" + str(f) try: mxd = arcpy.mapping.MapDocument(full_path) broken = arcpy.mapping.ListBrokenDataSources(mxd) for n in broken: for lyr in arcpy.mapping.ListLayers(mxd, n): arcpy.AddMessage("The broken SDE layer dataSource is " + lyr.dataSource) del mxd except: print arcpy.GetMessages(2)

‎02-03-2012

Jake: I modifed my code slightly to duplicate your code and I am still receiving dataSource property for an SDE feature class was \'feature class dataset name.feature class name' (e.g. ADMIN_BOUNDARIES.MUNIS) instead of something like Database Connections\SDEConnection.sde\vector.VECTOR.ap for an SDE broken link. I was able to get the dataSource property in your format if I called this property from an SDE feature class that was not broken, so I'm guessing that the dataSource property works differently if the SDE connection is broken. Should I place a call with ESRI Technical Support for further assistance with this issue? Thanks.

‎02-03-2012

Jake: The following code did not work for me to identify an SDE feature class because '.sde' did not appear in the dataSource property that I printed out to the progress window. Are you sure '.sde' is supposed to be in the dataSource property for an SDE feature class? All that showed up in the dataSource property for an SDE feature class was \'feature class dataset name.feature class name'. mxd = arcpy.mapping.MapDocument("C:\TEMP\python\Airports.mxd") broken = arcpy.mapping.ListBrokenDataSources(mxd) for n in broken: for lyr in arcpy.mapping.ListLayers(mxd, n): if '.sde' in lyr.dataSource: print lyr.name del mxd.

‎02-03-2012

To All Python Users: I am using the ListBrokenDataSources method in python to get all the broken datasources in an mxd. Now I want the ability to determine the type of connections, specifically SDE, that the broken links are. I tried to loop through the list of broken data source layers and use the serviceproperties method to determine if it was SDE, but that is returning an error. Does anyone know if this can be done? If so, what python method would I use to go about getting this information. Thanks.

‎01-17-2012

Jeff: Do you have to use mxd.saveACopy(r"C:\Project\Project2.mxd") in order for this script to replace the datasource? I would like to create a similar python script, but I do not want to create an additional copy of the file as users could have short-cuts on their desktops to the mxd which would now be broken. Can I just overwrite the existing mxd instead of creating a new mxd? Your feedback is greatly appreciated. Thanks. Mike

‎01-12-2012

Jeff: Does ESRI have a tentative date of when service pack will be available to all users? Does this push back the date of release of ArcGIS v10.1? Your feedback is greatly appreciated. Thanks.

‎06-28-2011

Joel: You wrote "We're currently using Oracle database 10.2.0.4, but I have both Oracle 10 and Oracle 11 clients on my machine, and I can use either version of the client and still get the same results for the things we do." When you are connecting to Oracle database 10.2.0.4 thru the Oracle 11 client, you are not able to access new Oracle 11 functionality, correct? The only way to get Oracle 11 functionality is to have both the database and client upgraded to the 11 version, correct?

‎06-28-2011

Joel: My organization should be able to leave the Oracle10g connection information intact if we upgrade the Oracle server to 11g, but leave the clients at 10g? Is there new functionality of Oracle11g that would not be available if we leave Oracle Client at 10g on the client machines? Is the Oracle10g Client compatible with Oracle 12g, so we would be able to leave the connection information as is with an upgrade of Oracle Server to 12g? Your help and feedback is greatly appreciated. Thanks.

‎06-28-2011

To All ArcSDE Users: My organization is in the process of upgrading the Oracle database from 10g to 11g. As a result the Direct Connection information will need to be changed on tens of thousands of connections within our mxds, because the Service parameter needs to be changed from sde:oracle10g to sde:oracle11g. In order to avoid this vast amount of work in the future, I was wondering if this information can be stored as an Environmental Variable that would be read in when the mxd is opened up. In this way, when my organization upgrades the Oracle database in the future, only the Environmental Variable would need to be modified. Any help or hints are greatly appreciated. Thanks in advance.

‎06-10-2011

To All Flex API Developers: I have a Reverse Proxy environment setup to allow a GIS web application to be accessible to the general public. Using the FlexViewer, I needed to use the crossdomain.xml file to allow the web application through the Reverse Proxy server. My question is do I need to also use a crossdomain.xml file when I am using the Flex API? Any help or hints are greatly appreciated. Thanks.

‎06-07-2011

To usmanaleem: I did not mention it in the post, but I also tried with the /s at the end and the dialog box still popped up. In addition, I thought the /s would only stop the success pop-up box from appearing indicating whether the dll was registered successfully or not. To agray1: I tried with the version set to 10.0 as you mention, but the dialog box still appears. Can either of you see the behavior of registering this dll without the dialog box appearing on your machines? Thanks for your assistance.

‎06-06-2011

To All ArcGIS Developers: I have watched an ESRI Deployment video as well as read ESRI v10 Resource Help and I created a bat file as follows which should just register a dll on a machine where ArcGIS Desktop is installed: C:\Program Files\Common Files\ArcGIS\bin\ESRIRegAsm.exe C:\GIS_Testing\Test_Editor\Register_Testing\County.GIS.TestEditor.dll /p:desktop When I run this bat file a dialog box pops up asking me which Registered ArcGIS installation I want to register this dll with. I thought I already specified this option with the "/p:desktop" parameter. Why is this option ignored? I first ran the following bat file to create a reg file to be installed with the custom application: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\RegAsm.exe C:\GIS_Testing\Test_Editor\Register_Testing\County.GIS.TestEditor.dll /p:desktop /codebase /regfile:C:\GIS_Testing\Test_Editor\Register_Testing\County.GIS.TestEditor.dll.reg The dialog box also pops up here asking which Registered ArcGIS installation I want to register this dll with? Again I had supplied this parameter so I do not understand why the software is still asking me for this information? Any help you can provide is greatly appreciated. Thanks.

‎06-02-2011

To All ArcGIS Developers: I have taken over the editing of a .NET application that I need to upgrade to work in v10. The exe file from the code currently works in ArcGIS v9.3.1. When I open the sln in Visual Studio and check the references it says that it can not find this dll. Does anyone know where I would find this dll as I thought Visual Studio is able to find references on the development machine? I have the Desktop Developer kit and VBA Developer Resources installed on this machine. Any help or hints are greatly appreciated. Thank you.

Online Status	Offline
Date Last Visited	yesterday

My Ideas

Latest Contributions by MichaelVolz

Re: Determine Broken SDE Connections

Re: Determine Broken SDE Connections

Re: Determine Broken SDE Connections

Re: Determine Broken SDE Connections

Re: Determine Broken SDE Connections

Determine Broken SDE Connections

Re: Replace data sources from one sde to another

Re: Replace data sources from one sde to another

Re: Direct Connect Parameter Stored as Environmental Variable

Re: Direct Connect Parameter Stored as Environmental Variable

Direct Connect Parameter Stored as Environmental Variable

Crossdomain.xml for Flex API

Re: Register Dll with ESRIRegAsm.exe

Register Dll with ESRIRegAsm.exe

Cannot Find ESRI.ArcGIS.DataSourcesGDB Reference

Re: ArcGIS Pro and using Teams for File Storage

Re: Using Append in Python is suddenly requiring a...

Re: Satellite photos from 1984 of local DE address...

Re: Issue with Importing Procedure Data into AIS S...

Re: Error cloning python environment