I will be receiving a spreadsheet with a list of streetlights that have been removed from the field. I need to select these lights in my streetlight feature class and delete them. I can read the spreadsheet and the feature class but how do in select or filter the streetlights and delete them?
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.
Have you looked at the DatabaseDeleter transformer?
No, I have never heard of it. It does look like it will to the trick.
- 8394 replies
No, I have never heard of it. It does look like it will to the trick.
I think that would be the easiest solution. There's an alternative solution using a regular writer and the fme_db_operation attribute, but it's slightly more complicated. It's documented here:
https://knowledge.safe.com/articles/43885/data-loading-updating-and-deleting.html
https://knowledge.safe.com/articles/31700/updating-databases-using-change-detection-to-set-f.html
Thanks David, I will check it out.
David,
I am not able to get the Database Deleter to work. I get an error when it runs and there is no place to set the transaction type to 'Versioned Edit Session' that I can find. Do you have any thoughts?
Thanks
Don
Table/feature class 'ACE.Light' is versioned. The 'Transaction Type' keyword must be set to 'Versioned Edit Session' in order to write to versioned tables/feature classes