Skip to main content
Solved

ZIP destination according to size and send mail

  • February 22, 2018
  • 7 replies
  • 22 views

geo-x
Supporter
Forum|alt.badge.img+6

Hello FME community !

I've a treatment with MDB destination and I would like to ZIP this MDB at the end of the WorkBench but with a size specification.

For the moment, I used this article and the result is a unique ZIP file so fat.

What I want is (like 7-zip) to divide this file in different volumes with a userdefined size.

In the better world, I would like before this operation to send an e-mail with this ZIP file.

Can you help me ?

Thank you.

Best answer by itay

Hi,

You can use 7zip via a systemcaller transformer.

So essentially write the mdb not zipped and then run a second workspace calling 7zip to do the zipping and mailing.

Hope this helps.

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.

7 replies

itay
Supporter
Forum|alt.badge.img+18
  • Supporter
  • 1442 replies
  • Best Answer
  • February 22, 2018

Hi,

You can use 7zip via a systemcaller transformer.

So essentially write the mdb not zipped and then run a second workspace calling 7zip to do the zipping and mailing.

Hope this helps.


ryanatsafe
Safer
Forum|alt.badge.img+11
  • Safer
  • 34 replies
  • February 23, 2018

Hi,

You can use 7zip via a systemcaller transformer.

So essentially write the mdb not zipped and then run a second workspace calling 7zip to do the zipping and mailing.

Hope this helps.

 

Adding to this, you could use a FeatureWriter to write out the MDB file, then the SystemCaller to use 7-Zip, and then the Emailer to send the email.

geo-x
Supporter
Forum|alt.badge.img+6
  • Author
  • Supporter
  • 89 replies
  • February 23, 2018

 

Adding to this, you could use a FeatureWriter to write out the MDB file, then the SystemCaller to use 7-Zip, and then the Emailer to send the email.
Do you think it's possible to use systemcaller and Emailer in the same WorkBench ?

 

 


geo-x
Supporter
Forum|alt.badge.img+6
  • Author
  • Supporter
  • 89 replies
  • February 23, 2018

Hi,

You can use 7zip via a systemcaller transformer.

So essentially write the mdb not zipped and then run a second workspace calling 7zip to do the zipping and mailing. 

Hope this helps.

And for information the code of the SystemCaller like that :

 

 

 "C:\Program Files\7-Zip\7z" a mypath\test.zip mypath\test.mdb -v9M -aoa

 


itay
Supporter
Forum|alt.badge.img+18
  • Supporter
  • 1442 replies
  • February 23, 2018

 

Adding to this, you could use a FeatureWriter to write out the MDB file, then the SystemCaller to use 7-Zip, and then the Emailer to send the email.
True that! the FeatureWriter makes it possible all in ome ws....guess its not ingrained enough (old time user)

 

 


ryanatsafe
Safer
Forum|alt.badge.img+11
  • Safer
  • 34 replies
  • February 23, 2018
Do you think it's possible to use systemcaller and Emailer in the same WorkBench ?

 

 

I've used a SystemCaller and an Emailer in the same workspace before. It should work, but in this case the trick will be getting the attachment names specified in the Emailer. I've never tried that with wildcards, which is what you'll need if there is a variable number of zip files created by 7zip.

 

 


geo-x
Supporter
Forum|alt.badge.img+6
  • Author
  • Supporter
  • 89 replies
  • February 26, 2018
True that! the FeatureWriter makes it possible all in ome ws....guess its not ingrained enough (old time user)

 

 

 

Thank you Itay, but how can I do for define an order of execution in a WS ?