Latest Contributions by JakeSkinner

Hi thanks very much for the reply. Could I use that script with the following folder references removed so that all folders in M:\Planning\ and F:\ are replaced or do I have to do it by individual folder? import arcpy, os from arcpy import env workspace = env.workspace = r"C:\Temp\Python"  mxdList = arcpy.ListFiles("*.mxd")  for mxd in mxdList:     mxd2 = workspace + os.sep + mxd     mapdoc = arcpy.mapping.MapDocument(mxd2)     mapdoc.findAndReplaceWorkspacePaths(r"M:\Planning\", r"M:\Directorates\Planning\")     mapdoc.findAndReplaceWorkspacePaths(r"F:\", r"M:\Directorates\Planning\")     mapdoc.save()  del mapdoc Also do I have to enter that script into all current .mxd files or can it be entered directly into ArcGIS just once? Thanks again Yes, this is possible, but takes a little bit more coding.  Here's an example: import arcpy, os from arcpy import env from arcpy import mapping workspace = env.workspace = r"F:"  mxdList = arcpy.ListFiles("*.mxd")  for mxd in mxdList:     mxd2 = workspace + os.sep + mxd     mapdoc = arcpy.mapping.MapDocument(mxd2)     for df in mapping.ListDataFrames(mapdoc):         for layer in mapping.ListLayers(mxd, "", df):             if "F:\\" in layer.dataSource:                 origPath = layer.dataSource.split("\\")                 origPath2 = ""                 for x in origPath[0:-1]:                     origPath2 += x + os.sep                 origPath2 = origPath2[0:-1]                 dataSource = layer.dataSource.strip("F:\\")                 dataSource = dataSource.split("\\")                 path = ""                 for y in dataSource[0:-1]:                     path += y + os.sep                 path = path[0:-1]                 mapdoc.findAndReplaceWorkspacePaths(origPath2, r"M:\Directorates\Planning" + os.sep + path)             elif "M:\\Planning\\" in layer.dataSource:                 origPath = layer.dataSource.split("\\")                 origPath2 = ""                 for x in origPath[0:-1]:                     origPath2 += x + os.sep                 origPath2 = origPath2[0:-1]                 dataSource = layer.dataSource.strip("M:\\Planning\\")                 dataSource = dataSource.split("\\")                 path = ""                 for y in dataSource[0:-1]:                     path += y + os.sep                 path = path[0:-1]                 mapdoc.findAndReplaceWorkspacePaths(origPath2, r"M:\Directorates\Planning" + os.sep + path)     mapdoc.save()  del mapdoc I have not tested this extensively, but had a similar version of this script work successfully.  Also, this will need to be only executed once.  The script will loop through all MXDs in the workspace directory: workspace = env.workspace = r"F:" In the above example, it will find all the MXDs on the F drive.  You can update this to the folder location where your MXDs are. ... View more

Hi Numa, I'm not sure if you can use a wildcard with the replace method.  The method will read everything within quotes as a string.  Try the following instead: Pre-Logic Script Code: def replace(field):   if "_" in field:     return field.split("_")[0]   else:     return field Under the code block: replace(<fieldname>) Note:  Be sure 'Python' is checked at the top of the Field Calculator ... View more

Hi Tim, You could accomplish this using Python.  Here is an example: import arcpy from arcpy import env env.workspace = r"C:\temp\python\Test.sde"  lstDatasets = arcpy.ListDatasets("*") for dataset in lstDatasets:     lstFCs = arcpy.ListFeatureClasses("*", "", dataset)     for fc in lstFCs:         lstFields = arcpy.ListFields(fc)         for field in lstFields:             if field.domain:                 print fc, field.name, field.domain What this code does is loop through all feature classes in the 'Test' SDE geodatabase and, if a domain is present, prints out the feature class name, the field name that contains the domain, and the domain name. ... View more

Hi Kevin, You have tbl declared as a variable, and then you declare it as a string with the SearchCursor.  Try the following: import arcpy  d = {} tbl = r'E:\gis\forestry\20120711_forestryWebApp\temp.gdb\wholeCity' with arcpy.da.SearchCursor(tbl, ['rangeClass', 'count']) as c:     for r in c:         print r[0], r[1]         #d[r[0]] = r[1]      print d ... View more