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

using python scripts in models

YousafHassan

Hi I am trying to use python script in a model but it is throwing an error message:

ERROR 000539: Runtime error <type 'exceptions.NameError'>: name 'table2' is not defined
Failed to execute (Calculate Field).

I guess, it is about how to use table2 in the CalculateField_management function. I am not sure how I can do it.

I have attached the screen shot of my model and the script. Any help would be really appreciated.

Thanks

pythonModel.JPG

Vind meer berichten getagd met

Accepted answers

All comments

YousafHassan

I changed the expression type to PYTHON_9.3 and it's working now.

YousafHassan

Hi
I am using 10 with an ArcView licence, so don't have access to Feature To Point tool.

Which version, 9.2, 9.3 and 10.x all have different syntax to access the shape field properties.

I recommend you instead of accessing the centroid this way, take an easier path: use the out of the box Feature To Point tool followed by the Add XY Coordinates tool.

YousafHassan

Hi

I have attached the zip which contains the shape file. Please have a look.

Thanks.

The * is okay, that just means the field is binary, which is a good thing. The csv export you posted doesn't have a shape field, and doesn't contain the original field formats, so it doesn't help much with determining the problem. Please see the attached screenshots for proper export technique.

test.zip

curtvprice

Which version, 9.2, 9.3 and 10.x all have different syntax to access the shape field properties.

I recommend you instead of accessing the centroid this way, take an easier path: use the out of the box Feature To Point tool followed by the Add XY Coordinates tool.

ChristopherStorer

The * is okay, that just means the field is binary, which is a good thing. The csv export you posted doesn't have a shape field, and doesn't contain the original field formats, so it doesn't help much with determining the problem. Please see the attached screenshots for proper export technique.

Well that's interesting. You do have a shape field called Shape, I assume? Maybe you can attach a one-record copy of this table so we can reproduce the error.

Yes, the Shape field is there but it is called Shape * see the attached screen shot. Also, I have attached a record for you.

shapefield.JPG

Export_Output.txt.zip

ChristopherStorer

Well that's interesting. You do have a shape field called Shape, I assume? Maybe you can attach a one-record copy of this table so we can reproduce the error.

YousafHassan

You have the right idea; you're just making it more complicated than it needs to be. Try:
arcpy.CalculateField_management(test_poly, "X_COORD", "!Shape!.centroid.x", "PYTHON", "")
I have attached a screenshot below.

Hi
I've tried that but it is throwing this error:

Executing (Calculate Field): CalculateField BuildingTest Easting !Shape!.centroid.x PYTHON #
Start Time: Wed Oct 19 15:36:21 2011
ERROR 000539: Error running expression: GPVARIANTOBJECT0.centroid.x <type 'exceptions.AttributeError'>: 'str' object has no attribute 'x'
Failed to execute (Calculate Field).
Failed at Wed Oct 19 15:36:21 2011 (Elapsed Time: 0.00 seconds)

ChristopherStorer

You have the right idea; you're just making it more complicated than it needs to be. Try:

arcpy.CalculateField_management(test_poly, "X_COORD", "!Shape!.centroid.x", "PYTHON", "")

I have attached a screenshot below.

ScreenShot020.JPG

YousafHassan

Hi

I am trying to do what this example is showing in VB:

http://support.esri.com/en/knowledgebase/techarticles/detail/32482

I am trying to use python instead of VB.

StacyRendall1

That is not the way to use a Python script.

You were trying to put a script inside the Field Calculator. The field calculator can have some Python stuff in it, but only basic operators. What is it you want to do inside the tool? The tool you have showing IS the calculateField_management() tool that you have in your script... I.e. you can just do it directly...

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.