Hi folks, with help of https://community.esri.com/people/xander_bakker/blog/2016/07/19/implementing-cascading-drop-down-lists-in-a-toolbox-using-validation-with-python I gained some understanding how I can make my script tool take conditions and additional information to fill the tool. I have three input parameters (a directory, a min and a max value). I would like to have a multiple choice list of those indicators in my txt file (in that directory) that are not empty. My validator should check the first txt file in that directory, read the field names, if they are not within a list of excluded field names then read the first value, if it is not None than add the field name to a list. Works perfectly in pyscripter. And I also get the correct list displayed in my tool script. Buuut, the tool says the parameter's field type is invalid after displaying the field names. I could imagine that it has something to do with the filter in the parameter which is set to DataType=Field but of course it is not really a field name any longer after returning it from my script. But what else could I use? Or can I somehow tell the self.params that it is still a (list of) field name(s)? This is my updateParameters. 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 filedir : arcpy . env . workspace = filedir list_of_files = arcpy . ListFiles ( "*.txt" ) firsttable = list_of_files [ 0 ] print ( firsttable ) print ( filedir ) complete_filename = str ( filedir ) + "\\" + firsttable print ( complete_filename ) table = arcpy . MakeTableView_management ( complete_filename , "kivu_tview" ) desc = arcpy . Describe ( table ) #fieldnamesoriginal=[field.name.encode("utf-8") for field in desc.fields] ##collects all fieldnames fieldselectlist = [ ] for ofields in desc . fields : ftype = ofields . type fname = ofields . name . encode ( "utf-8" ) if ftype == "Double" or ftype == "Long" : print ( fname ) if fname != "Profile_No" and fname != "Longitude (degrees_east)" and fname != "Latitude (degrees_north)" and fname != "Bot. Depth (m)" and fname != "Depth (m)" : with arcpy . da . SearchCursor ( table , fname ) as calcursor : for calcrow in calcursor : if calcrow [ 0 ] is not None : fieldselectlist . append ( fname ) break print ( fieldselectlist ) self . params [ 3 ] . filter . list = fieldselectlist self . params [ 3 ] . value = fieldselectlist return Any hint would be highly appreciated.

