Focal Point
[CLOSED] zip file from dashboard extract

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5137099076

June 03, 2014, 01:18 PM
Pedro
[CLOSED] zip file from dashboard extract
Hi,
User who does extraction of raw data from the dashboard, would like to get the file already zipped instead of a csv file, is there a way to automaticaly zip the file when generating an output report.

Thanks,
Pierre

This message has been edited. Last edited by: <Kathryn Henning>,


Production: WF 7.7.03 / OS: Solaris Sparc 64/ WebServer: Apache Tomcat/6.0/AppServer:WebLogic 10.3 /DB: Oracle 11.2/ Output formats: HTML, Excel, PDF, CSV, ZIP
June 03, 2014, 05:28 PM
Waz
We built an include that handles the zipping of files.

We just add it to the fex after the file is created.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

June 04, 2014, 07:37 AM
Pedro
Hi Waz,

Would you mind sending me this include.

Thank you
pierre.veronneau@telus.com


Production: WF 7.7.03 / OS: Solaris Sparc 64/ WebServer: Apache Tomcat/6.0/AppServer:WebLogic 10.3 /DB: Oracle 11.2/ Output formats: HTML, Excel, PDF, CSV, ZIP
June 04, 2014, 05:50 PM
Waz
Unfortunately I cannot send this code.

But the process is simple.

All you need to do is supply the filename as a variable. Call a zip utility (we use gzip, running on unix).

Then do something with the file. (Email, Return to the browser, etc)


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

June 04, 2014, 10:30 PM
Anatess
We do the same. We just hold the file and invoke the zip utility via -WINNT command-line script and then copy the zip file to a LAN drive with their USERID appended to the filename then have an -HTMLFORM to tell them that it is ready with a link to the LAN that the file is in.


WF 8.1.05 Windows
June 05, 2014, 08:20 AM
Pedro
thanks folks !


Production: WF 7.7.03 / OS: Solaris Sparc 64/ WebServer: Apache Tomcat/6.0/AppServer:WebLogic 10.3 /DB: Oracle 11.2/ Output formats: HTML, Excel, PDF, CSV, ZIP
June 05, 2014, 05:44 PM
Waz
Hi Pedro,

Please update your first post in this thread and add [SOLVED] or [CLOSED] to the title


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

June 06, 2014, 05:25 AM
Pedro
quote:
[CLOSED]



Production: WF 7.7.03 / OS: Solaris Sparc 64/ WebServer: Apache Tomcat/6.0/AppServer:WebLogic 10.3 /DB: Oracle 11.2/ Output formats: HTML, Excel, PDF, CSV, ZIP