Latest Contributions by AmyRoust

Good question! I believe I am:   ... View more

I'm a lot closer now after making quite a few changes. Now I'm getting the error message:  A general error occurred: Circular reference detected ERROR: A general error occurred: Circular reference detected  I believe that the error is in line 42. I replaced some info with ... for security purposes.   from arcgis.gis import GIS gis = GIS("home") # Import arcpy module from arcgis.gis import GIS from arcgis.features import FeatureLayer, GeoAccessor # might not need that last one? import time, arcpy, os, datetime # Variables s123Layer = r'https://services.arcgis.com/.../FeatureServer/0' report_copy_url = r'https://services.arcgis.com/.../FeatureServer/0' try: item = gis.content.get("...") feature_layer = item.layers[0] field_name = "ReportDate" query_result = feature_layer.query(out_statistics=[{"statisticType": "max", "onStatisticField": field_name}]) milliseconds = query_result.features[0].attributes[f"MAX_{field_name}"] date_time = datetime.datetime.utcfromtimestamp(milliseconds / 1000.0) max_date = date_time.strftime('%Y-%m-%d %H:%M:%S') print("Most recent report date in ...:", max_date) feature_layer = FeatureLayer(s123Layer, gis=gis) query = f"submission_date_and_time > timestamp '{max_date}'" selected_features = feature_layer.query(where=query) print(f"Number of new features to append to ...: {len(selected_features)}") ###### SCRIPT WORKS TO THIS POINT ####### if len(selected_features.features)>0: fm = [{'ObservationDate':'ReportObservationDate', 'CampsiteDescription':'ReportCampsiteDescription', 'FollowUpRequest':'ReportFollowUpRequest', 'SubmitterName':'ReportSubmitterName', 'PreferredContact':'ReportSubmitterPreferredContact', 'EmailAddress':'ReportSubmitterEmailAddress', 'PhoneNumber':'ReportSubmitterPhoneNumber', 'submission_date_and_time':'ReportDate' }] targetLayer = FeatureLayer(report_copy_url,gis=gis) targetLayer.append(selected_features.features, field_mappings = fm, return_messages = True) else: print("No new reports to load into ...") except Exception as e: print(e) arcpy.AddError(str(e))    @JakeSkinner  @Clubdebambos  - do you see any issues? ... View more

Thank you! That worked for error trapping. I fixed the issue, but field mapping doesn't work.   if len(selected_features.features)>0: field_mapping = {'ObservationDate':'ReportObservationDate', 'CampsiteDescription':'ReportCampsiteDescription', 'FollowUpRequest':'ReportFollowUpRequest', 'SubmitterName':'ReportSubmitterName', 'PreferredContact':'ReportSubmitterPreferredContact', 'EmailAddress':'ReportSubmitterEmailAddress', 'PhoneNumber':'ReportSubmitterPhoneNumber', 'submission_date_and_time':'ReportDate' } sdf = feature_layer.query(where=query) feature_layer.edit_features(adds = sdf, field_mapping=field_mapping)   Line 12 generates the error: FeatureLayer.edit_features() got an unexpected keyword argument 'field_mapping' ERROR: FeatureLayer.edit_features() got an unexpected keyword argument 'field_mapping' I tried using field_mappings (plural) since that's listed in the FeatureLayer append method as a keyword, but no luck. So then I thought I'd try the append method, but I'm getting Unknown Error (Error Code: 500) in response to this: if len(selected_features.features)>0: field_mapping = [{'ObservationDate':'ReportObservationDate', 'CampsiteDescription':'ReportCampsiteDescription', 'FollowUpRequest':'ReportFollowUpRequest', 'SubmitterName':'ReportSubmitterName', 'PreferredContact':'ReportSubmitterPreferredContact', 'EmailAddress':'ReportSubmitterEmailAddress', 'PhoneNumber':'ReportSubmitterPhoneNumber', 'submission_date_and_time':'ReportDate' }] sdf = feature_layer.query(where=query) feature_layer.append(sdf, field_mappings = field_mapping, return_messages = True) My guess is that the error code is the result of not specifying an item_id, since sdf is a selection of records and not an entire item. Any ideas on what to try next? I wish the ArcGIS API for Python documentation consistently provided sample code like the arcpy documentation does. ... View more

