Hello, I have problems to update two attribute fields with values created in the following code. The insert cursor works well but with the update cursor I get a error message. Are there any other ways to fill a table with values? Error message: line 60, in UpdateFields cursor.updateRow([row]) StopIteration: iteration not started # -*- coding: cp1252 -*- import arcpy , os arcpy . env . overwriteOutput = True myPath = r "R:\Daten\geo_daten\Arten\Fledermaeuse\AltDaten" out_path_table = r "C:\temp4\Geodatenbestand.mdb" out_name_table = "Geodatenbestand" template_table = r "C:\temp4\Geodatenbestand.mdb\Geodatenbestand_Template" inTable = os . path . join ( out_path_table , out_name_table ) inTableL = "Table_Layer" MyList1 = list ( ) MyList2 = list ( ) # Encoding der Standardausgabe herausfinden stdout_encoding = sys . stdout . encoding or sys . getfilesystemencoding ( ) class Geodatenbestand ( object ) : def __init__ ( self ) : self . myPath = myPath def SearchFiles ( self ) : SHPCounter = 0 for path , dirs , files in os . walk ( myPath ) : for file in files : if file . lower ( ) . endswith ( '.shp' ) : print path + "\\" + file SHPCounter += 1 print SHPCounter accessTime = os . path . getatime ( os . path . join ( path , file ) ) # last access time actualTime = time . time ( ) hoursPassed = """{}""" . format ( int ( ( actualTime - accessTime ) / 3600 ) ) path1 = path . decode ( stdout_encoding ) file1 = file . decode ( stdout_encoding ) print file1 cursor = arcpy . da . InsertCursor ( inTable , [ 'PathFile' ] ) cursor . insertRow ( [ path1 + "\\" + file1 ] ) MyList1 . append ( file1 ) MyList2 . append ( hoursPassed ) def UpdateFields ( self ) : print MyList1 with arcpy . da . UpdateCursor ( inTable , [ "File" ] ) as cursor : for row in MyList1 : cursor . updateRow ( [ row ] ) print MyList2 with arcpy . da . UpdateCursor ( inTable , [ "h_not_used" ] ) as cursor : for row in MyList2 : cursor . updateRow ( [ row ] ) def CreateTable ( self ) : if arcpy . Exists ( inTable ) : arcpy . Delete_management ( inTable ) arcpy . CreateTable_management ( out_path_table , out_name_table , template_table ) if __name__ == '__main__' : MyClass = Geodatenbestand ( ) MyClass . CreateTable ( ) MyClass . SearchFiles ( ) MyClass . UpdateFields ( )

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Fill table with update cursor? array?

JB1234510

Hello,

I have problems to update two attribute fields with values created in the following code. The insert cursor works well but with the update cursor I get a error message. Are there any other ways to fill a table with values?

Error message:

line 60, in UpdateFields
cursor.updateRow([row])
StopIteration: iteration not started

<SPAN class="comment token"># -*- coding: cp1252 -*-</SPAN>
<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> os

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

myPath <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"R:\Daten\geo_daten\Arten\Fledermaeuse\AltDaten"</SPAN>
out_path_table <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\temp4\Geodatenbestand.mdb"</SPAN>
out_name_table <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Geodatenbestand"</SPAN>
template_table <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\temp4\Geodatenbestand.mdb\Geodatenbestand_Template"</SPAN>
inTable <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>out_path_table<SPAN class="punctuation token">,</SPAN> out_name_table<SPAN class="punctuation token">)</SPAN>
inTableL <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Table_Layer"</SPAN>

