Compress Dynamic Action

About

The Compress Package Action is a versatile tool designed to handle the creation, management, and manipulation of compressed files within a workflow. This action plays a key role in optimizing file storage, reducing data transfer times, and organizing files for easier handling and sharing. By automating the compression process, the Compress Package Action helps streamline workflows involving large volumes of data or multiple files, making it more efficient for both storage and transmission.

Supported compression formats

  • Zip archive (.zip;.jar;.ear;.war;.cbz;.apk;.wsz;.wal;.xpi;.crx;.dfsz;.pcv;.bsz;.mskin;
    .wmz;.ipa;.docx;.xlsx;.pptx;.sxw;.sxi;.sxt;.sxd;.sxc;.sxm;.sxg;.stw;.sti;.std;.stc;
    .odh;.odd;.odt;.odm;.ods;.ots;.odg;.otg;.odp;.otp;.odf;.odb)|.zip;.jar;.ear;.war;
    .cbz;.apk;.wsz;.wal;.xpi;.crx;.dfsz;.pcv;.bsz;.mskin;.wmz;.ipa;.docx;.xlsx;.pptx;
    .sxw;.sxi;
    .sxt;.sxd;.sxc;.sxm;.sxg;.stw;.sti;.std;.stc;.odh;.odd;.odt;.odm;.ods;
    .ots;.odg;
    .otg;.odp;.otp;.odf;.odb|
  • BZip2 archive (.bz2;.bzip2;.tbz2;.tbz)
  • 7z archive (*.7z)
  • Tar archive (*.tar)
  • GZip archive (.gz;.gzip;.tgz;.tpz)
  • Swf archive (*.swf)

Metadata tab

Compress Action - Metadata tab
 

  1. The Write Variables option ensures that the “Package Action” logs the variable values into the “Action vars before log file” before the action is executed and logs the updated variable values into the “Action vars after log file” after the action completes.
  2. This option is typically used for debugging and is not recommended in a production environment.
  3. It can be globally disabled through the options dialog .

Parameters tab

Compress Action - Parameters tab

N Value Parameter

The meaning of N Value parameter depends on Which File Parameter

  1. When Which File Parameter is equal to “Files Not Older Than N Days” N Value is Days
  2. When Which File Parameter is equal to “Files Older Than N Days” N Value is Days
  3. When Which File Parameter is equal to “First N Found Files” N Value file number
  4. When Which File Parameter is equal to “Bigger Than N Bytes” N Value is byte

Variables tab

The Variables tab defines the variables to be updated during the action’s execution.

Compress Action - Variables tab

Execution log tab

The Execution log tab is populated after the action is executed. Double click on the row to view the log.

Compress Action - Execution log tab

Example creating dynamic zip archive

Pascal

Compress Action - Calculated File Name example - Pascal
  Script

begin
 Result:='c:\support\'+LeftString(GETSYSTEMVARIABLE('SYSTEM_DATE'),8)+'.zip';
end;

Python

Compress Action - Calculated File Name example - Python
  Script

from datetime import datetime
Result.Value='c:\\support\\'+ datetime.now().strftime('%Y%m%d')+'.zip'
  1. Decompress Action

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum

Posted on October 12, 2024 • 2 min read • 424 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License