Skip to main content
  • EN

Hello,

 

I have a geodatabase file to update with FME : some features must be updated, et some new features must be inserted in that geodatabase file. Those features are polygons with several attributes.

 

First in my script, I read the geodatabase file. Then I change some values and create new ones.

 

Finally, I use a "Esri Geodatabase (File Geodb)" writer to update former data and insert new data at the same time. I chose feature opeartion "upsert" and table handling "create if needed".

 

When I open the resulting "updated" gdb file in Arcgis Pro, I can see the updated data and... only part of the new features. There are several of them missing ! But why ?

 

Here is what I should have :

what I should have 

And here is what I get :

what i have 

Am I doing something wrong ? Is there a way to correct this ?

 

 

 

Do you correctly preserve the unique field used to update the features? If there are duplicate values in this column this could be the cause of your issue.

 

You could also create an attribute called "fme_db_operation" and set it to INSERT for features you want to insert and UPDATE for features you want to.. well.. update. You can then set the Feature Operation in your FeatureWriter to fme_db_operation and it will base the operation on the value in that field.

I usually use the Use Existing option in Table Handling, this way some attributes generated during analysis won't accidentally end up in my gdb.

Here's how this all looks in my FeatureWriter transformer:

image

Reply


Community Stats

30,108
Posts
114,299
Replies
37,745
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.