Latest Contributions by Brian_McLeer

‎07-29-2021

When publishing branch versioned data for the first time changing from traditional versioning, allow for required fields to be turned on by the right-click option in the 'Share As Web Layer' pane. I received 465 errors which I have to go into each layer and turn on all fields that are required to be turned on to publish branch versioned data to Portal. Being able to select the errors, right-click and choose 'turn on field' would be a great improvement.

‎07-29-2021

Had to make some updates, but the below solution worked. fc = "D:\\WorkSpace\\Water\\Workspace.gdb\\NewAccountsGeocoded" fields = ['USER_MunisAccount','IN_Single_Line_Input'] qry = "Status NOT IN ( 'M', 'T')" with arcpy.da.SearchCursor(fc, fields, qry) as cursor: for row in cursor: print(row [0], row [1]) txtFile.write("{0}{1}".format(arcpy.GetMessages(), '\n')) HOST = "server.domain.com" SUBJECT = "Report: Unable to Add UB Accounts to GIS Accounts" TO = "symon@email.com", "dave@email.com", "brian@email.com" FROM = "Water Accounts<GIS@email.com>" text = "The following UB Account was not able to be imported into GIS WtrAccounts. Please see if there is an error in UB or if the address exists in COH Address GIS feature class. \n " + "UB Account: "+str(row[0]) + " | UB Address: "+str(row[1])+"\n" BODY = "From: {1}{0}To: {2}{0}Subject: {3}{0}{0}{4}".format('\r\n', FROM, TO, SUBJECT, text) server = smtplib.SMTP(HOST) server.sendmail(FROM, TO, BODY) server.quit()

‎07-28-2021

So I got the code to work and email to a single address like the commented out line 11, but in trying to send to multiple email addresses like in line 10 it fails with the error message below. unhashable type: 'list' fc = "D:\\WorkSpace\\Water\\Workspace.gdb\\NewAccountsGeocoded" fields = ['USER_MunisAccount','IN_Single_Line_Input'] qry = "Status NOT IN ( 'M', 'T')" with arcpy.da.SearchCursor(fc, fields, qry) as cursor: for row in cursor: print(row [0], row [1]) txtFile.write("{0}{1}".format(arcpy.GetMessages(), '\n')) HOST = "server.email.com" SUBJECT = "Report: Unable to Add UB Accounts to GIS Accounts" TO = ["symon@email.com","dave@email.com","brian@email.com"] #TO = "brian@email.com" FROM = "Water Accounts<GIS@email.com>" text = "The following UB Account was not able to be imported into GIS WtrAccounts. Please see if there is an error in UB or if the address exists in COH Address GIS feature class. \n " + "UB Account: "+str(row[0]) + " | UB Address: "+str(row[1])+"\n" BODY = "From: {1}{0}To: {2}{0}Subject: {3}{0}{0}{4}".format('\r\n', FROM, TO, SUBJECT, text) server = smtplib.SMTP(HOST) server.sendmail(FROM, [TO], BODY) server.quit()

‎07-28-2021

Thank you Dan, I updated the code below for lines 2, 3, and 4 based on the ESRI documentation, and still getting the error the field 'MunisAccount' does not exist. My guess is something in row 5 or row 13 is the issue? arcpy.SelectLayerByAttribute_management("NewAccountsGeocoded_Layer", "NEW_SELECTION", "Status NOT IN ( 'M', 'T')") fc = "D:\\WorkSpace\\Water\\Workspace.gdb\\NewAccountsGeocoded" fields = ['MunisAccount'] for row in arcpy.SearchCursor(fc, fields): print((row.MunisAccount, row.ARC_Single_Line_Input)) arcpy.AddMessage("Water_ID_Updates Failed...{0}".format('\n')) txtFile.write("Water_ID_Updates Failed...{0}".format('\n')) txtFile.write("{0}{1}".format(arcpy.GetMessages(), '\n')) HOST = "server.host.com" SUBJECT = "Report: Unable to Add UB Accounts to GIS Accounts" TO = "brian@email.com" FROM = "Water Accounts<email@email.com>" text = "The following UB Account was not able to be imported into GIS WtrAccounts. Please see if there is an error in UB or if the address exists in COH Address GIS feature class. \n " + "UB Account: "+str(row.MunisAccount) + " | UB Address: "+str(row.ARC_Single_Line_Input)+"\n" BODY = "From: {1}{0}To: {2}{0}Subject: {3}{0}{0}{4}".format('\r\n', FROM, TO, SUBJECT, text) server = smtplib.SMTP(HOST) server.sendmail(FROM, [TO], BODY) server.quit()

