Skip to main content
Solved

Do 1 bookmark before another

  • November 16, 2021
  • 6 replies
  • 176 views

rtreecare
Contributor
Forum|alt.badge.img

I have 8 bookmarks each are doing separate tasks. However, the 1st bookmark must be done before the others. And the 8th bookmark must be done last. How do I enforce this?

Best answer by nielsgerrits

I'm still pretty new to this. So i've attached a screenshot of the first two bookmarks.

The first is to delete all records (this is running but for some reason not deleteing anything)

The 2nd inserts data from 3 tables into an existing table.

Delete then appendHow do I make sure the rows are deleted before FeatureMerger is triggered?

Thanks for the advice so far @geomancer​  @david_r​ 

Use a FeatureWriter, not a classic Writer, then you have a summary output port which you can use to initiate the next step. For example a FeatureReader.

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.

6 replies

david_r
Celebrity
  • 8391 replies
  • November 16, 2021

How easy this is to implement can vary quite a bit depending on how the workspace is structured. Just know that bookmarks are visual elements that have no bearing on the order of execution by themselves.

Have a look at the documentation for different strategies on how to control transformer flow:

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/Workbench/Controlling-Transformer-Flow-at-Runtime.htm


geomancer
Evangelist
Forum|alt.badge.img+58
  • Evangelist
  • 932 replies
  • November 16, 2021

You can also use the FeatureHolder to detain features between transformers (within the same bookmark or between bookmarks).


rtreecare
Contributor
Forum|alt.badge.img
  • Author
  • Contributor
  • 15 replies
  • November 16, 2021

I'm still pretty new to this. So i've attached a screenshot of the first two bookmarks.

The first is to delete all records (this is running but for some reason not deleteing anything)

The 2nd inserts data from 3 tables into an existing table.

Delete then appendHow do I make sure the rows are deleted before FeatureMerger is triggered?

Thanks for the advice so far @geomancer​  @david_r​ 


geomancer
Evangelist
Forum|alt.badge.img+58
  • Evangelist
  • 932 replies
  • November 17, 2021

There is no need to delete all records from a table before adding new features. In the Database Writer you can set Table Handling to 'Truncate Existing' (or 'Drop and Create').

This also makes sure that records will only be removed when FME is about to insert new records.

Truncate Existing 


nielsgerrits
VIP
Forum|alt.badge.img+60
  • 2937 replies
  • Best Answer
  • November 17, 2021

I'm still pretty new to this. So i've attached a screenshot of the first two bookmarks.

The first is to delete all records (this is running but for some reason not deleteing anything)

The 2nd inserts data from 3 tables into an existing table.

Delete then appendHow do I make sure the rows are deleted before FeatureMerger is triggered?

Thanks for the advice so far @geomancer​  @david_r​ 

Use a FeatureWriter, not a classic Writer, then you have a summary output port which you can use to initiate the next step. For example a FeatureReader.


rtreecare
Contributor
Forum|alt.badge.img
  • Author
  • Contributor
  • 15 replies
  • November 17, 2021

There is no need to delete all records from a table before adding new features. In the Database Writer you can set Table Handling to 'Truncate Existing' (or 'Drop and Create').

This also makes sure that records will only be removed when FME is about to insert new records.

Truncate Existing 

Thanks, this gets rid of my need for the first step!