Latest Contributions by AmyRoust

I think that's the correct answer, George! Thank you. ... View more

You found more than I was able to track down! Thank you. ... View more

That link is interesting - the list of what I would call "behaviors" on that page are described as "supported data types." That's a pretty generic term that could be used to describe feature classes and tables, I would think. Interesting, though, that there is no use of the word "behaviors" on that documentation. Perhaps it's not a ubiquitous term. Thank you for sharing that! ... View more

Same thing - no filtering occurs. ... View more

After further testing, I found that the User role cannot edit Utility Networks, but the Publisher role can. However, there is something going on with browser caching that complicates the testing. Here's what I mean: 1. I set my test user as a Publisher. It can edit the UN data in a web map. 2. I change the test user to the User role. The edit button is removed from the web map. 3. I change the test user back to the Publisher role. The edit button does not reappear. Clearing the browser cache does not resolve this issue. 4. If I open an identical copy of the original web map, the editing button reappears.  Side note: we use IWA to authenticate. I don't know how this would change with built-in accounts. In general, I think it's odd that the Publisher role is allowed to edit utility networks, given that the additional privileges that come with the Publisher role are all related to publishing items to Portal. Nonetheless, there is something about the Publisher role that allows the users to edit UN services. I should also note that a Data Editor role can edit user-managed services that are pulling data from enterprise geodatabases as long as the Advanced Editing extension is activated. You would think that the same settings would work with a user-managed service that uses the UN, but it does not. This strikes me as a possible bug in 11.3. ... View more

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