*EDIT* I marked Joshua Bixby's response as the correct answer as it solved the original issue I had, but I also want to give a special thanks to Dan Patterson for helping me figure out the tuple issue. Thanks for everyone else for chiming in as well. Much appreciated! Please reference the final working script at the bottom of this request. Hello, I have working scripts that use UpdateCursor and InsertCursor, but all of my previous work has been in the fashion of inserting or updating records in the feature class or table that I am referencing. I'm struggling to figure out how to reference data in one feature class, and then insert entries using that information into a separate database table. I'm pretty confident that the problem I am having is very basic, but I am no expert in Python and I'm obviously missing something. Basically I want to take every entry in a feature class, and then depending on a user input, enter X number of entries into a related table for each feature in the feature class. So say the number of features in the feature class is 10, and the user states that we need 2 records in the related table for each site, then I need the script to create 20 entries. In those 20 entries, though, I need for the script to take a number of fields from the feature class, and port them over into the appropriate fields in the related table entries. with arcpy . da . UpdateCursor ( inTable , inField ) as cursor : for row in cursor : row [ 0 ] = name cursor . updateRow ( row ) The above code is something I'm familiar with, but again, it's only referencing one feature class, so the inField variable represents fields that are contained within the inTable variable, obviously. How do I grab fields from a feature class, create entries in a table, and then populate some of the fields in those entries based on the feature class? Working Script: import arcpy numIDs = user_input # user input variable targetTBL = target_table # table that rows will be inserted into targetFields = ( 'SimpleID' , 'ExtendedID' , 'InternalID' , 'ExternalID' , 'Termination' , 'ProjectRegion' , 'ProjectState' , 'ProjectName' , 'ProjectCustomer' , 'NodeGUID' , 'CircuitID' ) sourceFC = source_table # table that information comes from sourceFields = ( 'SimpleID' , 'ExtendedID' , 'InternalID' , 'ExternalID' , 'Termination' , 'ProjectRegion' , 'ProjectState' , 'ProjectName' , 'ProjectCustomer' , 'GlobalID' ) # Execute Insert Cursor and Search Cursor with arcpy . da . InsertCursor ( targetTBL , targetFields ) as targetCursor : with arcpy . da . SearchCursor ( sourceFC , sourceFields ) as sourceCursor : for row in sourceCursor : for i in range ( 1 , numIDs + 1 ) : if i 10 : IDnumber = "0" + str ( i ) else : IDnumber = str ( i ) InternalID = row [ 2 ] Termination = row [ 4 ] Customer = row [ 8 ] circuitID = "({})-({})-({})-({})" . format ( InternalID , Termination , Customer , IDnumber ) targetCursor . insertRow ( row + ( circuitID , ) )

A general structure for inserting records into a target table from a source table: tbl_src = # path to source table tbl_tar = # path to target table flds = # list of field names for target table, exluding OID cnts = # dict or other structure for looking up number of records to copy with arcpy . da . InsertCursor ( tbl_tar , flds ) as icur : with arcpy . da . SearchCursor ( tbl_src , [ "OID@" ] + flds ) as cur : for row in cur : oid = row [ 0 ] row = row [ 1 : ] for i in range ( 1 , cnts [ oid ] + 1 ) : icur . insertRow ( row )

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; } } }

Referencing Multiple Data Sources with Python

Anonymous User

*EDIT*

I marked Joshua Bixby's response as the correct answer as it solved the original issue I had, but I also want to give a special thanks to Dan Patterson for helping me figure out the tuple issue. Thanks for everyone else for chiming in as well. Much appreciated! Please reference the final working script at the bottom of this request.

Hello, I have working scripts that use UpdateCursor and InsertCursor, but all of my previous work has been in the fashion of inserting or updating records in the feature class or table that I am referencing. I'm struggling to figure out how to reference data in one feature class, and then insert entries using that information into a separate database table. I'm pretty confident that the problem I am having is very basic, but I am no expert in Python and I'm obviously missing something. Basically I want to take every entry in a feature class, and then depending on a user input, enter X number of entries into a related table for each feature in the feature class.

So say the number of features in the feature class is 10, and the user states that we need 2 records in the related table for each site, then I need the script to create 20 entries. In those 20 entries, though, I need for the script to take a number of fields from the feature class, and port them over into the appropriate fields in the related table entries.

<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> inField<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> name 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>‍‍‍‍ ‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

