Latest Contributions by BlakeTerhune

Line 13 is a little dense so here it is separated to be a little more clear. import datetime import os import requests import time indexHTML = requests.get("https://www.gosolarcalifornia.ca.gov/equipment/documents/").text fileName = "Grid_Support_Inverter_List_Full_Data.xlsm" fileNameHTML = '<td><a href="{0}">{0}</a></td>'.format(fileName) fileNameHTMLIndex = indexHTML.find(fileNameHTML) if fileNameHTMLIndex != -1: dateStartIndex = indexHTML.find(">", fileNameHTMLIndex+len(fileNameHTML)) + 1 dateEndIndex = indexHTML.find("<", dateStartIndex) webFileDate = indexHTML[dateStartIndex:dateEndIndex].strip() webFileDate = datetime.datetime.strptime(webFileDate, "%Y-%m-%d %H:%M") else: raise Exception("Unable to find fileName {}".format(fileName)) localFilePath = r"your\local\path\here" localFileDate = os.path.getctime(localFilePath) localFileDate = datetime.datetime.strptime(time.ctime(localFileDate), "%a %b %d %H:%M:%S %Y") if webFileDate > localFileDate: print("File on the web is newer!") # download web file to replace local file‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

My code sample is comparing the date listed for the file on the website (not sure what date it is) with the created date for the file on your local drive. You can adjust the line with getctime() to getmtime() if you want the modified date instead. You might want to do some testing to make sure the file you download from the website has a created date either when it was downloaded or that matches what's listed on the website. ... View more

Correct. My method is only comparing file dates so it doesn't matter what the file actually is. ... View more

Here is kind of a hacky solution that just parses the file index page for the file you want and gets the date listed in the next cell of the same table row. You can then compare this date with the date of your local file to decide if you want to download it. import datetime import os import requests import time indexHTML = requests.get("https://www.gosolarcalifornia.ca.gov/equipment/documents/").text fileName = "Grid_Support_Inverter_List_Full_Data.xlsm" fileNameHTML = '<td><a href="{0}">{0}</a></td>'.format(fileName) fileNameHTMLIndex = indexHTML.find(fileNameHTML) if fileNameHTMLIndex != -1: dateStartIndex = indexHTML.find(">", fileNameHTMLIndex+len(fileNameHTML)) + 1 dateEndIndex = indexHTML.find("<", dateStartIndex) webFileDate = datetime.datetime.strptime(indexHTML[dateStartIndex:dateEndIndex].strip(), "%Y-%m-%d %H:%M") else: raise Exception("Unable to find fileName {}".format(fileName)) localFilePath = r"your\local\path\here" localFileDate = os.path.getctime(localFilePath) localFileDate = datetime.datetime.strptime(time.ctime(localFileDate), "%a %b %d %H:%M:%S %Y") if webFileDate > localFileDate: print("File on the web is newer!") # download web file to replace local file‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Alternatively, just download the file and use the method Arne Gelfert‌ mentioned to compare them for differences. The file isn't large so it shouldn't take excessively long to download and the logic is much simpler. ... View more

Is the scheduled task set to run as the GISAdmin user? We put our database connections in a common folder on the C: drive of the server instead of in a user folder. ... View more

If I understand correctly, you want a way to compare the created or modified date of two files? Here's one solution I found. ... View more

Great idea Arne Gelfert‌. Here's the equivalent for us Oracle folks. select A.table_name from SDE.table_registry A left outer join ALL_TABLES B on A.table_name = B.table_name where b.table_name is NULL‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Just an observation of your script. You are importing all of arcpy, which includes arcpy.env and arcpy.da so you don't need to import those explicitly. Especially since you are still calling it as arcpy.env and don't appear to be using arcpy.da. This will do: import arcpy import os‍‍ ... View more

Result—Help | ArcGIS Desktop  ... View more

We used the About widget and put all of the attribution in there. ArcGIS Web Application  ... View more

This is a tough one, which is why we mirror the folder structure our published services with a folder of map documents used to publish the services. You can see the location where the original mxd was published from using ArcGIS Server Manager to view the General tab of the service properties. The same thing is also in ArcCatalog service properties but it's on the Parameters tab. However, this won't do any good if the MXD has been moved or deleted since publishing. Edit: You might be able to find in your server directory at \arcgisserver\directories\arcgissystem\arcgisinput\ServiceFolderName\ServiceName.MapServer\extracted\v101 ArcGIS Enterprise‌ ... View more

Revisiting this, I've simplified the code a little by creating the edit session outside the try...except so you don't have to check if it exists. edit = arcpy.da.Editor(sdeconnection) print "edit created" try: edit.startEditing() print "edit started" edit.startOperation() print "operation started" # Perform edits with arcpy.da.InsertCursor(fc, fields) as fc_icursor: fc_icursor.insertRow(someNewRow) edit.stopOperation() print "operation stopped" edit.stopEditing(True) ## Stop the edit session with True to save the changes print "edit stopped" except Exception as err: print err if edit.isEditing: edit.stopOperation() print "operation stopped in except" edit.stopEditing(False) ## Stop the edit session with False to abandon the changes print "edit stopped in except" finally: # Cleanup arcpy.ClearWorkspaceCache_management()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more