Latest Contributions by LindsayRaabe_FPCWA

So I know that in python you can write if-else statements and use "pass" to skip doing something if that is desired. I've trawled the web on Arcade and can't find an equivalent to the pass option in python. Does this exist?    i.e. - I have a feature class and table joined together. I want to compare 2 fields to see if they match (if FieldA == FieldB). If they match, do nothing (pass), if not, return FieldB.  I know I could simply return FieldA (as per this solution in this post) but I want to see if by skipping instead of returning FieldA, it might improve the speed of the calculation if it can skip values instead of returning the original value???   P.S. I couldn't actually get it to work in python - it didn't seem to like the joined field names (i.e. Table1.FieldA == Table2.csv.FieldA). I did get it to work on a an un-joined feature class (i.e. FieldA == FieldB). I'm guessing it was the "dots" between the table name and the field name that was confusing it.  ... View more

Hi All. I've just tried to implement a single python script that iterates through a list of other python files with the aim of not having dozens of independent Task Schedule items.  I've got the below code working - with 1 flaw (so far);     import glob,os #https://stackoverflow.com/questions/64016426/how-to-run-multiple-python-scripts-using-single-python-py-script os.chdir(r"\\my\server\folder") # locate ourselves in the directory containing the python files to run for script in sorted(glob.glob("*.py")): if not script.startswith (("1.", "2.")): print ("Found: " + script) with open(script) as f: contents = f.read() print ("Running " + script) exec(contents) print ("Script complete")     The script successfully lists all the python files in the folder (and also to exclude 2 which are a template and the script being run above), and it successfully runs through the first script found. When it gets to the 2nd, 3rd, ... scripts though I get the below error; "Exception: type object 'datetime.datetime' has no attribute 'datetime'" Obviously, you need to see the script to understand context, so here it is. From what I can see, it is failing somewhere between Lines 50 and 58 (based on the print statements that come out before the error occurs).    from datetime import datetime, timedelta, date # *****Update the below 6 lines***** name = "My Hosted Feature Service" #Name of dataset for use in error email notification url_fl = "https://services3.arcgis.com/SERVICEID/arcgis/rest/services/SERVICENAME/FeatureServer/0" # Service URL for feature layer to download as feature class destGDB = r"\\My\output\folder\and\GDB.gdb" #The GDB where the backup feature class will be created destFC = "BackupID1" #The backup feature class name (no spaces - use _ or CamelCase) monthlimit = datetime.today() - timedelta(days=30) # number of days to keep daily backups yearlimit = datetime.today() - timedelta(days=365) # number of days to keep monthly backups (1st day of month only) - everything older will be deleted while True: #If something fails in the main script under "try", the "except" section emails a notification to the GIS Inbox try: import arcpy from arcpy import env from arcgis import gis #Instead of signing in as follows (gis = GIS("https://abcde.maps.arcgis.com", "Username", "Password") this breaks it up so that you are able to call the sign in details independently from arcgis.gis import GIS from arcgis.features import FeatureLayer import getpass import json import requests from time import strftime def getSecrets(): # Secrets from file stored outside of revison control with open(r"\\none\of\your\bees.json") as f: secrets = json.load(f) return secrets secrets = getSecrets() # Get login credentials # http://docs.python-requests.org/en/latest/user/advanced/ s = requests.Session() url_gis="https://abcde.maps.arcgis.com" s.user = (secrets["username"]) s.pw = (secrets["password"]) #SIGNING INTO ARCGIS ONLINE print ("Signing into ArcGIS Online") source = gis.GIS(url_gis, s.user, s.pw) #signing in print ("Signed into ArcGIS Online") # CREATING BACKUP OF FEATURE SERVICE # https://community.esri.com/t5/python-questions/using-arcpy-to-copy-a-portal-feature-service-to-a-fgdb-feature/m-p/4285#M394 fl = FeatureLayer(url_fl) fs = fl.query() print ("Exporting backup of feature service") fs.save(destGDB, destFC + "_" + strftime("%Y%m%d_%H%M%S")) time.sleep(10) #add 10 seconds delay to allow export to complete print (name + " feature service exported to backup GDB: " + destGDB + "\\" + destFC + strftime("_%Y%m%d_%H%M%S")) print ("Filtering past backups") arcpy.env.workspace = destGDB FClist = arcpy.ListFeatureClasses(destFC + "*") for fc in FClist: datestamp = datetime.datetime.strptime(('{}'.format(fc))[-15:], "%Y%m%d_%H%M%S") day = (datestamp.day) print (fc + "..........Backup date:" + str(datestamp)) if datestamp < yearlimit: #data more than 365 days old print (" Older than 12 months: delete backup") arcpy.management.Delete(fc) print ("Deleted") elif datestamp < monthlimit: #fc more than 90 days old if day == 1: print (" 1st of month & 4-12 months old: retain as monthly backup") #fc from 1st of Month and more than 90 days old else: print (" Older than 3 months and not the 1st of the month: delete backup") arcpy.management.Delete(fc) #fc NOT from 1st of Month and more than 90 days old print ("Deleted") else: print (" Less than 3 months old: retain backup") print ("Script finished") break # Stops script here except Exception as e: from email...#does more stuff       ... View more