topic Re: ArcPy script in toolbox - what do I do about optional parameters? in Python Questions

ArcPy script in toolbox - what do I do about optional parameters?

RosieBell — Tue, 21 Aug 2012 06:42:34 GMT

I made my first Python tool this week, a Search by Attribute tool to search our cadastre. When I have required parameters it works beautifully. As soon as I make the parameters optional, it doesn't return any results (even if I complete all the fields).

What am I doing wrong? I added the 'if' line after reading another thread about optional parameters, but it doesn't make any difference with this problem. Thanks.

#define user parameter for road name, and locality  SelCondition = arcpy.GetParameterAsText(0) if (not SelCondition) or (SelCondition == "#") or (len(SelCondition.strip()) == 0):     SelCondition = ""   LocalityName = arcpy.GetParameterAsText(1) if (not LocalityName) or (LocalityName == "#") or (len(LocalityName.strip()) == 0):     LocalityName = ""   # select cadastral lots on road name and locality, and lot no arcpy.SelectLayerByAttribute_management("Cadastre","NEW_SELECTION", "\"ROAD_NAME\" = "+SelCondition)  arcpy.SelectLayerByAttribute_management("Cadastre","SUBSET_SELECTION", "\"LOCALITY\" = "+LocalityName)

Re: ArcPy script in toolbox - what do I do about optional parameters?

JochenManegold — Tue, 21 Aug 2012 10:49:07 GMT

I think the code is fine. I tested it, and for me it worked:

import arcpy value = arcpy.GetParameterAsText(0) if value == "#" or value == "":    value = None if value:   arcpy.SelectLayerByAttribute_management("dachflaechen","NEW_SELECTION", "\"OBJECTID\" = "+value) else:   arcpy.AddError("no value")

Re: ArcPy script in toolbox - what do I do about optional parameters?

KenCarrier — Tue, 21 Aug 2012 12:20:02 GMT

Try this

#define user parameter for road name, and locality

SelCondition = arcpy.GetParameterAsText(0)
if (not SelCondition) or (SelCondition == "#") or (len(SelCondition.strip()) == 0): SelCondition = ""

LocalityName = arcpy.GetParameterAsText(1)
if (not LocalityName) or (LocalityName == "#") or (len(LocalityName.strip()) == 0): LocalityName = ""

# select cadastral lots on road name and locality, and lot no
roadQuery = " UPPER(\"{0}\") = UPPER('{1}') ".format(ROAD_NAME, string.upper(SelCondition))
arcpy.SelectLayerByAttribute_management("Cadastre","NEW_SELECTION", roadQuery)

localityQuery = " UPPER(\"{0}\") = UPPER('{1}') ".format(LOCALITY, string.upper(LocalityName))
arcpy.SelectLayerByAttribute_management("Cadastre","NEW_SELECTION", localityQuery)

Re: ArcPy script in toolbox - what do I do about optional parameters?

RosieBell — Fri, 28 Sep 2012 06:12:39 GMT

Sorry for the slow reply. I tried both solutions shortly after they were posted, but couldn't get either of them to work. I tried again jm's solution again today and it did the job, many thanks. carrierkh, no doubt it was my inexperience that was the problem, so thankyou for your help.