Latest Contributions by RandyBurton

When creating a new script tool or add-in, I will start experimenting in the Python window with the various arcpy functions that look applicable.  From your description, you are wanting something to identify polygon layers, select one of those layers, make an initial selection of polygons from the current map extent, and get a list of attributes to allow the user to make a further choices.  I hope this is a reasonable summary of your project. With that in mind, here's a test script that I've been experimenting with in the Python window using desktop 10.5.  You may need to check the arcpy functions if you're using Pro or other version. mxd = arcpy.mapping.MapDocument("CURRENT") polyLayers = [] # empty list # ListLayers (map_document_or_layer, {wildcard}, {data_frame}) lyrs = arcpy.mapping.ListLayers(mxd) for lyr in lyrs: # Describe (object) desc = arcpy.Describe(lyr) if desc.ShapeType == 'Polygon': polyLayers.append(lyr.name) selected_layer = polyLayers[0] # for demo, select first layer print selected_layer fields = [] # empty list for field selection # ListFields (dataset, {wild_card}, {field_type}) flds = arcpy.ListFields(selected_layer, field_type='String') for f in flds: # print f.name fields.append(f.name) print fields selected_field = fields[0] # select first field tor testing print selected_field # get extent and select polygons in selected layer # ListDataFrames (map_document, {wildcard}) df = arcpy.mapping.ListDataFrames(mxd, "*")[0] ext = df.extent array = arcpy.Array([arcpy.Point(ext.XMin, ext.YMin), arcpy.Point(ext.XMin, ext.YMax), arcpy.Point(ext.XMax, ext.YMax), arcpy.Point(ext.XMax, ext.YMin) ]) polygon = arcpy.Polygon(array) # use this polygon for making selection # SelectLayerByLocation_management (in_layer, {overlap_type}, {select_features}, {search_distance}, {selection_type}, {invert_spatial_relationship}) arcpy.SelectLayerByLocation_management(selected_layer, "INTERSECT", polygon, "", "NEW_SELECTION", "NOT_INVERT") selected = [] # empty list for selected polygons' attributes # SearchCursor (in_table, field_names, {where_clause}, {spatial_reference}, {explode_to_points}, {sql_clause}) with arcpy.da.SearchCursor(selected_layer,selected_field) as cursor: for row in cursor: selected.append(row[0]) print selected # user would choose from this list # SelectLayerByAttribute(in_layer_or_view, {selection_type}, {where_clause}, {invert_where_clause}) arcpy.SelectLayerByAttribute_management(selected_layer, "CLEAR_SELECTION") # clear selected items‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Once the code is tested and does what is desired, then you can work it into a script tool or add-in.  Hope this helps. ... View more

Since you are using the defaults for nullable and required, you could just omit those parameters.  Provide the first three required parameters in order, and add field_length=00 (some number) for your text fields. ... View more

It also looks like you were missing the field alias. #AddField(in_table, field_name, field_type, {field_precision}, {field_scale}, {field_length}, {field_alias}, {field_is_nullable}, {field_is_required}, {field_domain}) # arcpy.AddField_management(fc, "Source Last Edit Date", "DATE", "", "", "75", "True", "NON_REQUIRED", "") arcpy.AddField_management( fc, "SourceLastEditDate", "DATE", "#", "#", "#", "FieldAlias", "NULLABLE", "NON_REQUIRED", "#")‍‍‍‍‍‍‍‍‍ # or arcpy.AddField_management(fc, "SourceLastEditDate", "DATE", field_is_nullable="NULLABLE", field_is_required="NON_REQUIRED")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Also use NULLABLE or NON_NULLABLE, not "True" in your DATE lines. ... View more

Looks like you have spaces (not allowed) in the field name: "Source Last Edit Date".  Since it is a date field, I also suggest leaving the length parameter blank. ... View more

My initial response would be to use the 'File' data type with a filter of 'xls; xlsx', so the user can select the file.  Then the tool validator section can read the file and load the values into a parameter for the user to select from. Alternatively, you could code a relative path to the Excel file in tool validator section.  This may have benefits or issues depending on the project. ... View more

Although they look identical, txt is a file object, and last_update_fra appears to be a list object. >>> last_update_fra = ['Last Updated 4/3/2020, 8:28 p.m.'] >>> txt = open(r"C:\Users\jpilbeam\LastUpdate.txt", "r") >>> type(txt) <type 'file'> >>> t = txt.read() >>> type(t) <type 'str'> >>> t "['Last Updated 4/3/2020, 8:28 p.m.']" >>> type(last_update_fra) <type 'list'> >>> tt = str(last_update_fra) >>> tt "['Last Updated 4/3/2020, 8:28 p.m.']" >>> if t == tt: ... print "match" ... match >>> ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Perhaps if "last update" was done in the last 24 hours (or other time period), then send an email.  You may also need to consider the time zone in the time calculations.  The basic idea: import re from dateutil import parser from datetime import datetime pattern = re.compile(r"\d[\d\/,:. AaPpMm]{4,24}") last_update_fra = """<h1>COVID-19 News Updates</h1> <div><br></div><div>Last Updated 4/3/2020, 12:08 p.m.</div>""" # assumes datetime will be last element, and a datetime was found dt = parser.parse(pattern.findall(last_update_fra)[-1]) updated = datetime.now() - dt if updated.days < 1 : # updated in the past day print "process -", dt else: print "ignore -", dt # prints: ignore - 2020-04-03 12:08:00‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

For the expression, try: float(!TABLICAS.ogółem!)‍ ... View more

Keep learning! And have fun doing it! ... View more

Is there a reason you are using count as text (number inside quotes)  and not a number?  How is count being set? if count<>"0": # "0" is a text string # vs if count <> 0: # >0 assuming negative numbers wouldn't happen # or if count: ‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more