topic Re: Unzip a sharepoint (web) file in QlikView

Unzip a sharepoint (web) file

Saravanan_Desingh — Mon, 04 Apr 2016 20:19:44 GMT

Hi,

I have a situation.

I have to unzip a spreadsheet and load it in my QV app.

When I searched the forum, I found only the local files can be unzipped.

So, in my case, I have to download the file to local and then unzip it through VBS.

Can you please help with the code? I'm not good in VBS. Thank you.

Re: Unzip a sharepoint (web) file

Saravanan_Desingh — Mon, 04 Apr 2016 20:21:29 GMT

I meant, I have a spreadsheet in the sharepoint folder, where I access it thru an URL,

So, we have to consider that as Web file.

Re: Unzip a sharepoint (web) file

arthur_dom — Tue, 05 Apr 2016 12:53:40 GMT

It is possible. With something like this:

Sub Download

dim xHttp: Set xHttp = createobject("Microsoft.XMLHTTP")

dim bStrm: Set bStrm = createobject("ADODB.Stream")

xHttp.Open "GET", "http://www.colorado.edu/conflict/peace/download/peace.zip", False

xHttp.Send

with bStrm

.type = 1 '//binary

.open

.write xHttp.responseBody

.savetofile "c:\downloads\peace.zip", 2 '//overwrite

end with

End sub

I took this from Stack Overflow thread 2973136 from Alex K.

Re: Unzip a sharepoint (web) file

Saravanan_Desingh — Wed, 06 Apr 2016 01:11:02 GMT

Hi Arthur,

Thanks. I will check and get back to you..

Re: Unzip a sharepoint (web) file

Wed, 06 Apr 2016 02:54:30 GMT

Hello, generally sharepoint sites also have the UNC drive paths and access the zip folder directly from sharepoint UNC path. Or create small script outside of Qlikview and download the files from share point site to Qlik readable drives and consume data from drive.

If you create the Macro, it won't work while reload the app.

Re: Unzip a sharepoint (web) file

petter — Wed, 06 Apr 2016 08:10:36 GMT

Which version of SharePoint are we talking about? Is it even Office 365 in the cloud?

Re: Unzip a sharepoint (web) file

Saravanan_Desingh — Wed, 06 Apr 2016 12:07:02 GMT

Hi Petter,

I'm not aware of it. But I can find it out.