https://community.esri.com/t5/python-questions/using-da-updatecursor-s-updaterow-row-i-get-quot/m-p/1306700#M68115 <P>Hello everyone,</P><P>I am running a python script I wrote from a geoprocessing toolbox.&nbsp; Essentially, its purpose is to take data from an excel file and update specific rows in the feature class attribute table.&nbsp; Most of the script works, but I tried to add some additional functionality to create a new field in the table and populate it, and this is the portion that broke.</P><P>The problem function is as follows:</P><LI-CODE lang="python">## Funtion to create a new XPNUMDATAX field in arcGIS table and populate it using a prefix and APN def makePNUMDATA(countyItem, boolItem, workspace, fc): prefix = 'default' arcpy.AddMessage(f"boolItem: {boolItem}") arcpy.AddMessage(f"countyItem: {countyItem}") if boolItem == "'true'": if countyItem == "'stanislaus'": ## Create variable used to modify APN prefix = ' ' if countyItem == 'merced': ## Create variable used to modify APN prefix = 'M' ## Add XPNUMDATAX Field to the table arcpy.management.AddField(fc, 'XPNUMDATAX', 'TEXT') txFields = ['APN', 'XPNUMDATAX'] ## Iterate table and update XPNUMDATAX field with prefix + APN with arcpy.da.Editor(workspace) as edit: ## Declare update cursor with arcpy.da.UpdateCursor(fc, txFields) as cursor: for row in cursor: apnVal = row[0] apnVal = str(apnVal) newPNUM = [prefix + apnVal] row[1] = newPNUM cursor.updateRow(row)</LI-CODE><P>This does create the XPNUMDATAX field, and through various print statements I have verified that it does indeed calculate the newPNUM value intended to populate the field.&nbsp; However, I get this error:</P><LI-CODE lang="markdown">Traceback (most recent call last): File "C:\Users\twhammond\Documents\tommy_misc\dataProject\testFiles\scripts\updateFromExcel3.py", line 274, in &lt;module&gt; makePNUMDATA(countyList[fcIndex], boolList[fcIndex], workspace, fcList[fcIndex]) File "C:\Users\twhammond\Documents\tommy_misc\dataProject\testFiles\scripts\updateFromExcel3.py", line 230, in makePNUMDATA cursor.updateRow(row) TypeError: value #1 - unsupported type: list</LI-CODE><P>From all the documentation, it seems as if the cursor.updateRow() method takes a list or tuple as its parameter.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="twhammond_0-1688764612966.png" style="width: 612px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/75031i8F59CEE527DB0A19/image-dimensions/612x225?v=v2" width="612" height="225" role="button" title="twhammond_0-1688764612966.png" alt="twhammond_0-1688764612966.png" /></span></P><P>&nbsp;</P><P>What am I missing here?&nbsp; The row is a list object and is taken into a method that only accepts lists and tuples, so why am I getting this type error?</P><P>Other details:</P><P>I am using ArcGIS Pro 2.9.9</P><P>I am familiar with python but have only been using arcpy and arcGIS for a couple weeks.</P> Fri, 07 Jul 2023 21:19:10 GMT twhammond 2023-07-07T21:19:10Z https://community.esri.com/t5/python-questions/using-da-updatecursor-s-updaterow-row-i-get-quot/m-p/1306700#M68115 <P>Hello everyone,</P><P>I am running a python script I wrote from a geoprocessing toolbox.&nbsp; Essentially, its purpose is to take data from an excel file and update specific rows in the feature class attribute table.&nbsp; Most of the script works, but I tried to add some additional functionality to create a new field in the table and populate it, and this is the portion that broke.</P><P>The problem function is as follows:</P><LI-CODE lang="python">## Funtion to create a new XPNUMDATAX field in arcGIS table and populate it using a prefix and APN def makePNUMDATA(countyItem, boolItem, workspace, fc): prefix = 'default' arcpy.AddMessage(f"boolItem: {boolItem}") arcpy.AddMessage(f"countyItem: {countyItem}") if boolItem == "'true'": if countyItem == "'stanislaus'": ## Create variable used to modify APN prefix = ' ' if countyItem == 'merced': ## Create variable used to modify APN prefix = 'M' ## Add XPNUMDATAX Field to the table arcpy.management.AddField(fc, 'XPNUMDATAX', 'TEXT') txFields = ['APN', 'XPNUMDATAX'] ## Iterate table and update XPNUMDATAX field with prefix + APN with arcpy.da.Editor(workspace) as edit: ## Declare update cursor with arcpy.da.UpdateCursor(fc, txFields) as cursor: for row in cursor: apnVal = row[0] apnVal = str(apnVal) newPNUM = [prefix + apnVal] row[1] = newPNUM cursor.updateRow(row)</LI-CODE><P>This does create the XPNUMDATAX field, and through various print statements I have verified that it does indeed calculate the newPNUM value intended to populate the field.&nbsp; However, I get this error:</P><LI-CODE lang="markdown">Traceback (most recent call last): File "C:\Users\twhammond\Documents\tommy_misc\dataProject\testFiles\scripts\updateFromExcel3.py", line 274, in &lt;module&gt; makePNUMDATA(countyList[fcIndex], boolList[fcIndex], workspace, fcList[fcIndex]) File "C:\Users\twhammond\Documents\tommy_misc\dataProject\testFiles\scripts\updateFromExcel3.py", line 230, in makePNUMDATA cursor.updateRow(row) TypeError: value #1 - unsupported type: list</LI-CODE><P>From all the documentation, it seems as if the cursor.updateRow() method takes a list or tuple as its parameter.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="twhammond_0-1688764612966.png" style="width: 612px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/75031i8F59CEE527DB0A19/image-dimensions/612x225?v=v2" width="612" height="225" role="button" title="twhammond_0-1688764612966.png" alt="twhammond_0-1688764612966.png" /></span></P><P>&nbsp;</P><P>What am I missing here?&nbsp; The row is a list object and is taken into a method that only accepts lists and tuples, so why am I getting this type error?</P><P>Other details:</P><P>I am using ArcGIS Pro 2.9.9</P><P>I am familiar with python but have only been using arcpy and arcGIS for a couple weeks.</P> Fri, 07 Jul 2023 21:19:10 GMT https://community.esri.com/t5/python-questions/using-da-updatecursor-s-updaterow-row-i-get-quot/m-p/1306700#M68115 twhammond 2023-07-07T21:19:10Z https://community.esri.com/t5/python-questions/using-da-updatecursor-s-updaterow-row-i-get-quot/m-p/1306720#M68117 <P><EM>A list (or tuple) of field names. For a single field, you can use a string instead of a list of strings.</EM></P><P>Since you are using a single field in the updatecursor, did you try a string instead of a list</P><LI-CODE lang="python">newPNUM = prefix + apnVal</LI-CODE><P>&nbsp;&nbsp;</P> Fri, 07 Jul 2023 21:52:14 GMT https://community.esri.com/t5/python-questions/using-da-updatecursor-s-updaterow-row-i-get-quot/m-p/1306720#M68117 DanPatterson 2023-07-07T21:52:14Z https://community.esri.com/t5/python-questions/using-da-updatecursor-s-updaterow-row-i-get-quot/m-p/1306723#M68118 <P>I was completely misinterpreting the error.&nbsp; I thought <EM>row</EM> was the parameter causing issues and didn't even notice that <EM>newPNUM</EM> was a list.&nbsp;</P><P>Thanks! That solved the problem for me.</P> Fri, 07 Jul 2023 22:01:03 GMT https://community.esri.com/t5/python-questions/using-da-updatecursor-s-updaterow-row-i-get-quot/m-p/1306723#M68118 twhammond 2023-07-07T22:01:03Z