The above code is something I'm familiar with, but again, it's only referencing one feature class, so the inField variable represents fields that are contained within the inTable variable, obviously. How do I grab fields from a feature class, create entries in a table, and then populate some of the fields in those entries based on the feature class?

Working Script:

<SPAN class="keyword token">import</SPAN> arcpy
numIDs <SPAN class="operator token">=</SPAN> user_input&nbsp; <SPAN class="comment token"># user input variable</SPAN>
targetTBL <SPAN class="operator token">=</SPAN> target_table&nbsp; <SPAN class="comment token"># table that rows will be inserted into</SPAN>
targetFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'SimpleID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ExtendedID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'InternalID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ExternalID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Termination'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectRegion'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectState'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectName'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectCustomer'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'NodeGUID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'CircuitID'</SPAN><SPAN class="punctuation token">)</SPAN>
sourceFC <SPAN class="operator token">=</SPAN> source_table&nbsp; <SPAN class="comment token"># table that information comes from</SPAN>
sourceFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'SimpleID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ExtendedID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'InternalID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ExternalID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Termination'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectRegion'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectState'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectName'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectCustomer'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'GlobalID'</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Execute Insert Cursor and Search Cursor</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>targetTBL<SPAN class="punctuation token">,</SPAN> targetFields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> targetCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>sourceFC<SPAN class="punctuation token">,</SPAN> sourceFields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> sourceCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> sourceCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> numIDs<SPAN class="operator token">+</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> i <SPAN class="operator token"><</SPAN> <SPAN class="number token">10</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IDnumber <SPAN class="operator token">=</SPAN> <SPAN class="string token">"0"</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IDnumber <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; InternalID <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Termination <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Customer <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; circuitID <SPAN class="operator token">=</SPAN> <SPAN class="string token">"({})-({})-({})-({})"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>InternalID<SPAN class="punctuation token">,</SPAN> Termination<SPAN class="punctuation token">,</SPAN> Customer<SPAN class="punctuation token">,</SPAN> IDnumber<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; targetCursor<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>row <SPAN class="operator token">+</SPAN> <SPAN class="punctuation token">(</SPAN>circuitID<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>‍</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>

Trouver plus de publications taguées avec

Accepted answers

bixb0012

A general structure for inserting records into a target table from a source table:

tbl_src <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># path to source table</SPAN>
tbl_tar <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># path to target table</SPAN>
flds <SPAN class="operator token">=</SPAN>&nbsp; <SPAN class="comment token"># list of field names for target table, exluding OID</SPAN>
cnts <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># dict or other structure for looking up number of records to copy</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>tbl_tar<SPAN class="punctuation token">,</SPAN> flds<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> icur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>tbl_src<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OID@"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> flds<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; oid <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> cnts<SPAN class="punctuation token">[</SPAN>oid<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; icur<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>row<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>

All comments

DanPatterson_Retired

Joining a tuple and a string

The right way

 a<SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'a'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'b'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'c'</SPAN><SPAN class="punctuation token">)</SPAN>

b <SPAN class="operator token">=</SPAN> <SPAN class="string token">'def'</SPAN>

