arcgis-9.3arcgis-desktopmodelbuilder
I'm having some problems adapting a few models inherited by me from a colleague.
Inside this model, we attempt to calculate Summary Statistics, but the model can't find the field that it needs to use. ModelBuilder refuses to show it to me, despite the fact that the Feature Class in this calculation possesses the field in question.
Has anyone seen weird problems like this one?
The original model was for 9.3 and I'm rebuilding it in 9.3.1. Any pitfalls I'm not aware?
If I'm understanding the need correctly, you could modify the validation code so it will populate the list after selecting a layer. You might have to convert to a python script to get to it (it's in the Script Properties under the Validation tab).
The validation code contains functions that are run when the tool is opened, when a parameter is changed, and after internal validation runs. It doesn't reference a script file like the tool itself does. You have to either edit in place and save, or copy and paste your code in.
I modified this validation code to disable some parameter fields until the first parameter is picked. It also populates a pick list by grabbing the unique values from a feature class's attribute field. Basically, it's set up to wait for a connection to be picked by the user, uses that connection to look at feature class, populates a list based on the values found for one of the FC's fields, and only then makes the rest of the parameters available to fill in.
import arcpy
class ToolValidator:
"""Class for validating a tool's parameter values and controlling
the behavior of the tool's dialog."""
def __init__(self):
"""Setup the Geoprocessor and the list of tool parameters."""
self.params = arcpy.GetParameterInfo()
self.X = 0
def initializeParameters(self):
"""Refine the properties of a tool's parameters. This method is
called when the tool is opened."""
self.params[1].enabled = False
self.params[2].enabled = False
self.params[3].enabled = False
#self.params[4].value = "False" #for debugging
return
def updateParameters(self):
"""Modify the values and properties of parameters before internal
validation is performed. This method is called whenever a parameter
has been changed."""
if self.X == 0:
if self.params[0].altered == True:
FC = str(self.params[0].value) + "\\gis.ELEC.ElectricDataset\\gis.ELEC.eCircuitBreaker"
self.params[4].value = FC
Col = "FeederID"
self.params[1].filter.list = [str(val) for val in \
sorted(\
set(\
row.getValue(Col) for row in \
arcpy.SearchCursor(FC, None, None, Col)\
)\
)\
]
self.params[1].enabled = True
self.params[2].enabled = True
self.params[3].enabled = True
self.X = 1
#self.params[4].value = "True" #for debugging
return
def updateMessages(self):
"""Modify the messages created by internal validation for each tool
parameter. This method is called after internal validation."""
return
Some resources on script validation:
You need to use the %Name% inline variable for your output table names
Best Answer
Try running the model from 'Edit' mode only up to the output just prior to the 'Summary Stats' tool. Then open the Summary Stats tool and see if the correct variables, etc have populated. Sometimes models need to be run once successfully before populating the 'next tool' correctly. It's wierd, but on the rare occassion that has happened to me, that usually works for me. Validate the model as well, then save.