MyList1 <SPAN class="operator token">=</SPAN> list<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
MyList2 <SPAN class="operator token">=</SPAN> list<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Encoding der Standardausgabe herausfinden</SPAN>
stdout_encoding <SPAN class="operator token">=</SPAN> sys<SPAN class="punctuation token">.</SPAN>stdout<SPAN class="punctuation token">.</SPAN>encoding <SPAN class="operator token">or</SPAN> sys<SPAN class="punctuation token">.</SPAN>getfilesystemencoding<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">class</SPAN> <SPAN class="token class-name">Geodatenbestand</SPAN><SPAN class="punctuation token">(</SPAN>object<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>

    <SPAN class="keyword token">def</SPAN> <SPAN class="token function">__init__</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>

        self<SPAN class="punctuation token">.</SPAN>myPath <SPAN class="operator token">=</SPAN> myPath       

    <SPAN class="keyword token">def</SPAN> <SPAN class="token function">SearchFiles</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        
        SHPCounter <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
                
        <SPAN class="keyword token">for</SPAN> path<SPAN class="punctuation token">,</SPAN> dirs<SPAN class="punctuation token">,</SPAN> files <SPAN class="keyword token">in</SPAN> os<SPAN class="punctuation token">.</SPAN>walk<SPAN class="punctuation token">(</SPAN>myPath<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">for</SPAN> file <SPAN class="keyword token">in</SPAN> files<SPAN class="punctuation token">:</SPAN>
                <SPAN class="keyword token">if</SPAN> file<SPAN class="punctuation token">.</SPAN>lower<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>endswith<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'.shp'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
                    <SPAN class="keyword token">print</SPAN> path <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\\"</SPAN> <SPAN class="operator token">+</SPAN> file
                    
                    SHPCounter <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</SPAN>
                    <SPAN class="keyword token">print</SPAN> SHPCounter
                    
                    accessTime <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>getatime<SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>path<SPAN class="punctuation token">,</SPAN> file<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># last access time</SPAN>
                    
                    actualTime <SPAN class="operator token">=</SPAN> time<SPAN class="punctuation token">.</SPAN>time<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

                    hoursPassed <SPAN class="operator token">=</SPAN> <SPAN class="string token">"""{}"""</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>int<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>actualTime <SPAN class="operator token">-</SPAN> accessTime<SPAN class="punctuation token">)</SPAN><SPAN class="operator token">/</SPAN><SPAN class="number token">3600</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

                    path1 <SPAN class="operator token">=</SPAN> path<SPAN class="punctuation token">.</SPAN>decode<SPAN class="punctuation token">(</SPAN>stdout_encoding<SPAN class="punctuation token">)</SPAN>
                    file1 <SPAN class="operator token">=</SPAN> file<SPAN class="punctuation token">.</SPAN>decode<SPAN class="punctuation token">(</SPAN>stdout_encoding<SPAN class="punctuation token">)</SPAN> 
                    <SPAN class="keyword token">print</SPAN> file1
                    
                    cursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'PathFile'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
                    cursor<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>path1 <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\\"</SPAN> <SPAN class="operator token">+</SPAN> file1<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

                    MyList1<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>file1<SPAN class="punctuation token">)</SPAN>
                    MyList2<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>hoursPassed<SPAN class="punctuation token">)</SPAN>

    <SPAN class="keyword token">def</SPAN> <SPAN class="token function">UpdateFields</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        
        <SPAN class="keyword token">print</SPAN> MyList1
                        
        <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"File"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> MyList1<SPAN class="punctuation token">:</SPAN>
                
                cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

        <SPAN class="keyword token">print</SPAN> MyList2
        
        <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"h_not_used"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> MyList2<SPAN class="punctuation token">:</SPAN>
                
                cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
              

    <SPAN class="keyword token">def</SPAN> <SPAN class="token function">CreateTable</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        
        <SPAN class="keyword token">if</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
            arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">)</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>CreateTable_management<SPAN class="punctuation token">(</SPAN>out_path_table<SPAN class="punctuation token">,</SPAN> out_name_table<SPAN class="punctuation token">,</SPAN> template_table<SPAN class="punctuation token">)</SPAN>
 
        
