Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Saravanan_Desingh

Unzip a sharepoint (web) file

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.

6 Replies
Saravanan_Desingh
Author

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.

arthur_dom
Creator III
Creator III

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.

Saravanan_Desingh
Author

Hi Arthur,

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

Not applicable

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.

petter
Partner - Champion III
Partner - Champion III

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

Saravanan_Desingh
Author

Hi Petter,

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