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
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.
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.
+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