topic Help with Python Scripting in Python Questions

Help with Python Scripting

NoraAllen — Tue, 20 Mar 2012 14:18:12 GMT

I have a database with two tables populated with at least 10,000 records each. I have set up new subtyped fields and want to fill them. However, the editing process is very slow with the amount of data that I have. Is there a way to write a python program that automates the editing process?

Re: Help with Python Scripting

MathewCoyle — Tue, 20 Mar 2012 14:25:04 GMT

Very likely, yes.

P.S. Try giving more information.

Re: Help with Python Scripting

NoraAllen — Wed, 21 Mar 2012 23:55:42 GMT

I am relatively new at scripting, but what I came up with is this:

cur = arcpy.UpdateCursor(FC)
for row in cur:
    try:
        fieldVal = row.getValue(fieldOne)
        if fieldVal = xxxxxxx:
            value =
            row.setValue(newField, value)

I feel like I am on the right track, but I have no idea how to utilize an existing subtype. How do you bring subtypes into a python program?

Re: Help with Python Scripting

Luke_Pinner — Sat, 11 Dec 2021 15:24:21 GMT

First things first... read thisthread and put code tags around your script.

Like so:

cur = arcpy.UpdateCursor(FC)
for row in cur:
    try:
        fieldVal = row.getValue(fieldOne)
        if fieldVal = xxxxxxx:
            value =
            row.setValue(newField, value)

A few issues:

a try: statement must have an except: clause

equality tests use "==" not "="

"value =" needs a value or it will cause a syntax error, i.e. value = "something"

E.g.

cur = arcpy.UpdateCursor(FC)
for row in cur:
    try:
        fieldVal = row.getValue(fieldOne)
        if fieldVal == xxxxxxx:
            value = row.setValue(newField, value)
    except Exception as err:
        Do something useful here or don't use try except at all

For any more assistance you need to give us more info - are you calculating for each of the 2 tables separately, are they joined, do you have to get the value for "newField" from another field in the table/s, etc...?