I put your code in a debugging template found on this page: Debugging a ToolValidator class. I only made a few changes, mostly using self.params[0], etc. to access the parameters. I kept the MakeTableView because it aided in identifying the field types. It might be possible to read the text file's first line directly to get the field names, and the second line to determine field types. Print statements will work in the debug script, but they will not display once it is placed in the tool's validator section (and could cause errors). For this reason, they have been commented out. My first tool parameter was a folder type, the second was a string (for the field names). Here's my debug test code: import arcpy # Load the toolbox and get the tool's parameters, using the tool # name (not the tool label). # arcpy . ImportToolbox ( r "C:\Path\to\tool\box\dropdown.tbx" ) params = arcpy . GetParameterInfo ( "DropdownTest" ) # refresh toolbox in Catalog or ArcMap if changes made to tool/parameters # also close and restart Python IDE # Set required parameters # input, folder params [ 0 ] . value = r "C:\Users\Randy\Documents\ArcGIS\PythonScripts\test\text2field\encoding" # input, string ['Temperature (\xc2\xb0C)', 'pH', 'Chl_A (\xc2\xb5g/L)'] # params[1].value = 'Chl_A (\xb5g/L)' # for 1 value params [ 1 ] . values = [ 'pH' , 'Chl_A (\xb5g/L)' ] # for multiple values # ToolValidator class block ------------------------------------------------------------ # class ToolValidator ( object ) : """Class for validating a tool's parameter values and controlling the behavior of the tool's dialog.""" def __init__ ( self ) : """Setup arcpy and the list of tool parameters.""" self . params = arcpy . GetParameterInfo ( ) def initializeParameters ( self ) : """Refine the properties of a tool's parameters. This method is called when the tool is opened.""" 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 . params [ 0 ] . altered : if self . params [ 0 ] . value : # a folder has been entered in first parameter arcpy . env . workspace = filedir = self . params [ 0 ] . value list_of_files = arcpy . ListFiles ( "*.txt" ) firsttable = list_of_files [ 0 ] # print(firsttable) # print(filedir) complete_filename = str ( filedir ) + "\\" + firsttable # print(complete_filename) if arcpy . Exists ( "kivu_tview" ) : # if tableview exists then delete it arcpy . Delete_management ( "kivu_tview" ) table = arcpy . MakeTableView_management ( complete_filename , "kivu_tview" ) desc = arcpy . Describe ( table ) # fieldnamesoriginal=[field.name for field in desc.fields] # collects all fieldnames # print "Table view field names: "+str(fieldnamesoriginal) fieldselectlist = [ ] for ofields in desc . fields : ftype = ofields . type fname = ofields . name if ftype in [ "Double" , "Integer" , "Long" ] : # print fname if fname not in [ "Profile_No" , "Longitude (degrees_east)" , "Latitude (degrees_north)" , "Bot. Depth (m)" , "Depth (m)" ] : with arcpy . da . SearchCursor ( table , fname ) as calcursor : for calcrow in calcursor : if calcrow [ 0 ] is not None : fieldselectlist . append ( fname ) break # print fieldselectlist arcpy . Delete_management ( "kivu_tview" , "Table View" ) # delete table view # for multiple choice try : if self . params [ 1 ] . values : #if this parameter has seleted values oldValues = self . params [ 1 ] . values #set old values to the selected values except Exception : pass self . params [ 1 ] . filter . list = sorted ( fieldselectlist ) #set the filter list equal to the sorted values newValues = self . params [ 1 ] . filter . list try : if len ( oldValues ) : # if some values are selected self . params [ 1 ] . values = [ v for v in oldValues if v in newValues ] # check if seleted values in new list, # if yes, retain the seletion. except Exception : pass # for single choice # self.params[1].filter.list = sorted(fieldselectlist) # set second parameter filter list # if self.params[1].value not in self.params[1].filter.list: # self.params[1].value = self.params[1].filter.list[0] # default to first item in list return def updateMessages ( self ) : """Modify the messages created by internal validation for each tool parameter. This method is called after internal validation.""" return # Call routine(s) to debug ------------------------------------------------------------------------------------------ # validator = ToolValidator ( ) validator . updateParameters ( ) validator . updateMessages ( ) # testing results print ( arcpy . GetMessages ( ) ) print u "Folder: {}" . format ( params [ 0 ] . value ) # print u"Fields: {}".format(params[1].value) # for 1 value print u "Fields: {}" . format ( params [ 1 ] . values ) # for multiple values Once I was happy with the debug test, I pasted the ToolValidator section into the tool's validator. Hope this helps.

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

Push list of field names from validator into script tool

Nicole_Ueberschär

Hi folks,

with help of https://community.esri.com/people/xander_bakker/blog/2016/07/19/implementing-cascading-drop-down-lists-in-a-toolbox-using-validation-with-python I gained some understanding how I can make my script tool take conditions and additional information to fill the tool.

I have three input parameters (a directory, a min and a max value). I would like to have a multiple choice list of those indicators in my txt file (in that directory) that are not empty.

My validator should check the first txt file in that directory, read the field names, if they are not within a list of excluded field names then read the first value, if it is not None than add the field name to a list. Works perfectly in pyscripter.

And I also get the correct list displayed in my tool script. Buuut, the tool says the parameter's field type is invalid after displaying the field names. I could imagine that it has something to do with the filter in the parameter which is set to DataType=Field but of course it is not really a field name any longer after returning it from my script. But what else could I use? Or can I somehow tell the self.params that it is still a (list of) field name(s)?