‎07-27-2021

In migrating from Python 2.x to 3.x, we had a process that emails water accounts that are unable to be geocoded and added to our meter feature class. There was no change to the schema, but recently we had the below failure. The field still exists named 'MunisAccount' in the NewAccountsGeocoded feature class. Error received: Row: Field MunisAccount does not exist arcpy.MakeFeatureLayer_management("D:\\WorkSpace\\Water\\Workspace.gdb\\NewAccountsGeocoded", "NewAccountsGeocoded_Layer", "", "", "") arcpy.SelectLayerByAttribute_management("NewAccountsGeocoded_Layer", "NEW_SELECTION", "Status NOT IN ( 'M', 'T')") for row in arcpy.SearchCursor("NewAccountsGeocoded_Layer"): print (row.MunisAccount, row.ARC_Single_Line_Input) arcpy.AddMessage("Water_ID_Updates Failed...{0}".format('\n')) txtFile.write("Water_ID_Updates Failed...{0}".format('\n')) txtFile.write("{0}{1}".format(arcpy.GetMessages(), '\n')) HOST = "server.host.com" SUBJECT = "Report: Unable to Add UB Accounts to GIS Accounts" TO = "brian@email.com" FROM = "Water Accounts<email@email.com>" text = "The following UB Account was not able to be imported into GIS WtrAccounts. Please see if there is an error in UB or if the address exists in COH Address GIS feature class. \n " + "UB Account: "+str(row.MunisAccount) + " | UB Address: "+str(row.ARC_Single_Line_Input)+"\n" BODY = "From: {1}{0}To: {2}{0}Subject: {3}{0}{0}{4}".format('\r\n', FROM, TO, SUBJECT, text) server = smtplib.SMTP(HOST) server.sendmail(FROM, [TO], BODY) server.quit()

‎06-24-2021

In ArcGIS Desktop under Data Reviewer Tools, there was a tool that performed a GDB schema comparison. This appears to have been deprecated with no viable replacement in ArcGIS Pro. Being able to compare GDB schemas between a parent/child or production/development database is very beneficial. Are there any plans to bring this back into Pro? The Pro version I am on is 2.6.2.

‎05-20-2021

In ArcMap, on the table of contents window, you can list data by source. From there, you can remove data from the TOC at the source level and remove all of the data from that data source. This functionality is not available in Pro (at least at version 2.6.2). Being able to remove data from a TOC in batch via the same source without having to highlight all the layers would be a good addition to bring over from ArcMap.

‎04-28-2021

In creating database sequences, there is not a streamlined way to view database sequences that have been created. I have seen other posts of using Python to list database sequences, but that seems to only be applicable to file geodatabase and not enterprise databases. List Database Sequences for Enterprise Geodatabase Being able to view database sequences in a database would be beneficial, especially as these can interact with attribute rules to auto-generate values. Viewing along the same lines as you can for attribute rules, domains, subtypes, etc.

‎04-28-2021

Thank you @KenBuja I tried again and I got the below to work based on your feedback. I also created a new label class just for where the description is business so I was not trying to do so much in one label class. Thank you very much for your help! var d = $feature.Description var s = $feature.SitusNum var u = $feature.UnitNum var b = $feature.BuildingNum return When(d == 'BUSINESS', IIf(!IsEmpty(b) && !IsEmpty(u), b + ' - ' + u, IIf(!IsEmpty(b), b, IIf(!IsEmpty(u), u, s) ) ), null) .

‎04-27-2021

