Skip to main content
  • EN

I have followed this tutorial:

Updating ArcGIS Online Feature Services using UPSERT (safe.com)

As the last screenshot shows, I have 1495 records. 

Comparing the original CSV used to do the initial data load and the updated CSV, the new records in the updated CSV have not been added and existing records with changed attributes have not been updated.

The tutorial suggests this is possible using the UPSERT operation. 

Example update I expected with the highlighted text the changed attribute value:

 

1000,ZYX3116631180,-123.093432,49.281221,31180,-53.7761,-21.7304,1,2011-12-02 22:01

 

Example add I expected:

 

9000,ABC1069610710,-123.093414,49.281637,10710,-79.377,-17.3218,1,2021-12-06 1:41

Hi @fmemapper, 1,495 records in FME and 2,086 features in the feature service is the correct number (the difference is made up of the new/revised features and the features that were left untouched in AGOL). You mentioned some screenshots in your post but I don’t see them. Would you be able to re-attach them so we can take a look?

Hi @saraatsafe, I attach screenshots of my results. Note - I am using FME Workbench 2023.1.

Hi @fmemapper, apologies for the late reply; I was away last week. The numbers you see in FME are correct: 
at the start of part 2 of the article, the feature service has 2,086 features. Updates.csv has 1,623 new features to add (or to update an existing feature). 

2,086 - 1,623 = 463 features that are left untouched in AGOL. We can then add the 1,623 new/revised features, and subtract the 591 deleted features for a total of 1,495. 

Image_2023-10-31_14-11-51.png
I hope this helps!

Reply


Community Stats

30,351
Posts
115,341
Replies
38,080
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.