Skip to main content
Question

Can we update/delete/insert multiple attributes using feature writer ?

  • April 5, 2019
  • 2 replies
  • 67 views

actually what I am trying to do is reading two GDBs one with updated values and one having old entries. Suppose in GDB 1 there are entries like 1,2,3,4and 5 and in updated GDB2 the entries are like 1,2,4,& 6. So I don't want to create new GDB I just want to add entry 6 in GDB1 and remove entry 3 & 5 from GDB1. For finding out the change I have made use of Change detector but after that when I am trying to insert it in the GDB I am able to update just one feature type at once but not all feature types

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

  • 8 replies
  • April 5, 2019
Create an attribute called fme_db_operation. Set the attribute based on your criteria - use the values INSERT, UPDATE, or DELETE. On the Writer, it will respect those values by inserting some, deleting others, etc., but you should set the writer to UPDATE and your match field like OBJECTID so the record lookup wiil work for the update.

  • Author
  • 1 reply
  • April 8, 2019
Create an attribute called fme_db_operation. Set the attribute based on your criteria - use the values INSERT, UPDATE, or DELETE. On the Writer, it will respect those values by inserting some, deleting others, etc., but you should set the writer to UPDATE and your match field like OBJECTID so the record lookup wiil work for the update.

But what if we have different primary key for different feature class of gdbs and we want FME to detect on its own what are the things to update, delete and add.