Latest Contributions by MicZatorsky_AEC

Hi Pete, I have successfully updated an AGOL hosted feature layer (HFL) directly from an XLSX from ArcGIS Pro 2.5.3 using a manual point-n-click approach.  You can modify this to work with a FC instead of a spreadsheet. Updates come in three types: Inserts - where you would use Append Updates - where you use Calculate Field Deletes - where you use Delete Rows My general workflow for updates was: make a backup copy of the HFL if FIDs are really your primary key, and you know they are unreliable, add a field to your HFL to hold a static version of the key  (e.g. FID_original) and populate it with the current FID value.  That way when you make a copy you'll know what the FID was.   better would be to get used to using GlobalIDs.  Some tools will honor preserving these between operations But for now your FIDs should work. prepare the XLS or FC and check that source and target keys will match, get record count for checking later use the Add Join tool, matching your HFL FID to your XLSX/FC FID.  Keeping all target features is optional, useful if you want to see what didn't match with the joined result, check that matched and unmatched rows are are exactly what you expect use Calculate Field to update the HFL values with XLSX / FC values In pro 2.5 I had to use an Arcade expression to get it to work with Excel Remove join Check the update result through the AGOL interface - you can filter for records updated by you today and check the count matches what you expect If this was a regular update for 20 fields, ModelBuilder or Python with a stack of Calcuate Field calls should work. If you're cautions, publish a copy of your Hosted Feature Layer to an AGOL dev group and test on that first.   Mic ... View more