BOXIR2 Scheduling output have to Zip and send to User

Hi,

We are using BOXIR2 , we are scheduling the report to user mailid.Sometimes output file exceeds morethan 5MB,for this time user haven’t receive excel file.Because our MS server allowing max 5MB only. Now We need to zip the out put file and send to user. We had done 6.5 using macro. That same way we have implemented in BO XI as well.But its not working. Can any one help me please? What macro do i need to use in DeskI.

Thanks,

Regards,
Arasu


Arasu (BOB member since 2008-10-24)

That is to say ? what is exactly the issue you face ? maybe could you copy / past the 6.5 macro here so that bobers could check it.


bernard timbal :fr: (BOB member since 2003-05-26)

Our solution to a similar BOE-XI (R2) problem was to put the SCEHDULED object in a package, and then use the third-party APOS Report Package Booster tool to handle the ZIP and e-mail functions…


MJRBIM :canada: (BOB member since 2007-03-23)

Hi Bernard,

Thanks for your intrest, My question is simple.I want to schedule the report output with zip file.How to do?


Arasu (BOB member since 2008-10-24)

you can do it externaly with a batch file automatically calling a zip program to compress the output file


bernard timbal :fr: (BOB member since 2003-05-26)

Hi Bernard,

Thanks, can you expalin me? how to do that?


Arasu (BOB member since 2008-10-24)

In a batch file, you put the command line syntaxe so that the generated report is ziped. Then, you can schedule this batch file and link it with event so that it is sceduled at the end of your refresh


bernard timbal :fr: (BOB member since 2003-05-26)