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?
Question
How do I delete features in a feature class using a list from a spreadsheet?
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.
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