This is my updateParameters.

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">updateParameters</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="string token">"""Modify the values and properties of parameters before internal
    validation is performed.  This method is called whenever a parameter
    has been changed."""</SPAN>
    <SPAN class="keyword token">if</SPAN> filedir<SPAN class="punctuation token">:</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> filedir
        list_of_files <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFiles<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"*.txt"</SPAN><SPAN class="punctuation token">)</SPAN>
        firsttable<SPAN class="operator token">=</SPAN>list_of_files<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>firsttable<SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>filedir<SPAN class="punctuation token">)</SPAN>
        complete_filename <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>filedir<SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">"\\"</SPAN><SPAN class="operator token">+</SPAN>firsttable

        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>complete_filename<SPAN class="punctuation token">)</SPAN>
        table<SPAN class="operator token">=</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>MakeTableView_management<SPAN class="punctuation token">(</SPAN>complete_filename<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"kivu_tview"</SPAN><SPAN class="punctuation token">)</SPAN>


        desc <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">)</SPAN>
        <SPAN class="comment token">#fieldnamesoriginal=[field.name.encode("utf-8") for field in desc.fields] ##collects all fieldnames</SPAN>
        fieldselectlist<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
        <SPAN class="keyword token">for</SPAN> ofields <SPAN class="keyword token">in</SPAN> desc<SPAN class="punctuation token">.</SPAN>fields<SPAN class="punctuation token">:</SPAN>
            ftype<SPAN class="operator token">=</SPAN>ofields<SPAN class="punctuation token">.</SPAN>type
            fname<SPAN class="operator token">=</SPAN>ofields<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">.</SPAN>encode<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"utf-8"</SPAN><SPAN class="punctuation token">)</SPAN>
            <SPAN class="keyword token">if</SPAN> ftype<SPAN class="operator token">==</SPAN><SPAN class="string token">"Double"</SPAN> <SPAN class="operator token">or</SPAN> ftype<SPAN class="operator token">==</SPAN><SPAN class="string token">"Long"</SPAN><SPAN class="punctuation token">:</SPAN>
                <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>fname<SPAN class="punctuation token">)</SPAN>
                <SPAN class="keyword token">if</SPAN> fname<SPAN class="operator token">!=</SPAN><SPAN class="string token">"Profile_No"</SPAN> <SPAN class="operator token">and</SPAN> fname<SPAN class="operator token">!=</SPAN><SPAN class="string token">"Longitude (degrees_east)"</SPAN> <SPAN class="operator token">and</SPAN> fname<SPAN class="operator token">!=</SPAN><SPAN class="string token">"Latitude (degrees_north)"</SPAN> <SPAN class="operator token">and</SPAN> fname<SPAN class="operator token">!=</SPAN><SPAN class="string token">"Bot. Depth (m)"</SPAN> <SPAN class="operator token">and</SPAN> fname<SPAN class="operator token">!=</SPAN><SPAN class="string token">"Depth (m)"</SPAN><SPAN class="punctuation token">:</SPAN>
                    <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">,</SPAN> fname<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> calcursor<SPAN class="punctuation token">:</SPAN>
                        <SPAN class="keyword token">for</SPAN> calcrow <SPAN class="keyword token">in</SPAN> calcursor<SPAN class="punctuation token">:</SPAN>
                            <SPAN class="keyword token">if</SPAN> calcrow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">is</SPAN> <SPAN class="operator token">not</SPAN> None<SPAN class="punctuation token">:</SPAN>
                               fieldselectlist<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>fname<SPAN class="punctuation token">)</SPAN>
                               <SPAN class="keyword token">break</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>fieldselectlist<SPAN class="punctuation token">)</SPAN>
        self<SPAN class="punctuation token">.</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>filter<SPAN class="punctuation token">.</SPAN>list <SPAN class="operator token">=</SPAN>fieldselectlist
        self<SPAN class="punctuation token">.</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>value<SPAN class="operator token">=</SPAN>fieldselectlist
    <SPAN class="keyword token">return</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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Any hint would be highly appreciated.

Find more posts tagged with

Accepted answers

RandyBurton

I put your code in a debugging template found on this page: Debugging a ToolValidator class. I only made a few changes, mostly using self.params[0], etc. to access the parameters. I kept the MakeTableView because it aided in identifying the field types. It might be possible to read the text file's first line directly to get the field names, and the second line to determine field types. Print statements will work in the debug script, but they will not display once it is placed in the tool's validator section (and could cause errors). For this reason, they have been commented out.

My first tool parameter was a folder type, the second was a string (for the field names). Here's my debug test code:

<SPAN class="keyword token">import</SPAN> arcpy

<SPAN class="comment token"># Load the toolbox and get the tool's parameters, using the tool</SPAN>
<SPAN class="comment token">#  name (not the tool label).</SPAN>
<SPAN class="comment token">#</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>ImportToolbox<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"C:\Path\to\tool\box\dropdown.tbx"</SPAN><SPAN class="punctuation token">)</SPAN>
params <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterInfo<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"DropdownTest"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># refresh toolbox in Catalog or ArcMap if changes made to tool/parameters</SPAN>
<SPAN class="comment token"># also close and restart Python IDE</SPAN>

<SPAN class="comment token"># Set required parameters</SPAN>

<SPAN class="comment token"># input, folder</SPAN>
params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>value <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Users\Randy\Documents\ArcGIS\PythonScripts\test\text2field\encoding"</SPAN>
<SPAN class="comment token"># input, string ['Temperature (\xc2\xb0C)', 'pH', 'Chl_A (\xc2\xb5g/L)']</SPAN>
<SPAN class="comment token"># params[1].value = 'Chl_A (\xb5g/L)' # for 1 value</SPAN>
params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>values <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'pH'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Chl_A (\xb5g/L)'</SPAN> <SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># for multiple values</SPAN>

<SPAN class="comment token"># ToolValidator class block ------------------------------------------------------------</SPAN>
<SPAN class="comment token">#</SPAN>
<SPAN class="keyword token">class</SPAN> <SPAN class="token class-name">ToolValidator</SPAN><SPAN class="punctuation token">(</SPAN>object<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="string token">"""Class for validating a tool's parameter values and controlling
    the behavior of the tool's dialog."""</SPAN>

    <SPAN class="keyword token">def</SPAN> <SPAN class="token function">__init__</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="string token">"""Setup arcpy and the list of tool parameters."""</SPAN>
        self<SPAN class="punctuation token">.</SPAN>params <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterInfo<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

    <SPAN class="keyword token">def</SPAN> <SPAN class="token function">initializeParameters</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="string token">"""Refine the properties of a tool's parameters.  This method is
        called when the tool is opened."""</SPAN>
        <SPAN class="keyword token">return</SPAN>

    <SPAN class="keyword token">def</SPAN> <SPAN class="token function">updateParameters</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="string token">"""Modify the values and properties of parameters before internal
        validation is performed.  This method is called whenever a parameter
        has been changed."""</SPAN>

        <SPAN class="keyword token">if</SPAN> self<SPAN class="punctuation token">.</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>altered<SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">if</SPAN> self<SPAN class="punctuation token">.</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>value<SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># a folder has been entered in first parameter</SPAN>
                arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> filedir <SPAN class="operator token">=</SPAN> self<SPAN class="punctuation token">.</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>value

                list_of_files <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFiles<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"*.txt"</SPAN><SPAN class="punctuation token">)</SPAN>
                firsttable<SPAN class="operator token">=</SPAN>list_of_files<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
                <SPAN class="comment token"># print(firsttable)</SPAN>
                <SPAN class="comment token"># print(filedir)</SPAN>
                complete_filename <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>filedir<SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">"\\"</SPAN><SPAN class="operator token">+</SPAN>firsttable
                <SPAN class="comment token"># print(complete_filename)</SPAN>

                <SPAN class="keyword token">if</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"kivu_tview"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token">#  if tableview exists then delete it</SPAN>
                    arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"kivu_tview"</SPAN><SPAN class="punctuation token">)</SPAN>
                table<SPAN class="operator token">=</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>MakeTableView_management<SPAN class="punctuation token">(</SPAN>complete_filename<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"kivu_tview"</SPAN><SPAN class="punctuation token">)</SPAN>
            
                desc <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">)</SPAN>
                <SPAN class="comment token"># fieldnamesoriginal=[field.name for field in desc.fields] # collects all fieldnames</SPAN>
                <SPAN class="comment token"># print "Table view field names: "+str(fieldnamesoriginal)</SPAN>
                fieldselectlist<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
                <SPAN class="keyword token">for</SPAN> ofields <SPAN class="keyword token">in</SPAN> desc<SPAN class="punctuation token">.</SPAN>fields<SPAN class="punctuation token">:</SPAN>
                    ftype<SPAN class="operator token">=</SPAN>ofields<SPAN class="punctuation token">.</SPAN>type
                    fname<SPAN class="operator token">=</SPAN>ofields<SPAN class="punctuation token">.</SPAN>name
                    <SPAN class="keyword token">if</SPAN> ftype <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Double"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Integer"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Long"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
                        <SPAN class="comment token"># print fname</SPAN>
                        <SPAN class="keyword token">if</SPAN> fname <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Profile_No"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Longitude (degrees_east)"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Latitude (degrees_north)"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Bot. Depth (m)"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Depth (m)"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
                            <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">,</SPAN> fname<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> calcursor<SPAN class="punctuation token">:</SPAN>
                                <SPAN class="keyword token">for</SPAN> calcrow <SPAN class="keyword token">in</SPAN> calcursor<SPAN class="punctuation token">:</SPAN>
                                    <SPAN class="keyword token">if</SPAN> calcrow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">is</SPAN> <SPAN class="operator token">not</SPAN> None<SPAN class="punctuation token">:</SPAN>
                                       fieldselectlist<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>fname<SPAN class="punctuation token">)</SPAN>
                                       <SPAN class="keyword token">break</SPAN>
                <SPAN class="comment token"># print fieldselectlist</SPAN>
                arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"kivu_tview"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Table View"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># delete table view</SPAN>

                <SPAN class="comment token"># for multiple choice</SPAN>
                <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
                    <SPAN class="keyword token">if</SPAN> self<SPAN class="punctuation token">.</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>values<SPAN class="punctuation token">:</SPAN> <SPAN class="comment token">#if this parameter has seleted values</SPAN>
                        oldValues <SPAN class="operator token">=</SPAN> self<SPAN class="punctuation token">.</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>values <SPAN class="comment token">#set old values to the selected values</SPAN>
                <SPAN class="keyword token">except</SPAN> Exception<SPAN class="punctuation token">:</SPAN>
                    <SPAN class="keyword token">pass</SPAN>
                self<SPAN class="punctuation token">.</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>filter<SPAN class="punctuation token">.</SPAN>list <SPAN class="operator token">=</SPAN> sorted<SPAN class="punctuation token">(</SPAN>fieldselectlist<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#set the filter list equal to the sorted values</SPAN>
                newValues <SPAN class="operator token">=</SPAN> self<SPAN class="punctuation token">.</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>filter<SPAN class="punctuation token">.</SPAN>list
                <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
                    <SPAN class="keyword token">if</SPAN> len<SPAN class="punctuation token">(</SPAN>oldValues<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># if some values are selected</SPAN>
                        self<SPAN class="punctuation token">.</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>values <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>v <SPAN class="keyword token">for</SPAN> v <SPAN class="keyword token">in</SPAN> oldValues <SPAN class="keyword token">if</SPAN> v <SPAN class="keyword token">in</SPAN> newValues<SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># check if seleted values in new list,</SPAN>
                        <SPAN class="comment token"># if yes, retain the seletion.</SPAN>
                <SPAN class="keyword token">except</SPAN> Exception<SPAN class="punctuation token">:</SPAN>
                    <SPAN class="keyword token">pass</SPAN>

                <SPAN class="comment token"># for single choice</SPAN>
                <SPAN class="comment token"># self.params[1].filter.list = sorted(fieldselectlist) # set second parameter filter list</SPAN>
                <SPAN class="comment token"># if self.params[1].value not in self.params[1].filter.list:</SPAN>
                <SPAN class="comment token">#     self.params[1].value = self.params[1].filter.list[0] # default to first item in list</SPAN>

        <SPAN class="keyword token">return</SPAN>

    <SPAN class="keyword token">def</SPAN> <SPAN class="token function">updateMessages</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="string token">"""Modify the messages created by internal validation for each tool
        parameter.  This method is called after internal validation."""</SPAN>
        <SPAN class="keyword token">return</SPAN>

<SPAN class="comment token"># Call routine(s) to debug ------------------------------------------------------------------------------------------</SPAN>
<SPAN class="comment token">#</SPAN>
validator <SPAN class="operator token">=</SPAN> ToolValidator<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
validator<SPAN class="punctuation token">.</SPAN>updateParameters<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
validator<SPAN class="punctuation token">.</SPAN>updateMessages<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># testing results</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetMessages<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> u<SPAN class="string token">"Folder: {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>value<SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># print u"Fields: {}".format(params[1].value) # for 1 value</SPAN>
<SPAN class="keyword token">print</SPAN> u<SPAN class="string token">"Fields: {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>values<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># for multiple values</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>‍</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><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>‍</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>

Once I was happy with the debug test, I pasted the ToolValidator section into the tool's validator.

Hope this helps.

All comments

Nicole_Ueberschär

Strange... For me both don't do anything.

RandyBurton

I had used the select all button the tool interface provides without a problem. I did not try the deselect button but will check it out later.

Nicole_Ueberschär

Is there a way to enable the "Select all/unselect all" functionality for the tool?

I was able to "select all" after loading the list through the validator but the buttons inside the tool don't work. I guess that would another "on change" event but how do I catch that?

Nicole_Ueberschär

Thanks a lot!

RandyBurton

I posted updated validator code above. I hadn't considered that you are using a multivalue selection list. In addition, there is a check that needed to be done to see if any fields were selected. I also updated the single selection check but commented it out.

Since some of your fields are using extended characters, those field name parameters will be inside single quotes.

See also:

Generating a choice list from a field

Generating a multivalue choice list

Hope this helps.

Nicole_Ueberschär

I figured out that I should leave the value unset (so just remove the last line before return) to not preset a value.

But I still get a "Bad file descriptor" error message...

Nicole_Ueberschär

Only that I get now an error message when trying to execute the tool:

If I interprete the line numbers correctly (does it count in the comments?), line 4 should be list_of_files = arcpy.ListFiles("*.txt") (or around there) and line 51 would be the last line. But I can click OK and then my main script starts running.

It still behaves a bit funny because it would not allow me to "unselect all fields". Also when I unselected a couple of field names then they would be turned back on when clicking "OK" to start the tool.

The same the other way around: When I put the value='' then it would not allow me to make a selection.

Not perfect yet...

Nicole_Ueberschär

Thanks Randy but it still not returning the field names in the required way. This is only writing "Short" as an option to my choice list and also this has the wrong data type because it is not a field name. I don't even know where "Short" is coming from.

I am debugging in PyScripter and everything works fine except of pushing the values back. I need a multiple values list to select my field names from.

Ha, I changed the data type to string and then the tool accepts the input but when executing the tool!

I passed the list as it is:

        self<SPAN class="punctuation token">.</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>filter<SPAN class="punctuation token">.</SPAN>list<SPAN class="operator token">=</SPAN>sorted<SPAN class="punctuation token">(</SPAN>fieldselectlist<SPAN class="punctuation token">)</SPAN>
        self<SPAN class="punctuation token">.</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>value<SPAN class="operator token">=</SPAN>sorted<SPAN class="punctuation token">(</SPAN>fieldselectlist<SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I'm not sure though if the first line is even necessary. But it works. Now I just have to adjust the main script to "eat" my list...

RandyBurton

My first tool parameter was a folder type, the second was a string (for the field names). Here's my debug test code:

<SPAN class="keyword token">import</SPAN> arcpy

<SPAN class="comment token"># Load the toolbox and get the tool's parameters, using the tool</SPAN>
<SPAN class="comment token">#  name (not the tool label).</SPAN>
<SPAN class="comment token">#</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>ImportToolbox<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"C:\Path\to\tool\box\dropdown.tbx"</SPAN><SPAN class="punctuation token">)</SPAN>
params <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterInfo<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"DropdownTest"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># refresh toolbox in Catalog or ArcMap if changes made to tool/parameters</SPAN>
<SPAN class="comment token"># also close and restart Python IDE</SPAN>

<SPAN class="comment token"># Set required parameters</SPAN>

<SPAN class="comment token"># input, folder</SPAN>
params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>value <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Users\Randy\Documents\ArcGIS\PythonScripts\test\text2field\encoding"</SPAN>
<SPAN class="comment token"># input, string ['Temperature (\xc2\xb0C)', 'pH', 'Chl_A (\xc2\xb5g/L)']</SPAN>
<SPAN class="comment token"># params[1].value = 'Chl_A (\xb5g/L)' # for 1 value</SPAN>
params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>values <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'pH'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Chl_A (\xb5g/L)'</SPAN> <SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># for multiple values</SPAN>

<SPAN class="comment token"># ToolValidator class block ------------------------------------------------------------</SPAN>
<SPAN class="comment token">#</SPAN>
<SPAN class="keyword token">class</SPAN> <SPAN class="token class-name">ToolValidator</SPAN><SPAN class="punctuation token">(</SPAN>object<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="string token">"""Class for validating a tool's parameter values and controlling
    the behavior of the tool's dialog."""</SPAN>

    <SPAN class="keyword token">def</SPAN> <SPAN class="token function">__init__</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="string token">"""Setup arcpy and the list of tool parameters."""</SPAN>
        self<SPAN class="punctuation token">.</SPAN>params <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterInfo<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

    <SPAN class="keyword token">def</SPAN> <SPAN class="token function">initializeParameters</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="string token">"""Refine the properties of a tool's parameters.  This method is
        called when the tool is opened."""</SPAN>
        <SPAN class="keyword token">return</SPAN>

    <SPAN class="keyword token">def</SPAN> <SPAN class="token function">updateParameters</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="string token">"""Modify the values and properties of parameters before internal
        validation is performed.  This method is called whenever a parameter
        has been changed."""</SPAN>

        <SPAN class="keyword token">if</SPAN> self<SPAN class="punctuation token">.</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>altered<SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">if</SPAN> self<SPAN class="punctuation token">.</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>value<SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># a folder has been entered in first parameter</SPAN>
                arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> filedir <SPAN class="operator token">=</SPAN> self<SPAN class="punctuation token">.</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>value

                list_of_files <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFiles<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"*.txt"</SPAN><SPAN class="punctuation token">)</SPAN>
                firsttable<SPAN class="operator token">=</SPAN>list_of_files<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
                <SPAN class="comment token"># print(firsttable)</SPAN>
                <SPAN class="comment token"># print(filedir)</SPAN>
                complete_filename <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>filedir<SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">"\\"</SPAN><SPAN class="operator token">+</SPAN>firsttable
                <SPAN class="comment token"># print(complete_filename)</SPAN>

                <SPAN class="keyword token">if</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"kivu_tview"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token">#  if tableview exists then delete it</SPAN>
                    arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"kivu_tview"</SPAN><SPAN class="punctuation token">)</SPAN>
                table<SPAN class="operator token">=</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>MakeTableView_management<SPAN class="punctuation token">(</SPAN>complete_filename<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"kivu_tview"</SPAN><SPAN class="punctuation token">)</SPAN>
            
                desc <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">)</SPAN>
                <SPAN class="comment token"># fieldnamesoriginal=[field.name for field in desc.fields] # collects all fieldnames</SPAN>
                <SPAN class="comment token"># print "Table view field names: "+str(fieldnamesoriginal)</SPAN>
                fieldselectlist<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
                <SPAN class="keyword token">for</SPAN> ofields <SPAN class="keyword token">in</SPAN> desc<SPAN class="punctuation token">.</SPAN>fields<SPAN class="punctuation token">:</SPAN>
                    ftype<SPAN class="operator token">=</SPAN>ofields<SPAN class="punctuation token">.</SPAN>type
                    fname<SPAN class="operator token">=</SPAN>ofields<SPAN class="punctuation token">.</SPAN>name
                    <SPAN class="keyword token">if</SPAN> ftype <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Double"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Integer"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Long"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
                        <SPAN class="comment token"># print fname</SPAN>
                        <SPAN class="keyword token">if</SPAN> fname <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Profile_No"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Longitude (degrees_east)"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Latitude (degrees_north)"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Bot. Depth (m)"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Depth (m)"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
                            <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">,</SPAN> fname<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> calcursor<SPAN class="punctuation token">:</SPAN>
                                <SPAN class="keyword token">for</SPAN> calcrow <SPAN class="keyword token">in</SPAN> calcursor<SPAN class="punctuation token">:</SPAN>
                                    <SPAN class="keyword token">if</SPAN> calcrow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">is</SPAN> <SPAN class="operator token">not</SPAN> None<SPAN class="punctuation token">:</SPAN>
                                       fieldselectlist<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>fname<SPAN class="punctuation token">)</SPAN>
                                       <SPAN class="keyword token">break</SPAN>
                <SPAN class="comment token"># print fieldselectlist</SPAN>
                arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"kivu_tview"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Table View"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># delete table view</SPAN>

                <SPAN class="comment token"># for multiple choice</SPAN>
                <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
                    <SPAN class="keyword token">if</SPAN> self<SPAN class="punctuation token">.</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>values<SPAN class="punctuation token">:</SPAN> <SPAN class="comment token">#if this parameter has seleted values</SPAN>
                        oldValues <SPAN class="operator token">=</SPAN> self<SPAN class="punctuation token">.</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>values <SPAN class="comment token">#set old values to the selected values</SPAN>
                <SPAN class="keyword token">except</SPAN> Exception<SPAN class="punctuation token">:</SPAN>
                    <SPAN class="keyword token">pass</SPAN>
                self<SPAN class="punctuation token">.</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>filter<SPAN class="punctuation token">.</SPAN>list <SPAN class="operator token">=</SPAN> sorted<SPAN class="punctuation token">(</SPAN>fieldselectlist<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#set the filter list equal to the sorted values</SPAN>
                newValues <SPAN class="operator token">=</SPAN> self<SPAN class="punctuation token">.</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>filter<SPAN class="punctuation token">.</SPAN>list
                <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
                    <SPAN class="keyword token">if</SPAN> len<SPAN class="punctuation token">(</SPAN>oldValues<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># if some values are selected</SPAN>
                        self<SPAN class="punctuation token">.</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>values <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>v <SPAN class="keyword token">for</SPAN> v <SPAN class="keyword token">in</SPAN> oldValues <SPAN class="keyword token">if</SPAN> v <SPAN class="keyword token">in</SPAN> newValues<SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># check if seleted values in new list,</SPAN>
                        <SPAN class="comment token"># if yes, retain the seletion.</SPAN>
                <SPAN class="keyword token">except</SPAN> Exception<SPAN class="punctuation token">:</SPAN>
                    <SPAN class="keyword token">pass</SPAN>

                <SPAN class="comment token"># for single choice</SPAN>
                <SPAN class="comment token"># self.params[1].filter.list = sorted(fieldselectlist) # set second parameter filter list</SPAN>
                <SPAN class="comment token"># if self.params[1].value not in self.params[1].filter.list:</SPAN>
                <SPAN class="comment token">#     self.params[1].value = self.params[1].filter.list[0] # default to first item in list</SPAN>

        <SPAN class="keyword token">return</SPAN>

    <SPAN class="keyword token">def</SPAN> <SPAN class="token function">updateMessages</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="string token">"""Modify the messages created by internal validation for each tool
        parameter.  This method is called after internal validation."""</SPAN>
        <SPAN class="keyword token">return</SPAN>

<SPAN class="comment token"># Call routine(s) to debug ------------------------------------------------------------------------------------------</SPAN>
<SPAN class="comment token">#</SPAN>
validator <SPAN class="operator token">=</SPAN> ToolValidator<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
validator<SPAN class="punctuation token">.</SPAN>updateParameters<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
validator<SPAN class="punctuation token">.</SPAN>updateMessages<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># testing results</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetMessages<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> u<SPAN class="string token">"Folder: {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>value<SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># print u"Fields: {}".format(params[1].value) # for 1 value</SPAN>
<SPAN class="keyword token">print</SPAN> u<SPAN class="string token">"Fields: {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>params<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>values<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># for multiple values</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>‍</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><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>‍</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>

Once I was happy with the debug test, I pasted the ToolValidator section into the tool's validator.

Hope this helps.

Nicole_Ueberschär

Thanks for looking into it Randy.

I only select the first file in the directory because the structure should be for all files inside the directory the same. They are all then processed within a seperate step (in the main python script). I could also use the table as a parameter and take its path to find the directory to process all the files, that is correct. [Is there a way to avoid the table view to be added to the map document and to be stored as a seperate process in the results window?]

I only need to check for the first row because if the value of the first row is none the whole column will be empty.

The min and max values are specified by the user, they are not derived from the parameters but mean the depth range for the parameters to be extracted.

From the error message I get, I assume I would have either to store my list of values in a different "format" than a list OR I have to set the input Data Type (which is field at the moment) differently but I can't figure out either way.

RandyBurton

I want to make sure I understand your work flow. You are selecting the first text file in a directory. Is this the only text file in the directory, or do you plan to process other files in the same directory? I'm curious why you are not setting up the tool to use a text file as the first parameter in place of a folder location.

For the "calcrow[0] is not None" test, is this for just the first row, or for any row in that field?

Can it be assumed that the min and max value will be selected from one of the fields that is in the field selected list?

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.