c <SPAN class="operator token">=</SPAN> a <SPAN class="operator token">+</SPAN> <SPAN class="punctuation token">(</SPAN>b<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; <SPAN class="comment token"># ---- what a difference a little comma makes ----</SPAN>

c
<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'a'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'b'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'c'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'def'</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>

The wrong way

d <SPAN class="operator token">=</SPAN> a <SPAN class="operator token">+</SPAN> <SPAN class="punctuation token">(</SPAN>b<SPAN class="punctuation token">)</SPAN>&nbsp; <SPAN class="comment token"># ---- or a + b wrongo as well</SPAN>

Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>

&nbsp; File <SPAN class="string token">"<ipython-input-11-2547ba7e6fd6>"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
&nbsp;&nbsp;&nbsp; d <SPAN class="operator token">=</SPAN> a <SPAN class="operator token">+</SPAN> <SPAN class="punctuation token">(</SPAN>b<SPAN class="punctuation token">)</SPAN>

TypeError<SPAN class="punctuation token">:</SPAN> can only concatenate tuple <SPAN class="punctuation token">(</SPAN><SPAN class="operator token">not</SPAN> <SPAN class="string token">"str"</SPAN><SPAN class="punctuation token">)</SPAN> to tuple<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Anonymous User

I actually just ran my code in the Python window within ArcMap, right up to the point where I call out the local variables for the loop. Then I copy/pasted your code from above to finish out the loop. Strangely, though, after reopening the map that I was using and attempting it once again, I now get the following error:

And no records got inserted.

I attempted to assign variables for each row, just thinking that that had to do with the list issue:

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>targetTBL<SPAN class="punctuation token">,</SPAN> targetFields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> targetCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>sourceFC<SPAN class="punctuation token">,</SPAN> sourceFields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> sourceCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> sourceCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> numIDs<SPAN class="operator token">+</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> i <SPAN class="operator token"><</SPAN> <SPAN class="number token">10</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IDnumber <SPAN class="operator token">=</SPAN> <SPAN class="string token">"0"</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IDnumber <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; InternalID <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Termination <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Customer <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; circuitID <SPAN class="operator token">=</SPAN> <SPAN class="string token">"({})-({})-({})-({})"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>InternalID<SPAN class="punctuation token">,</SPAN>Termination<SPAN class="punctuation token">,</SPAN>Customer<SPAN class="punctuation token">,</SPAN>IDnumber<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; targetCursor<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>row <SPAN class="operator token">+</SPAN> <SPAN class="punctuation token">[</SPAN>circuitID<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>

This returned the same error as is shown above, though.

bixb0012

The code I provided should populate the CircuitID when the records are inserted/copied into the new table, so that warning and your statement that the records get inserted confuses me. You should no longer be using Calculate Field. Can you post your code?

Anonymous User

I didn't know you could work it like that. Thanks for the formatting tip also, I like that better than the way I did it before .

This doesn't quite work as intended, though. The script iterates through each feature and enters the appropriate amount of entries, but it does not populate the Circuit ID field. Each time it tries to do so, I get an error:

Here is the error documentation for reference: 000405: No records within table.—Help | ArcGIS Desktop

bixb0012

I haven't tested, but what about:

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping <SPAN class="keyword token">as</SPAN> map
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
<SPAN class="keyword token">import</SPAN> datetime


<SPAN class="comment token"># universal variables</SPAN>
mxd <SPAN class="operator token">=</SPAN> map<SPAN class="punctuation token">.</SPAN>MapDocument<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"CURRENT"</SPAN><SPAN class="punctuation token">)</SPAN>
mapName <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">.</SPAN>filePath<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'\\'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN>
nodeFeatures <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'OSP Mapping Layers\Node Locations'</SPAN>
circuitIDTable <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'Circuit ID Table'</SPAN>
strandsPerNode <SPAN class="operator token">=</SPAN> <SPAN class="number token">6</SPAN>&nbsp;&nbsp; <SPAN class="comment token"># arcpy.GetParameterAsText(0)</SPAN>
numIDs <SPAN class="operator token">=</SPAN> strandsPerNode<SPAN class="operator token">/</SPAN><SPAN class="number token">2</SPAN>

<SPAN class="comment token"># Set local variables</SPAN>
targetTBL <SPAN class="operator token">=</SPAN> circuitIDTable
targetFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'SimpleID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ExtendedID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'InternalID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ExternalID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Termination'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectRegion'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectState'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectName'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectCustomer'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'NodeGUID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'CircuitID'</SPAN><SPAN class="punctuation token">]</SPAN>
sourceFC <SPAN class="operator token">=</SPAN> nodeFeatures
sourceFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'SimpleID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ExtendedID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'InternalID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ExternalID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Termination'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectRegion'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectState'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectName'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectCustomer'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'GlobalID'</SPAN><SPAN class="punctuation token">]</SPAN>