<SPAN class="keyword token">if</SPAN> __name__ <SPAN class="operator token">==</SPAN> <SPAN class="string token">'__main__'</SPAN><SPAN class="punctuation token">:</SPAN>

    MyClass <SPAN class="operator token">=</SPAN> Geodatenbestand<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
    
    MyClass<SPAN class="punctuation token">.</SPAN>CreateTable<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
    MyClass<SPAN class="punctuation token">.</SPAN>SearchFiles<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
    MyClass<SPAN class="punctuation token">.</SPAN>UpdateFields<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
    


‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Vind meer berichten getagd met

Accepted answers

bixb0012

Actually, your code is worse than you think. You are writing, and overwriting, each and every value in MyList1 into each and every row in cursor. Since the last value isn't overwritten, that is what you are seeing in each row after the update cursor is complete.

Assuming the cursor and list are the same length, and the cursor will iterate in the same order as the list, which is a risky assumption when not using a SQL ORDER BY clause, you could go with:

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"File"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> value <SPAN class="keyword token">in</SPAN> MyList1<SPAN class="punctuation token">:</SPAN>
        next<SPAN class="punctuation token">(</SPAN>cursor<SPAN class="punctuation token">)</SPAN>
        cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>value<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

JB1234510

Thank you ...

bixb0012

Assuming the cursor and list are the same length, and the cursor will iterate in the same order as the list, which is a risky assumption when not using a SQL ORDER BY clause, you could go with:

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"File"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> value <SPAN class="keyword token">in</SPAN> MyList1<SPAN class="punctuation token">:</SPAN>
        next<SPAN class="punctuation token">(</SPAN>cursor<SPAN class="punctuation token">)</SPAN>
        cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>value<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

bixb0012

For NumPy, try this:

inArray <SPAN class="operator token">=</SPAN> numpy<SPAN class="punctuation token">.</SPAN>array<SPAN class="punctuation token">(</SPAN>
    <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">,</SPAN>j<SPAN class="punctuation token">,</SPAN>k<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> i<SPAN class="punctuation token">,</SPAN>j<SPAN class="punctuation token">,</SPAN>k <SPAN class="keyword token">in</SPAN> zip<SPAN class="punctuation token">(</SPAN>MyList<SPAN class="punctuation token">,</SPAN>MyList1<SPAN class="punctuation token">,</SPAN>MyList2<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
    numpy<SPAN class="punctuation token">.</SPAN>dtype<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Path_File'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'|S256'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'File'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'|S256'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'h_not_used'</SPAN><SPAN class="punctuation token">,</SPAN> numpy<SPAN class="punctuation token">.</SPAN>int32<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JB1234510

Yes OK.

If I write it like this it overwrites all rows with the last value in MyList1. Don't really know how to get it to write exactly each row in the list into the right row in the table?

  <SPAN class="keyword token">def</SPAN> <SPAN class="token function">UpdateFields</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        
        <SPAN class="keyword token">print</SPAN> MyList1
                        
        <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"File"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
                <SPAN class="keyword token">for</SPAN> value <SPAN class="keyword token">in</SPAN> MyList1<SPAN class="punctuation token">:</SPAN>
                    <SPAN class="keyword token">print</SPAN> value
                    cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>value<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

bixb0012

Simply looking at this error:

Error message:
line 60, in UpdateFields
cursor.updateRow([row])
StopIteration: iteration not started

In Line #57, you instantiate the cursor but you never start iterating through it. Whereas most or all geoprocessing tools work on sets of data, ArcPy cursors work on individual rows of data.

You will run into the same error on Lines #64-#67.

JB1234510

If you use a array, how to fill a column in an array with a list? This doesn't work:

def UpdateFields(self):
               
        inArray = numpy.array([(MyList, MyList1, MyList2)],
                      numpy.dtype([('Path_File', '|S256'),
                                   ('File', '|S256'),
                                   ('h_not_used', numpy.int32)]))
        
        arcpy.da.NumPyArrayToTable(inArray, outTable)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Error message:

line 63, in UpdateFields
('h_not_used', numpy.int32)]))
ValueError: cannot set an array element with a sequence

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.