Latest Contributions by Brian_McLeer

In trying to upgrade code from Python 2 to 3, the below code broke for a calculate field that functioned in 2.x.  I tried putting double quotes around the (' & ') based on some searching, but did not do the trick.      !FullName!.split(' & ')[1].split('/')[0]     The error is: ERROR 000539: Traceback (most recent call last): File "<expression>", line 1, in <module> IndexError: list index out of range Failed to execute (Calculate Field (4)). ... View more

Our organization is migrating SDE Python routines from Python 2.x to Python 3.x that run nightly on a SQL Server machine. In this migration process, we discovered that database replication from  ArcGIS Pro (Python 3.x) does not support replicating geometric networks. We had to create a workaround of deleting the GN into the child database, then copy features from parent to child database.  While we are aware that ArcGIS Pro can only view and not edit geometric networks and that utility networks are the next step, many organizations will be using geometric networks for a while as it will take years to migrate over to the utility network. It would be nice if Python 3.x can function with replicating geometric networks. My understanding it was not until ArcGIS Pro 2.5 or 2.6 that database replication was even available in ArcGIS Pro.  ... View more

In trying to migrate from 2.x to 3.x, I am trying to update a segment of code and my troubleshoot has ran its limits with Google. I am trying to remove domains from fields in various feature classes below. My error, in particular, comes from the image below where the error I get is the 'NoneType' object is not callable.  Full Code: # Comments arcpy.AddMessage("Removing All Domains..." +'\n') txtFile.write("Removing All Domains..." +'\n') #Set workspace environment to geodatabase arcpy.env.workspace = "D:\\WorkSpace\\WebReporter\\Workspace.gdb" myGDB = "D:\\WorkSpace\\WebReporter\\Workspace.gdb" #Get list of feature classes in geodatabase FCs = arcpy.ListFeatureClasses() #Loop through feature classes in list for FC in FCs: #List fields in feature class fields = arcpy.ListFields(FC) #Loop through fields for field in fields: #Check if field has domain if (field.domain != "" and field.domain != 'EnabledDomain' and field.domain != 'AnnotationStatus'): #Print feature class, field, domain name print (FC, field.name, field.domain) arcpy.RemoveDomainFromField_management(FC, field.name) # Get domains that are assigned to a field domains_used = [] for dirpath, dirnames, filenames in arcpy.da.Walk(myGDB, datatype=["FeatureClass", "Table"]): for filename in filenames: print ("Checking {}".format(os.path.join(dirpath, filename))) ## Check for normal field domains for field in arcpy.ListFields(os.path.join(dirpath, filename)): if field.domain: domains_used.append(field.domain) ## Check for domains used in a subtype field # Comments arcpy.AddMessage("I got to here..." +'\n') txtFile.write("I got to here..." +'\n') subtypes = arcpy.da.ListSubtypes(os.path.join(dirpath, filename)) for stcode, stdict in subtypes.items(): if stdict.get('keys')()()("SubtypeField") != u'': for field, fieldvals in stdict.get('keys')("FieldValues").items(): if not fieldvals[1] is None: domains_used.append(fieldvals[1].name) # Get domains that exist in the geodatabase domains_existing = [dom.name for dom in arcpy.da.ListDomains(myGDB)] # Find existing domains that are not assigned to a field domains_unused = set(domains_existing) ^ set(domains_used) print ("{} unused domains in {}".format(len(domains_unused), myGDB)) for domain in domains_unused: arcpy.DeleteDomain_management(myGDB, domain) print ("{} deleted".format(domain) ) # Comments arcpy.AddMessage("Removing All Domains Complete..." +'\n') txtFile.write("Removing All Domains Complete..." +'\n')   ... View more

I have a script from an ArcMap toolbox that updates text elements in the MXD as user input parameters below. I am trying to update this to work in Pro, but I am having trouble finding resources. I have tried updating certain codes in the second snippet below with text in bold.  Original: import arcpy mxd = arcpy.mapping.MapDocument("CURRENT") # Defines Address Element Name SiteName = arcpy.GetParameterAsText(0).upper() Address = arcpy.GetParameterAsText(1).upper() PreplanID = arcpy.GetParameterAsText(2).upper() CrossStreet = arcpy.GetParameterAsText(3).upper() Floor = arcpy.GetParameterAsText(4).lower() # Autopopulate Remaining Text Elements from User Inputs and Cursor search for elm in arcpy.mapping.ListLayoutElements(mxd,"TEXT_ELEMENT"): if elm.name == 'SiteName': elm.text = SiteName elif elm.name == 'Address': elm.text = Address elif elm.name == 'PreplanID': elm.text = PreplanID elif elm.name == 'CrossStreet': elm.text = CrossStreet elif elm.name == 'Floor': elm.text = Floor   Failing update: import arcpy aprx = arcpy.mp.ArcGISProject("CURRENT") # Defines Address Element Name SiteName = arcpy.GetParameterAsText(0).upper() Address = arcpy.GetParameterAsText(1).upper() PreplanID = arcpy.GetParameterAsText(2).upper() CrossStreet = arcpy.GetParameterAsText(3).upper() Floor = arcpy.GetParameterAsText(4).lower() # Autopopulate Remaining Text Elements from User Inputs and Cursor search for elm in arcpy.mp.ListLayoutElements(aprx,"TEXT_ELEMENT"): if elm.name == 'SiteName': elm.text = SiteName elif elm.name == 'Address': elm.text = Address elif elm.name == 'PreplanID': elm.text = PreplanID elif elm.name == 'CrossStreet': elm.text = CrossStreet elif elm.name == 'Floor': elm.text = Floor   ... View more

I have seen questions on GeoNet about this, but not on the idea board. Is there a plan to allow for the creation or updating of RBJ files in ArcGIS Pro? ... View more

When exporting a feature dataset from one DB to another, the schema, features, and domains transfer over. However, attribute rules do not transfer over. Enabling attribute rules to be exported to XML schema and imported would be beneficial when migrating a schema.  ... View more