I have a workspace that uses the GeoRSS reader that spatializes a newsfeed and writes to an SDE feature class. The newsfeed carries 25 items per day and a handful of news stories are posted each day. How do I configure the parameters in the writer to retain all of the old items and "append" only the new items, so as to preserve all items and build a running total?
Solved
Append new records to SDE writer
Best answer by ciarab
I have attached a sample so you get the idea of what I think you are trying to achieve. You just need to identify which records are new to your SDE Feature class and if so then they are tagged as Inserts that are added to your database if records are already there you can tag them as updates or else only choose to append new records by dropping anything that isnt a new record.
You need to use the attribute creator to set an attribute called fme_db_operation= INSERT sample.fmw
+9- Contributor
- Best Answer
I have attached a sample so you get the idea of what I think you are trying to achieve. You just need to identify which records are new to your SDE Feature class and if so then they are tagged as Inserts that are added to your database if records are already there you can tag them as updates or else only choose to append new records by dropping anything that isnt a new record.
You need to use the attribute creator to set an attribute called fme_db_operation= INSERT sample.fmw
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.