Update Cursor string error and attribute error

RyShissler_Welland — Mon, 18 Sep 2023 18:48:18 GMT

I'm new to scripting and I'm trying to create a tool that takes street address from one field, makes it into a internal link, and then adds it to another field. I keep running into an error on line 69. I can't seem to find a solution.

File "<string>", line 69, in execute
AttributeError: __enter__

def addressParser(address): try: splitAddress = address.split(' ' , 1) firstLetter = splitAddress[1][0] streetName = splitAddress[1] except: arcpy.AddMessage('An error occurred while updating ' + address + '.') return firstLetter , streetName import arcpy class Toolbox(object): def __init__(self): """Define the toolbox (the name of the toolbox is the name of the .pyt file).""" self.label = "Toolbox" self.alias = "toolbox" # List of tool classes associated with this toolbox self.tools = [Tool] class Tool(object): def __init__(self): """Define the tool (tool name is the name of the class).""" self.label = "Water Service Linker" self.description = "" self.canRunInBackground = False def getParameterInfo(self): param0 = arcpy.Parameter( # Allows user to select the table on which they'd like the action performed displayName = 'Table', name = 'param0', datatype = 'GPTableView', parameterType = 'Required', direction = 'Input') params = [param0] return params def isLicensed(self): """Set whether tool is licensed to execute.""" return True def updateParameters(self, parameters): """Modify the values and properties of parameters before internal validation is performed. This method is called whenever a parameter has been changed.""" return def updateMessages(self, parameters): """Modify the messages created by internal validation for each tool parameter. This method is called after internal validation.""" return def execute(self, parameters, messages): """This tool will add folder link data to the WtrSrvcInstall Field""" table = parameters[0].valueAsText # converts the parameter to a useable string arcpy.AddMessage(table) fields = ['Civic_Name_Label' , 'WtrSrvcInstall'] #Defines the fields we'll be working in addressField = 'Civic_Name_Label' # The field title that contains the address info #linkField = 'WtrSrvcInstall' # The field title that will be the destination for the links folderBase = '\\\\polaris\\Infrastructure_ScanFiles\\WaterServiceSheets' # Sets the base link under which all other links exist arcpy.AddMessage(folderBase) #try: with arcpy.UpdateCursor(table , fields) as cursor: # sets the cursor in the correct table and fields for row in cursor: # iterates through each row first , street = addressParser(row[0]) folderFull = folderBase + '\\' + first + '\\' + street arcpy.AddMessage(folderFull) row[1] = folderFull #except: #arcpy.AddMessage('An error occurred') return def postExecute(self, parameters): """This method takes place after outputs are processed and added to the display.""" return

Re: Update Cursor string error and attribute error

AlfredBaldenweck — Mon, 18 Sep 2023 18:54:26 GMT

Try changing your table variable from parameters[0].valueAsText to parameters[0].value?

You're already asking for a table in the parameter, but you're feeding the cursor a string. Might be something else, but I'd at least give it a shot.

Re: Update Cursor string error and attribute error

RyShissler_Welland — Mon, 18 Sep 2023 19:05:54 GMT

Hmmm I got the same error with .value unfortunately.

Re: Update Cursor string error and attribute error

AlfredBaldenweck — Mon, 18 Sep 2023 19:40:00 GMT

Okay, so I'd still not use valueAsText here.

But.

Try using arcpy.da.UpdateCursor instead; it didn't throw any errors for me.

Oh wait that's probably the issue; arcpy.UpdateCursor and arcpy.da.UpdateCursor have different parameters.

Re: Update Cursor string error and attribute error

RyShissler_Welland — Mon, 18 Sep 2023 20:01:21 GMT

OMG yes, that worked! Thank you!

topic Re: Update Cursor string error and attribute error in Python Questions

Update Cursor string error and attribute error

Re: Update Cursor string error and attribute error

Re: Update Cursor string error and attribute error

Re: Update Cursor string error and attribute error

Re: Update Cursor string error and attribute error