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?
david_r wrote:
Have you looked at the DatabaseDeleter transformer?
No, I have never heard of it. It does look like it will to the trick.
donjensen wrote:
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
donjensen wrote:
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
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.