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?
Solved
Do 1 bookmark before another
- Contributor
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.
How 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.
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.
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:
+64- Evangelist
You can also use the FeatureHolder to detain features between transformers (within the same bookmark or between bookmarks).
- Contributor
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.
How do I make sure the rows are deleted before FeatureMerger is triggered?
Thanks for the advice so far @geomancer @david_r
+64- Evangelist
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.
+66- Best Answer
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.
How 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.
- Contributor
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.
Thanks, this gets rid of my need for the first step!
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.