Just for clarification, I do have the variable feature_layer defined earlier in the script and it's working properly. item = gis.content.get("999999999") # actual item id has been removed for this chat feature_layer = item.layers[0] ... View more

I still have something wrong, but I don't know how to print error messages because arcpy.GetMessages() doesn't return anything. Is there another way to get the error messages from failed functions? Here's the portion of code that is failing: field_mapping = {'ObservationDate':'ReportObservationDate', 'CampsiteDescription':'ReportCampsiteDescription', 'FollowUpRequest':'ReportFollowUpRequest', 'SubmitterName':'ReportSubmitterName', 'PreferredContact':'ReportSubmitterPreferredContact', 'EmailAddress':'ReportSubmitterEmailAddress', 'PhoneNumber':'ReportSubmitterPhoneNumber', 'submission_date_and_time':'ReportDate' } sdf = feature_layer.query(where=query).sdf feature_layer.edit_features(adds = sdf.to_featureset(), field_mapping=field_mapping)   I think line 10 is working because I added a print statement for the sdf variable and got this (confidential information blurred in the screenshot): ... View more

I don't have any attachments, @Clubdebambos. Is there a way to do field mapping with the edit_features function? Some of the field names in the input feature layer don't match the target layer. ... View more

To add to this excellent idea, the workaround that GT_UTCO offers does not work for users who use IWA SAML to authenticate. I cannot use the SignInToPortal function to force a switch of portals because storing the username and password in the script does not work for IWA (using Active Directory credentials to log in). At this point, my only workaround is to use a Notebook for my all-ArcGIS Online script and leave my portal default on our Enterprise Portal for our other scripts. This breaks our organization's governance guidelines because we don't allow individuals to own maintenance scripts so that scripts stop working when a person leaves the company. Edited to add: I made a mistake in this original post. We use SAML authentication, not IWA. ... View more

@RhettZufelt - regarding "I have a scheduled task that opens/closes Pro every monday night just to keep my sign in active." Can you provide details on this? I've been digging through the arcpy documentation without luck to find a function that will do this because I'm having issues with my account logging out of its connection to our Portal, presumably due to inactivity. ... View more

You hit the nail on the head. I forgot that I changed my default portal to our Enterprise Portal to support some new scripts that I took ownership of from a departing employee. I'll need to find a way to change portals in my scripts to address that issue. Thank you! ... View more

Here's another issue that I ran into today. I have a user named gis_viewer in our SQL database that I was using to connect to the enterprise database with my data. I can publish services to Portal with that database connection, but it's missing a permission that will prevent the data from copying via the collaboration. I don't know what the permission is, but I think it requires more than SELECT. Maybe someone from Esri like @ReeseFacendini can provide the link to that resource? ... View more

There is a bug in Enterprise 11.1 for multi-machine deployments that is fixed in 11.3: 113-IssuesAddressedList_06112024.pdf (esri.com) In addition to edit sync failures, I was getting a lot of those generic "failed to export item" errors while still on Enterprise 11.1. Upgrading to 11.3 resolved my issue. One other thing to check: make sure that you aren't hiding any fields in your attribute table. In particular, the sync needs all of the editor tracking fields as well as global ID. I got that generic error many times when I had hidden those fields from the attribute table before publishing to Portal. Good luck!   ... View more

I don't have a solution or explanation yet, but I do have a workaround. After adding the new layer to a web map, I removed the unique symbology and the redid it from scratch. Somehow, making any change to the symbology resolves the issue. All I can guess right now is that the web map or the Instant App doesn't like something about the symbology as-is when it comes across in the collaboration. I've got a ticket in with Esri tech support, but I'm really not sure whether we'll find a root cause or not. It was a pain to manually redo the colors on 20 bus routes, but hey, if it works, it works! ... View more