Latest Contributions by JaredPilbeam2

https://support.esri.com/en/technical-article/000023355 I want to improve on the above script from ESRI that finds duplicate values and writes the values to a new field in a table. It's using an old cursor and it is very slow with large datasets. But, I'm running into problems due to lack of experience. Their code verbatim for my purposes: import arcpy ''' This script will count the number of occurences of a value in a field ("field_in") and write them to a new field ("field_out") ''' #path to GDB goes here arcpy.env.workspace = r"C:\pathto\DuplicateTesting.gdb\DuplicateTesting" #name of feature class goes here infeature = "backup_02232021" field_in = "name" field_out = "COUNT_"+field_in arcpy.AddField_management(infeature, field_out,"SHORT") lista= [] cursor1=arcpy.SearchCursor(infeature) for row in cursor1: i=row.getValue(field_in) lista.append(i) del cursor1, row cursor2=arcpy.UpdateCursor(infeature) for row in cursor2: i=row.getValue(field_in) occ=lista.count(i) row.setValue(field_out, occ) cursor2.updateRow(row) del cursor2, row   The following is as far as I got with my improvement. It's throwing an error on the line with the i variable. How can I continue with the UpdateCursor method to put the count of each item in the fields list into its corresponding new field? infeature = r"C:pathto\DuplicateTesting.gdb\DuplicateTesting fields = ["name", "location_string_output", "email_address", "cell_phone_number", "home_phone_number"] for field_out in fields: #add new fields arcpy.AddField_management(infeature, "COUNT_"+field_out,"SHORT") list= [] with arcpy.da.SearchCursor(infeature, fields) as cursor1: for row in cursor1: list.append(row) del cursor1, row with arcpy.da.UpdateCursor(infeature, fields) as cursor2: for row in cursor2: i = row.getValue(row) #<-- throws AttributeError here occ = list.count(i) print(occ) del cursor2, row   Error: Traceback (most recent call last): File "\\gisfile\GISstaff\Jared\Python Scripts\ArcGISPro\DuplicateFields_updated.py", line 21, in <module> i = row.getValue(row) AttributeError: 'list' object has no attribute 'getValue'   ... View more

I'm using the How to identify duplicate or unique values in Pro code provided by ERSI  verbatim, and I'm getting an error. I have a feature class table that I'm looking for duplicates in. The technical document doesn't say whether to use the field name or alias, so I tried both. When I run it with the field name the code throws an exception. I stopped the script and opened Pro. The field gets created in the table but it's all NULLs. This is the line where the exception is being thrown:       i=row.getValue(field_in)       Exception/Error:       Message=ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds. Source=\\GISFILE\GISSTAFF\Jared\Python Scripts\ArcGISPro\DuplicateFields.py StackTrace: File "\\GISFILE\GISSTAFF\Jared\Python Scripts\ArcGISPro\DuplicateFields.py", line 17, in <module> i=row.getValue(field_in)         When I run it with the alias it doesn't finish, or at least I've never let it because it's taking a remarkably long time. However, if I stop the script and open Pro to view the table, a lot of the 190K+ fields are written to. But, like I said it never finishes... Code:       import arcpy ''' This script will count the number of occurences of a value in a field ("field_in") and write them to a new field ("field_out") ''' arcpy.env.workspace = r"C:\Users\jpilbeam\Downloads\DuplicateTesting.gdb\DuplicateTesting.gdb" #path to GDB goes here infeature = "backup_02232021" #name of feature class goes here field_in = "name" #this is the alias of the field. Name: is the actual name field_out = "COUNT_"+field_in arcpy.AddField_management(infeature, field_out,"SHORT") lista= [] cursor1=arcpy.SearchCursor(infeature) for row in cursor1: i=row.getValue(field_in) #<-- where exception is thrown using field name in field_in variable lista.append(i) del cursor1, row cursor2=arcpy.UpdateCursor(infeature) for row in cursor2: i=row.getValue(field_in) occ=lista.count(i) row.setValue(field_out, occ) cursor2.updateRow(row) del cursor2, row print("----done----")       EDIT: Using the alias, I let the code run for like 15-20 mins and it finished with no errors! So, I guess it just needs that long with all these records?   ... View more

I can not find a help document for this error. This is from a survey on the web and it does not have an error if I open it while signed in to AGOL. But, when anyone else opens it they can not submit a survey. It is a public survey. The form is shared publicly. When I submit a Complaints Form survey it is added to the Complaints Form feature layer. So, the feature service exists, but it's not shared publicly. How is it not accessible, as the error suggests?   ... View more