Thank you @KenBuja , So I get the below error when trying to update on my end. It is a direct copy and paste, all I did was keep the '$feature.' in front of each variable.

‎04-27-2021

I agree with this, it seems along the same lines of replicating domains, editor tracking, etc. Database Replication should support replication of attribute rules.

‎04-27-2021

We have a description field in our address feature class and one of the values is 'BUSINESS'. We have two other fields, Unit Number and Building Number. In working to migrate labeling language from VB Script to Arcade, we would like to label on the following conditions: Applies to all where the description is BUSINESS - If the building number is not null, label the building number and not the situs number. - if the unit number is not null, label the unit number and not the situs number. - If the building and unit numbers are both NULL, label the situs number - Not often, but if both unit number and building number are both not null, label both unit number and building number, do not label situs number Below is the code that I currently am working with. The portion that pertains to my question is where the description is 'BUSINESS'. var d = $feature.Description var s = $feature.SitusNum var u = $feature.UnitNum var b = $feature.BuildingNum if(d == 'SINGLE'){ return s } else if(d == 'TOWNHOME'){ return s } else if(d == 'ACCESSORY DWELLING'){ if(IsEmpty(u)){ return s} else{ return s + ' - ' + u} } else if(d == 'DUPLEX'){ if(IsEmpty(u)){ return s} else{ return s + ' - ' + u} } else if(d == 'MANUFACTURED'){ if(IsEmpty(u)){ return s} else{ return s + ' - ' + u} } else if(d == 'CONDO'){ if(IsEmpty(u)){ return s} else{ return u} } else if(d == 'MULTIFAMILY'){ if(IsEmpty(u)){ return s} else{ return u} } else if(d == 'BUSINESS'){ if(IsEmpty(b)){ return s} else{ return b} } else if(d == 'BUSINESS'){ if(IsEmpty(u)){ return s} else{ return u} } else if(d == 'CARE FACILITY'){ if(IsEmpty(u)){ return s} else{ return u} } else if(d == 'PRIVATE PARK'){ return s } else if(d == 'PUBLIC FACILITY'){ if(IsEmpty(u)){ return s} else{ return u} } else if(d == 'GARAGE'){ if(IsEmpty(u)){ return s} else{ return u} } else if(d == 'PARKING GARAGE'){ return s } else if(d == 'STORAGE UNIT'){ if(IsEmpty(u)){ return s} else{ return u} }

‎04-26-2021

@jcarlson , would you have any knowledge as to how to treat labeling an address with the same description based on the code snippets from above. Below, if a feature is a business, I am trying to label the building number only, not the situs number if a building number exists. In the same scope of work, I am also trying to label a business on the unit number only if a unit number exists. }else if(d == 'BUSINESS'){ if(IsEmpty(u)){ return s} else{ return u} } else if(d == 'BUSINESS'){ if(IsEmpty(b)){ return s} else{ return b} }

‎04-26-2021

Thank you both for your assistance on this, greatly appreciated.

‎04-26-2021

So when I enter that, it shows that there is a reserved keyword on line 10. else{

Online Status	Online
Date Last Visited	5 hours ago

My Ideas

Latest Contributions by Brian_McLeer

Enable turning on required fields in Share As Web Layer Pane

Re: Update of email function Python 2.x to 3.x

Re: Update of email function Python 2.x to 3.x

Re: Update of email function Python 2.x to 3.x

Update of email function Python 2.x to 3.x

Bring back Geodatabase Schema Compare

Remove data from contents pane based on data source

Ability to view Database Sequence in ArcGIS Pro

Re: Arcade Labeling based on NULL or NOT NULL values

Re: Arcade Labeling based on NULL or NOT NULL values

Re: Support Geodatabase Replication with the Attribute Rules

Arcade Labeling based on NULL or NOT NULL values

Re: Label in Arcade based on domain value?

Re: Label in Arcade based on domain value?

Re: Label in Arcade based on domain value?

Zone Lookup

CSV Geocoder Widget

Re: ArcGIS Security and Privacy Advisor does nothi...

Search Custom

Map Layers Custom

Experience Builder Custom Widgets

Experience Builder Tips and Tricks