<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>targetTBL<SPAN class="punctuation token">,</SPAN> targetFields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> targetCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>sourceFC<SPAN class="punctuation token">,</SPAN> sourceFields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> sourceCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> sourceCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> numIDs<SPAN class="operator token">+</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> i <SPAN class="operator token"><</SPAN> <SPAN class="number token">10</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IDnumber <SPAN class="operator token">=</SPAN> <SPAN class="string token">"0"</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IDnumber <SPAN class="operator token">=</SPAN> i
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; circuitID <SPAN class="operator token">=</SPAN> <SPAN class="string token">"({})-({})-({})-({})"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>IDnumber<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; targetCursor<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>row <SPAN class="operator token">+</SPAN> <SPAN class="punctuation token">[</SPAN>circuitID<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <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>

Anonymous User

Your code did end up pushing me in the right direction. Thank you! I didn't fully understand your references to OID's, so I left that portion out. I'm not really sure what impact that will have, though. I have another question in a reply to the original message as well.

Since your method was the one that answered my original question, I will likely mark your response as the answer.

Anonymous User

Okay, I have a somewhat working script, but it's not complete just yet.

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping <SPAN class="keyword token">as</SPAN> map
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
<SPAN class="keyword token">import</SPAN> datetime


<SPAN class="comment token"># universal variables</SPAN>
mxd <SPAN class="operator token">=</SPAN> map<SPAN class="punctuation token">.</SPAN>MapDocument<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"CURRENT"</SPAN><SPAN class="punctuation token">)</SPAN>
mapName <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">.</SPAN>filePath<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'\\'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN>
nodeFeatures <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'OSP Mapping Layers\Node Locations'</SPAN>
circuitIDTable <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'Circuit ID Table'</SPAN>
strandsPerNode <SPAN class="operator token">=</SPAN> <SPAN class="number token">6</SPAN>&nbsp;&nbsp; <SPAN class="comment token"># arcpy.GetParameterAsText(0)</SPAN>
numIDs <SPAN class="operator token">=</SPAN> strandsPerNode<SPAN class="operator token">/</SPAN><SPAN class="number token">2</SPAN>

<SPAN class="comment token"># Set local variables</SPAN>
targetTBL <SPAN class="operator token">=</SPAN> circuitIDTable
targetFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'SimpleID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ExtendedID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'InternalID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ExternalID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Termination'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectRegion'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectState'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectName'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectCustomer'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'NodeGUID'</SPAN><SPAN class="punctuation token">]</SPAN>
sourceFC <SPAN class="operator token">=</SPAN> nodeFeatures
sourceFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'SimpleID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ExtendedID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'InternalID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ExternalID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Termination'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectRegion'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectState'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectName'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectCustomer'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'GlobalID'</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># Execute Insert Cursor and Search Cursor</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>targetTBL<SPAN class="punctuation token">,</SPAN> targetFields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> targetCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>sourceFC<SPAN class="punctuation token">,</SPAN> sourceFields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> sourceCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> sourceCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> numIDs<SPAN class="operator token">+</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; targetCursor<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>row<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>

Everything up to this point works just fine. The script takes the value that will be entered by the user, derives the correct number of IDs needed, and then generates the appropriate number of entries, as well as porting over the appropriate attributes into their corresponding fields:

In this image here you can see that the tool recognized that each site needed 3 entries per site (reference the GUIDs), and it ported over the appropriate information for Region, State, and Name (others pulled over too, just keeping image small).

However, at this point the Circuit ID field is blank. This field is a concatenation of the InternalID, Termination, and ProjectCustomer fields, and then a 2 digit number. So I added the following code to generate the Circuit ID's (row 1 here is the same as row 22 above):

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>targetTBL<SPAN class="punctuation token">,</SPAN> targetFields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> targetCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>sourceFC<SPAN class="punctuation token">,</SPAN> sourceFields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> sourceCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> sourceCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> numIDs<SPAN class="operator token">+</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; targetCursor<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; calcTable <SPAN class="operator token">=</SPAN> circuitIDTable
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; calcField <SPAN class="operator token">=</SPAN> <SPAN class="string token">"CircuitID"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> i <SPAN class="operator token"><</SPAN> <SPAN class="number token">10</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IDnumber <SPAN class="operator token">=</SPAN> <SPAN class="string token">"0"</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IDnumber <SPAN class="operator token">=</SPAN> i
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; expression <SPAN class="operator token">=</SPAN> <SPAN class="string token">"'(' + row[2] + ')-(' + row[4] + ')-(' + row[8] + ')-(' + str(IDnumber) + ')'"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>calcTable<SPAN class="punctuation token">,</SPAN> calcField<SPAN class="punctuation token">,</SPAN> expression<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"PYTHON_9.3"</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>

In this image you can see that it calculated the Circuit ID as desired:

However, the operation stops at this point and I get this error:

Essentially I have everything I need with the code that I have, but I need to tweak it to continue through the iteration and create the rest of the Circuit ID's. The desired result would look like this:

Thanks!

