Latest Contributions by DavidColey

Well, for me all I do is make sure my directory holding my .py files is shared and then I just have task scheduler run python.exe as the Action: C:\Users\yourname\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone\python.exe and for the argument supply the python file using the UNC path \\MyComputerName\BatchDBTasksAE\SqlUnScripts\BatchSqlUN_SewerStructJunction.py. The python snippet above is configured for the IDLE, not Notebook, so you can just change the GIS param to match your portal and change the sd file location to your directory location and it will run no problem in the IDLE. When the above works for you, please mark it as correct thanks! ... View more

I would say that if you look at this: https://developers.arcgis.com/python/api-reference/arcgis.features.managers.html#arcgis.features.managers.FeatureLayerCollectionManager.overwrite In part, it reads "The data file used to overwrite should be of the same format and filename as the original that was used to publish the layer".  So basically you need to create service definition file from your sde layer first. The feature layer is then created from that sd file, and when the sd file is overwritten, both the sd file and feature layer are updated.   I prefer to use the sharing module in Pro to create the staging definition (sddraft) and service definition files (sd). Then, instead of jumping over to the api to do the overwrite, just continue to use sharing module in pro. However, it might look something like this from arcgis.gis import GIS from arcgis.features import FeatureLayerCollection gis = GIS("https://yourdomain/yourportal", "username_portal", "user_pw") try: portItems = gis.content.search(query="owner:username_portal", item_type="Feature Layer", sort_field="title", sort_order="asc", max_items=5000) #Service Definition Feature Layer for portItem in portItems: if (portItem.title == "YourFeatureLayer"): portFL = FeatureLayerCollection.fromitem(portItem) print (portItem.title) portFL.manager.overwrite('C:/ArcProProjects3x/YourSDFile.sd') #portFL.manager.refresh() print(portFL.properties) message = message + "\n" + (portItem.title) except Exception: # If an error occurred, print line number and error message import traceback, sys tb = sys.exc_info()[2] e = sys.exc_info() ... View more