Latest Contributions by ModernElectric

@JakeSkinner  Good to go again. Appreciate this. Verified the Hosted Feature Layer had the Sync re-enabled after the script was ran. Also, shows the modified date was also updated in AGOL.  Exactly what was needed. ... View more

@JakeSkinner  Here is one of the original scripts I have been using, for some reason when the script finishes, the sync enabled is unchecked and I have to recheck it via AGOL each time.   # Variables prjPath = r"C:\Users\cwafstet\Documents\MODERN GIS WORKING FILES\ELECTRIC\ArcGIS PRO PROJECTS\AGOL UPDATE - DATASET - ELECTRIC.aprx" # Path to Pro Project map = 'MODERN ELECTRIC AGOL UPDATES' # Name of map in Pro Project serviceDefID = 'a57db3b4e0db4cddafc7dacaf33cd317' # Item ID of Service Definition featureServiceID = '0694901da5ce44bbba3d0cec88e1bb6c' # Item ID of Feature Service portal = "https://www.arcgis.com" # AGOL user = "xyzx" # AGOL username password = "xyzx" # AGOL password preserveEditorTracking = True # True/False to preserve editor tracking from feature class unregisterReplicas = False # True/False to unregister existing replicas # Set Environment Variables arcpy.env.overwriteOutput = 1 # Disable warnings requests.packages.urllib3.disable_warnings() # Start Timer startTime = time.time() print(f"Connecting to AGOL") gis = GIS(portal, user, password) arcpy.SignInToPortal(portal, user, password) # Local paths to create temporary content sddraft = os.path.join(arcpy.env.scratchFolder, "WebUpdate.sddraft") sd = os.path.join(arcpy.env.scratchFolder, "WebUpdate.sd") sdItem = gis.content.get(serviceDefID) # Create a new SDDraft and stage to SD print("Creating SD file") arcpy.env.overwriteOutput = True prj = arcpy.mp.ArcGISProject(prjPath) mp = prj.listMaps(map)[0] serviceDefName = sdItem.title arcpy.mp.CreateWebLayerSDDraft(mp, sddraft, serviceDefName, 'MY_HOSTED_SERVICES', 'FEATURE_ACCESS', '', True, True) arcpy.StageService_server(sddraft, sd) # Reference existing feature service to get properties fsItem = gis.content.get(featureServiceID) flyrCollection = FeatureLayerCollection.fromitem(fsItem) properties = fsItem.get_data() # Get thumbnail and metadata thumbnail_file = fsItem.download_thumbnail(arcpy.env.scratchFolder) metadata_file = fsItem.download_metadata(arcpy.env.scratchFolder) # Unregister existing replicas if unregisterReplicas: if flyrCollection.properties.syncEnabled: print("Unregister existing replicas") for replica in flyrCollection.replicas.get_list(): replicaID = replica['replicaID'] flyrCollection.replicas.unregister(replicaID) # Overwrite feature service sdItem.update(data=sd) print("Overwriting existing feature service") if preserveEditorTracking: pub_params = {"editorTrackingInfo" : {"preserveEditUsersAndTimestamps":'true'}} fs = sdItem.publish(overwrite=True, publish_parameters=pub_params) else: fs = sdItem.publish(overwrite=True) # Update service with previous properties print("Updating service properties") params = {'f': 'pjson', 'id': featureServiceID, 'text': json.dumps(properties), 'token': gis._con.token} agolOrg = str(gis).split('@ ')[1].split(' ')[0] postURL = f'{agolOrg}/sharing/rest/content/users/{fsItem.owner}/items/{featureServiceID}/update' r = requests.post(postURL, data=params, verify=False) response = json.loads(r.content) # Update thumbnail and metadata print("Updating thumbnail and metadata") fs.update(thumbnail=thumbnail_file, metadata=metadata_file) endTime = time.time() elapsedTime = round((endTime - startTime) / 60, 2) print(f"Script completed in {elapsedTime} minutes")     The script that you updated, will not run saying it cannot run with a sync enabled hosted feature layer. I am getting this message when running the updated script with a Hosted Feature Layer that has sync enabled: fc = r"C:\Users\cwafstet\Documents\MODERN GIS WORKING FILES\ELECTRIC\GEODATABASES\MEWCo ELECTRIC SYSTEM.gdb\AGOL_ELECTRIC_DATASET\UG_PRIMARY_CONDUCTOR_FEEDER" # Path to Feature Class fsItemId = "dbf687af06b649d3afafbc8469e8d448" # Feature Service Item ID to update featureService = True # True if updating a Feature Service, False if updating a Hosted Table hostedTable = False # True is updating a Hosted Table, False if updating a Feature Service layerIndex = 0 # Layer Index disableSync = True # True to disable sync, and then re-enable sync after append, False to not disable sync. Set to True if sync is not enabled updateSchema = False # True will remove/add fields from feature service keeping schema in-sync, False will not remove/add fields upsert = True # True will not truncate the feature service, requires a field with unique values uniqueField = 'GlobalID' # Field that contains unique values # Environment Variables arcpy.env.overwriteOutput = True arcpy.env.preserveGlobalIds = True   Appreciate any feedback on either of the (2) scripts.       ... View more

@JakeSkinner  I am using one of your previous scripts to update a single Hosted Feature Layer. Part of the script disables the sync feature on the FL in AGOL.  How do I go about re-enabling the sync at the end of the script? Without the FL having Sync Enabled, it is giving our Workforce Project(s) real problems with the layers. Appreciate your help as always ... View more

Ended up contacting ESRI Tech Support and issued a trouble ticket for review. ... View more

@RobertAnderson3 @IsmaelChivite @ZacharySutherby @JenniferAcunto  There must be something I am missing. Using Power Automate, I keep getting an error message while using the ArcGIS Connector (orange) saying I need a Premium License. However, according to my knowledge, the ArcGIS for Microsoft 365 accepts a Creator ESRI license type. Is there a setting within Power Automate I need to update, even though I used my ESRI login credentials.   ... View more

@RobertAnderson3  Thank you for the information. Appears I need to #1 talk with my IT Officer about our Power Automate License(s) before I can continue development. I see there is more that I can use. Thank You for the feedback ... View more

@RobertAnderson3  Thank you for the response. Can you clarify and point me in the right direction on what you are explaining? What I need to do is when the attributes are updated, lets say via ArcGIS Pro/Python script, to a Survey123 form, Power Automate is initiated to create a report. I have the flow configured, its the webhook and updating an existing survey/form from ArcGIS Pro that is the missing piece.   ... View more

@Robert_LeClair @DanPatterson  Thank you for the information. I've tried the script you sent, and also found another script:   with arcpy.da.SearchCursor(feature_class, [date_field]) as cursor: max_date = None for row in cursor: date_value = row[0] if max_date is None or date_value > max_date: max_date = date_value print("Maximum date: ", max_date) arcpy.SelectLayerByAttribute_management(feature_class, "NEW_SELECTION", date_value) arcpy.conversion.ExportFeatures(feature_class, layername_export) print("EXPORT")   Both of the scripts exports all of the rows from the feature class to a new feature class. The goal is to only select and export the newest date regardless if there is 1 feature or 200 features in the feature class. As time progresses, this feature class is going to grow overtime and the next script(s) will rely on having (1) record and it needs to be the most recent record.  Question, does that need to be a DATE_ONLY field type or is it okay to be a DATE-TIME  field type? Not sure if this makes a difference.  ... View more