Anonymous User

Thank you for this sample. I believe that the combination of the this logic and the logic listed below in Joshua's sample, I will be able to work something up to get started.

Anonymous User

Joshua,

Following the logic on this it does appear like this is the right direction for what I need. I will try to work something up and see where I get. Thanks for providing this sample!

bixb0012

A general structure for inserting records into a target table from a source table:

tbl_src <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># path to source table</SPAN>
tbl_tar <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># path to target table</SPAN>
flds <SPAN class="operator token">=</SPAN>&nbsp; <SPAN class="comment token"># list of field names for target table, exluding OID</SPAN>
cnts <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># dict or other structure for looking up number of records to copy</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>tbl_tar<SPAN class="punctuation token">,</SPAN> flds<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> icur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>tbl_src<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OID@"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> flds<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; oid <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> cnts<SPAN class="punctuation token">[</SPAN>oid<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; icur<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>row<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>

Anonymous User

Vince/Dan,

Thanks for your responses. I will clarify the parameters a bit more.

I am working in Desktop 10.4.1, and the data references are housed in a 10.2.2 SDE geodatabase.

The code above was just a sample to illustrate how I've used the functions in the past, and mainly to highlight that I've only ever referenced one layer and its associated set of fields.

Here's a sample that I have used with InsertCursor:

<SPAN class="keyword token">import</SPAN> arcpy
table <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'FiberStrands'</SPAN>
i <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN>

cursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'ProjectID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'SegmentID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'StrandNumber'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">73</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursor<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"NAME HERE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Segment ID 1"</SPAN><SPAN class="punctuation token">,</SPAN> i<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>

That sample iterated through the number in "i" and created as many entries as was given by the user. *NOTE* I slapped that together, so it may not be 100% correct. Just know that it worked whenever I originally made it .

The table that the entries are to be placed in is an already configured table which is used to house a set of information pertaining to the features in the original feature class. This information can range anywhere from a single entry per feature, up to 72 entries per feature. So the user input tells the tool how many entries per feature are needed, the data that comes from the feature class to the table is primarily for sorting/query purposes, with one of those fields being a related GUID value, and then the tool will populate a number of other fields using field calculator (concatenation mainly).

Our current method of capturing this attribute information is by allocating 10 fields in the feature class. However, this either limits us to 10 fields in the cases that require more than 10 ID's created (rare occurrence, but does happen occasionally), or it leaves a number of fields unused in the event that we only need 1 or 2 ID's. Thus, the initiative to move this ID collection to a related table.

RachelAlbritton

If I'm understanding what you need - try using a search cursor to read the values from the source table and then use an insert cursor to insert those values into the second table. Something like this should work:

sc <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>featureClassName<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> sc<SPAN class="punctuation token">:</SPAN>
 
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#Get Field Values</SPAN>
&nbsp;&nbsp;&nbsp; fieldValue <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">.</SPAN>fieldValue
&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#Use insert cursor to write values to the destination table or feature class</SPAN>
&nbsp;&nbsp;&nbsp; intcur <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>destinationTable<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; icur <SPAN class="operator token">=</SPAN> intcur<SPAN class="punctuation token">.</SPAN>newRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; icur<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Field Name"</SPAN><SPAN class="punctuation token">,</SPAN> fieldValue<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; intcur<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>icur<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> intcur
 
 <SPAN class="keyword token">del</SPAN> row
 <SPAN class="keyword token">del</SPAN> sc<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>

DanPatterson_Retired

why not use Select by Attributes or Select by Location to get the features you need.. then follow that by a Copy Features to a new file... Delete Fields if there are some fields you don't want... or maybe an AddField if you want one with a specific name, then a Calculate Field to get values from the old table, whose field name you don't like, into the new field.

If you emulate that workflow, does it give you what you want? if it does, you can simplify your script writing by using the existing tools. Once you get that working, you can strip the functionality down to searchcursors, insertcursors and update cursors if you really need to

VinceAngelo

There seems to be some pieces missing from your code sample. arcpy.da.InsertCursor creates rows, and arcpy.da.UpdateCursor changes specific rows. You seem to be trying to use UpdateCursor to insert rows. If you really want to update rows, then you should be applying a where_clause to limit the interaction to the affected rows.

Please remember to specify the exact version of software in use and what the data source(s) is/are (file geodatabase has different SQL options than a real database).

- V

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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