Latest Contributions by LindsayRaabe_FPCWA

Hi All. I'm using the Append tool in ArcGIS Pro, and in arcpy to try and both ADD new features to a feature service in ArcGIS Online (from a feature class), as well as UPDATE existing features if they match (Upsert).  From reading the documentation here I understand that the tool should look for features with identical attributes within the fields listed under the "Update Options" section. If a feature in the Input Dataset matches a feature in the Target Dataset based on those fields, then it will update all the fields listed in the Field Map (as well as the Geometry if that option is enabled at the bottom of the pane). If no matching feature is found, then those features in the Input Dataset should be Appended as new features.  However, the behavior I'm getting doesn't seem to match that. When I have no Update fields listed, the features in my Input Dataset are being appended as New features as expected. When I do have fields listed under the Update Options section, I am seeing matching features update but new features are not being added as I would expect.  Can someone clarify if there is a problem somewhere, or if I have my understanding wrong and the Append tool is either Add or Update, not both?   ... View more

Hi Brains Trust. I've given up trying to figure this out on my own. I know that the arcpy Append GP tool will normally let me append data from a feature class to a feature service. However, when running the below code I keep getting the error displayed. Can anyone give me any pointers? I've tried working with Copilot, and also with different methods (e.g. da.updatecursor) but that doesn't work with feature services.  # Step 9: Compare and update Post_Planting_Inspection_Tracking_Base print("Step 9: Comparing and updating Post_Planting_Inspection_Tracking_Base...") arcpy.management.Append( inputs=update_data, target=post_planting_layer, schema_type="NO_TEST", field_mapping=r'Plantation "Plantation" true true false 50 Text 0 0,First,#,C:\temp\scratch.gdb\update_data,Plantation,0,50;Forest "Forest ID" true true false 6 Text 0 0,First,#,C:\temp\scratch.gdb\update_data,Forest,0,6;Species "Species" true true false 20 Text 0 0,First,#,C:\temp\scratch.gdb\update_data,Species,0,20;PlantingYear "Planting Year" true true false 0 Long 0 0,First,#,C:\temp\scratch.gdb\update_data,PlantingYear,-1,-1;RENDER_LABEL "Tenure" true true false 255 Text 0 0,First,#,C:\temp\scratch.gdb\update_data,RENDER_LABEL,0,50;PlantingFinished "Planting Finished" true true false 0 Date 0 0,First,#,update_data,MAX_FinishDate,-1,-1', subtype="", expression="", match_fields="Plantation Plantation;Forest Forest;Species Species;PlantingYear PlantingYear;PlantingFinished MAX_FinishDate;RENDER_LABEL RENDER_LABEL", update_geometry="UPDATE_GEOMETRY" ) print("Features added/updated - process complete!")   Step 9: Comparing and updating Post_Planting_Inspection_Tracking_Base... Traceback (most recent call last): File "C:\Temp\Upload FPC416 Polygons.py", line 130, in <module> arcpy.management.Append( File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 7306, in Append raise e File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 7303, in Append retval = convertArcObjectToPythonObject(gp.Append_management(*gp_fixargs((inputs, target, schema_type, field_mapping, subtype, expression, match_fields, update_geometry), True))) File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 512, in <lambda> return lambda *args: val(*gp_fixargs(args, True)) RuntimeError: Object: Error in executing tool >>> ... View more