I am manipulating a Google Sheet by inserting many rows of data via a Google Script triggered by my FME Workbench. What I wish to do is to read the Google Sheet all over again once all the insertion have been completed. I couldn't think of a way to do this except by pausing the whole workbench while the insertions are being donne.
Is there a more time-efficient way of achieving the same result?
Hi @nademmy,
You could use something like a FeatureReader to read the Google Sheet back in after inserting all of the records. This will allow you to read the data back in mid-translation. One thing to note is that the FeatureReader will do a complete read for each feature that enters the Initiator port so you will only need to send one feature to FeatureReader in order to read all of the data back in.
You can also slow down translations by using something like a Decelerator or WorkspacePauser to pause the translation for a certain amount of time before continuing the translation. For now, those are the only two transformers that I am aware of but a few other users have suggested similar ideas here in case you wanted to support these ideas:
https://knowledge.safe.com/idea/46151/pause-a-workspace-at-any-level-of-a-translation.html
https://knowledge.safe.com/idea/27935/ability-to-pause-andor-prompt-mid-translation.html
Resources: