topic How to unzip files in qlikview ? in QlikView

How to unzip files in qlikview ?

madhubabum — Mon, 26 Oct 2015 07:21:13 GMT

Hi Experts

I have one zip file with 10 Excel files .

How to Unzip files in Qlikview (With out using Any Software like 7Z,Winrar,unzip,......etc)

Note : I don't want to install any software (Extract/Unzip data with Qlikview Script)

Thanks

Re: How to unzip files in qlikview ?

gautik92 — Mon, 26 Oct 2015 07:23:35 GMT

have a look at this

Re: can i unzip a file in Qlikview?

Re: How to unzip files in qlikview ?

mayankraoka — Mon, 26 Oct 2015 07:28:09 GMT

This is the way you can do unzip.But you should have 7zip already installed:

To unzip the file from qlikview and script and then reload:

execute "c:\Program Files\7-Zip\7z.exe" e "C:\Ifilelocationpath\TABLE.zip" -y -oc:\destination\

Regards,

Mayank

Re: How to unzip files in qlikview ?

petter — Mon, 26 Oct 2015 07:30:45 GMT

You can use PowerShell which is included with any Windows - but not necessarily activated. The best is to use the latest PowerShell 5 - which gives the most complete functionality for handling ZIP-files. PowerShell use the .NET built-in System.IO.Compression namespace which provides it with the necessary methods.

If you Google "Use PowerShell to Extract Zipped Files" and go to the Microsoft TechNet site you will find a recipe.

Re: How to unzip files in qlikview ?

petter — Mon, 26 Oct 2015 08:25:17 GMT

Actually you can do it by using the COM Shell which is built-into every single Windows by either using PowerShell or VBScript. This is the same unzip that your Windows Explorer file manager is using.

Here is the PowerShell version of it:

$shell_app=new-object -com shell.application
$filename = "myExcelFiles.zip"
$zip_file = $shell_app.namespace((Get-Location).Path + "\$filename")
$destination = $shell_app.namespace((Get-Location).Path)
$destination.Copyhere($zip_file.items(),0x14)

0x14 means overwrite and don't prompt or show progress

Here is a one-liner of VBscript that does exactly the same:

CreateObject("shell.application").NameSpace("c:\users\a-user\downloads\destdir\").Copyhere CreateObject("shell.application").NameSpace("c:\users\a-user\downloads\p.zip").items() , 20

20 at the end means overwrite and don't show progress or prompt... if you remove the parameter you see the regular progress window ...

It has to be put in a .vbs file

This can be executed from the load script by using EXECUTE.

Like this:

EXECUTE cmd /c unzip.vbs;

A much more readable and understandable version of the VBscript would be:

set shellApp = CreateObject("shell.application")
set zip = shellApp.NameSpace("c:\users\petter\downloads\testzip\p.zip")
set dest = shellApp.NameSpace("c:\users\petter\downloads\testzip\")
dest.Copyhere zip.items() , 20

Re: How to unzip files in qlikview ?

petter — Tue, 27 Oct 2015 19:58:19 GMT

Did you try out the suggestion I provided?

Re: How to unzip files in qlikview ?

madhubabum — Wed, 28 Oct 2015 07:10:50 GMT

Working fine

Thanks

Re: How to unzip files in qlikview ?

petter — Wed, 28 Oct 2015 12:00:08 GMT

Good could you please close the thread by marking it as answered?

Re: How to unzip files in qlikview ?

Saravanan_Desingh — Mon, 04 Apr 2016 19:48:37 GMT

Hi petter.skjolden‌

I was trying to unzip a web file (sharepoint file). But it is not unzipping the file. Even I'm not getting any popup if I use

MsgBox(Err.Description).

Can you please help me? I'm not good in VBS.

Re: How to unzip files in qlikview ?

petter — Mon, 04 Apr 2016 19:58:13 GMT

You can't unzip a web file. Unzipping works only on local files. So the file has to be downloaded first from SharePoint and then it can be unzipped.

Re: How to unzip files in qlikview ?

Saravanan_Desingh — Mon, 04 Apr 2016 20:08:00 GMT

T‌hanks, petter.skjolden‌

Can you please share the VBS code for downloading a web or sharepoint file to local? Thank you.

Re: How to unzip files in qlikview ?

petter — Mon, 04 Apr 2016 20:13:00 GMT

You should post this as a new question. This question has been marked as answered by Madhu Babu already.

Re: How to unzip files in qlikview ?

munna1317 — Thu, 16 Feb 2017 06:42:19 GMT

It is working for only Single file , But in Case if we have no : of Files in One folder what is Situation

Re: How to unzip files in qlikview ?

petter — Mon, 15 Oct 2018 07:32:18 GMT

You can iterate through several zip-files of course. For a cmd-file you could use ForFiles and in a PowerShell it's trivial to iterate over some files anyway.

Re: How to unzip files in qlikview ?

SeanMoss — Tue, 19 Mar 2019 03:36:01 GMT

@gautik92 wrote:
have a look at this
Re: can i unzip a file in Qlikview?

According to my experience, there is no need to download specialized software to unzip on Windows. I usually use File Explorer to extract it. I also see methods like Properties and cmd. You can search for them in Google.