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

Calulate Field in model Builder Script Not working

WilliamIde

I am have a created a model in Model builder to Calculate a date field from an existing field to a new field that I just created. The model works fine. However now I would like to expand this functionality by growing the script. Well right at the start I tried to run it un-modified from model builder. No go.
I am running Arc 10. All it includes is:

import arcpy

The error is 000732

I notice that the imports are different from 9.3 to 10. Any clue as to why this doesn't work? Is Calculate field one of the tools that don't work in python? I there a work around?
Urban

Find more posts tagged with

Accepted answers

All comments

WilliamIde

Turns out I had multiple nit niods. First. env=\myproj\mygdb.gdb Second I was using a personal gdb not a file gdb. The locks and permissions are not quite the same. Other than that it works a charm.

WilliamIde

Mine is almost exactly that except for the # at the end. I posted all of code and error messages that I have.

MathewCoyle

It's hard to narrow down your error without the specific code you are using and error messages you are getting.

If you are referencing an existing field, it should look like

arcpy.CalculateField_management(mag_subset__2_,"RM_DATE_MODIFIED","!REPORT_DATE!","PYTHON_9.3","#")

WilliamIde

I had to type the whole thing because the system I am working on is not on a network. The tokens are the same mag_subset__2_

MathewCoyle

mag_subset__2_ != mag_subset___

That's most likely your main problem.

Exporting models to python rarely works as intended raw, it gives you a good framework on which to build.

WilliamIde

OK Here is the Script.

#-______
#
# Mag_fieldcalc5.py
#
# Description
#---------

#import Arcpy
import arcpy

#local Variables
mag_subset__2_ = "fdmag_subset"

# Process: Calculate Field

arcpy.CalculateField_management(mag_subset___,"RM_DATE_MODIFIED","[REPORT_DATE]", "PYTHON_9.3", "")

Here is the Error listing:

Trackeback ( most recent call last)
File "D:\Projects\mag_fieldcalc5.py", Line 16 in <module>
arcpy.CalculateField_management(mag_subset___,"RM_DATE_MODIFIED","[REPORT_DATE]", "PYTHON_9.3", "")
File "c:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy\management.py", line 2727, in CalculateField
raise e
ExecuteError: Failed to execute. Parameters are not valid.
ERROR 000732: Imput Table: Dataset mag_subset does not exist or is not supported
Failed to execute (CalculateField)

Again this is how it was exported out of the Model Builder.

Usually I break things after I fool with them. But, this is broken right out of the box.

MathewCoyle

I highly doubt you are getting a 732 error from simply importing arcpy, can you try posting the entire code in

code tags?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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