topic Re: can i unzip a file in Qlikview? in QlikView

can i unzip a file in Qlikview?

Anonymous — Tue, 08 Oct 2013 09:40:33 GMT

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

can i unzip a file in Qlikview?

Re: can i unzip a file in Qlikview?

Tue, 08 Oct 2013 09:44:56 GMT

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

Re: can i unzip a file in Qlikview?

Anonymous — Tue, 08 Oct 2013 09:49:23 GMT

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

can you explain more

Re: can i unzip a file in Qlikview?

Tue, 08 Oct 2013 09:54:13 GMT

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.

Re: can i unzip a file in Qlikview?

chrisbrain — Thu, 10 Oct 2013 12:30:42 GMT

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_Your_Local_Disk_12

Re: can i unzip a file in Qlikview?

Peter_Cammaert — Thu, 10 Sep 2015 13:42:49 GMT

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