Can anyone share an example of how to unzip/decompress a file in a workflow? | Community
Skip to main content
Level 2
September 16, 2020
Solved

Can anyone share an example of how to unzip/decompress a file in a workflow?

  • September 16, 2020
  • 2 replies
  • 2738 views

I saw this question and attempted to test the same but unfortunately couldn't get it to work with either a zip or gz. my js ended up looking like:

 

var cmdStr="unzip -j /folder/folder/folder/tester.zip -d folder/folder/folder";

var res=execCommand(cmdStr);

 

i also read elsewhere that decompressing a file is possible in the data loading activity, by choosing 'pre-process the file' then inputting gunzip -c <%= vars.sourceFile %>

again couldn't get this to work

 

lastly i tried gunzip in a js activity, code was like:

 

execCommand('cd /folder/folder/folder \n gunzip "tester.csv.gz" ');

 

but again couldn't get it to work. am sure i am doing something basic wrong but error message just says error while evaluating so not sure what.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by stephenjwz

turns out it was just an issue with our configuration that prevented me seeing the decompress/decrypt dropdown on the data loading activity - all sorted now

2 replies

DavidKangni
Community Advisor
Community Advisor
September 17, 2020

script looks fine.

Can you check if you are authorized to run execCommand on ACC?

Thanks,

David

David Kangni
Level 2
September 17, 2020
gave myself "PROGRAM EXECUTION" Named right; "Right to execute external programs" but still the same outcome
stephenjwzAuthorAccepted solution
Level 2
September 24, 2020

turns out it was just an issue with our configuration that prevented me seeing the decompress/decrypt dropdown on the data loading activity - all sorted now