Latest Contributions by JaredPilbeam2

We have a new database connection and all our MXDs have to be updated. I ran a script to update the layers on a bunch of MXDs. Then I opened a map, right clicked a layer, properties, then checked under the source tab to see if the changes took place. But, the layer was still referencing the old connection. Is there a snippet I could include in this script, or something else, that verifies that the layers have indeed been updated? There is a print statement in the script, but that just prints the name of the MXD. It doesn't really give concrete proof.  import arcpy import os def find_and_replace(MXD_workspace, oldPath, newPath):     arcpy.env.workspace = MXD_workspace     path = arcpy.env.workspace     for root, dirs, files in os.walk(path):         for name in files:             if name.endswith(".mxd"):                 mxd_name = name                 fullpath = os.path.join(root,name)                 print mxd_name                 print fullpath                 mxd = arcpy.mapping.MapDocument(fullpath)                 for df in arcpy.mapping.ListDataFrames(mxd):                     for flayer in arcpy.mapping.ListLayers(mxd, "*", df):                         if flayer.isFeatureLayer or flayer.isRasterLayer:                             try:                                 mxd.findAndReplaceWorkspacePaths(oldPath, newPath, False)                                 print "Repaired the path for " + name                             except:                                 print(mxd_name + " cannot replace paths")                 mxd.save()                 del mxd     print "complete..." if __name__ == '__main__':     find_and_replace(r"\\gisfile\GISmaps\AtlasMaps\ATLAS_MAPS_18\CountyBoard",                      r"Database Connections\BonnScott.sde",                      r"Database Connections\gisEddy.gissql.sde") #(path2MXDs, path2oldGDB, path2newGDB)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

In this webapp the input data displays in order that a user adds it. Is there a way to alphabetize it? I heard you can do this with the unique ID, but I'm struggling to see how. Here's how the data is displayed as of now: ... View more

I updated from ArcMap 10.4 to 10.5 and now Pythonwin is not opening. Here is the full error message: Traceback (most recent call last):   File "<string>", line 1, in <module>   File "pywin\framework\startup.py", line 49, in <module>     __import__(moduleName)   File "C:\Python27\ArcGIS10.4\Lib\site-packages\pythonwin\pywin\framework\intpyapp.py", line 3, in <module>     import win32con ImportError: No module named win32con ‍‍‍‍‍‍‍ It's looks as though it is because it's still rooted in the ArcGIS 10.4 folder. What is the best way to fix this? ... View more

Is there a way using arcpy to grab feature classes directly from an SDE and copy to a folder? I have a real chunky way to do it, namely using these functions: arcpy.mapping.ListDataFrames() arcpy.mapping.ListLayers() arcpy.mapping.AddLayer() arcpy.FeatureClassToFeatureClass_conversion()‍‍ ‍‍‍‍ The script overall adds features from an SDE to an mxd then saves them as shapefiles in a folder. How can I avoid using the mxd as a sort of springboard? ... View more