can i unzip a file in Qlikview?

[Anonymous]

Hi all i am just wondering if it's possible to unzip a file using  a script 

can i unzip a file in Qlikview?

[#2]

I'm guessing you mean unzipping your log files without just RDP'ing into your server, right?

You could probably try a command-line unzip program, like PKZIP:

Then, within a QV app, use a Launch action to run it: External > Launch > pkunzip.exe *.zip c:\QVLogs

[Anonymous]

what i understood from your comment  that it's not possible within the script..correct?

can you explain more

[#4]

I dont think it is possible within the script. But the method mentioned above should take care of your problem.

Mark as answered with the correct answer in order to help fellow forum users.

[chrisbrain]

If you mean from the QlikView load script then this should work:

execute "c:\Program Files\7-Zip\7z.exe" e "C:\QVSource\Temp\My CSV File.zip" -y -oc:\QVSource\Temp

You will need 7zip installed and to change the second two underlined paths to suit your needs.

I have been testing this with our Google Drive Connector to download a zip file to the local hard drive, unzip it and load it into QlikView:

http://wiki.qvsource.com/Google-Drive-Connector-For-QlikView.ashx?NoRedirect=1#Downloading_A_File_To...

[Peter_Cammaert]

Chris' solution doesn't use a bat/cmd file, the zip/unzip program is started directly.

Any particular reason why you want to use a macro? Usually the files you want to zip/unzip are either input or output files from a reload, which makes embedding the command in your load script a logical choice...

Peter