I have a simple workbench that read data from a table and produce a number of Excel files. Depending on the config, the output can be 2, 3 or more Excel files (via FeatureWriter). At the end, I want to send the result by email. If I use Emailer and put my attachment manually, it works perfecly, but if I want it to be more flexible, I want as many attachment as my workbench produce. Is it possible to concatenate the output dataset produced ? I tried but failed... any Idea ? No zip please!
Page 1 / 1
It's an annoying problem for sure. I have run into this one too. In the end Zipping proved to be the best solution for my particular case.
Prior to Zipping I was using multiple Email transformers each with a different number of attachments, it's fine if you only have a limited number of attachments, however, if it literally could be any number then I really don't see a way around Zipping.
Unless of course creating multiple Sheets in a workbook would be an option? This is definitely doable in FME. The Sheet can be the FeatureTypeName and all can be written to the same xlsx file
Why is zipping for you not desirable?
Exactly what I did. One workbook (Excel), with multiple Sheets. But the problem is still there. We should be able to concatenate multiple output or use a "list" of object to attach to the email. Anyway, better to find a workaround... thanks!
Exactly what I did. One workbook (Excel), with multiple Sheets. But the problem is still there. We should be able to concatenate multiple output or use a "list" of object to attach to the email. Anyway, better to find a workaround... thanks!
Couldn't agree with you more. Here vote on the idea I just created: https://community.safe.com/s/idea/0874Q000000j0DbQAI/detail