Skip to main content
  • EN

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.

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.

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.

 

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 ?

 

 

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

 

 

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)

 

 

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.

 

 

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 ?

Reply


Community Stats

30,194
Posts
114,615
Replies
37,858
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.