Skip to main content
  • EN

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?

Have you looked at the DatabaseDeleter transformer?

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.

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


Community Stats

31,802
Posts
120,806
Replies
39,420
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.