topic Re: Zip Error with SharePoint in QlikView

Zip Error with SharePoint

Fri, 12 Jun 2015 13:56:54 GMT

Hi All,

I am getting the following error on my Dashboard. Everything was working fine until a couple of days ago. Now I get the following error when trying to reload my dashboard.

Re: Zip Error with SharePoint

Clever_Anjos — Fri, 12 Jun 2015 14:02:14 GMT

Can you open that URL using your browser? Please check this

Re: Zip Error with SharePoint

Gysbert_Wassenaar — Fri, 12 Jun 2015 14:02:16 GMT

It looks like Qlikview expected an .xlsx file and did not find a real ooxml .xlsx file. Check that the file really is an .xlsx excel file. Ooxml files are actually zip files that contain a bunch of other files that together make up the excel xlsx file.

Re: Zip Error with SharePoint

petter — Fri, 12 Jun 2015 14:02:55 GMT

An OOXML file which is what an XLSX file is - is really a zipped folder structure containing mostly XML-files and maybe some binary content.

So that the Load Script complains about Zip Error might mean that the file residing on the SharePoint site either is not a real XLSX-file or that it is indeed corrupt.

Try opening it directly in a browser by copying the URL into the location in a browser and see what your browser comes up with....

Re: Zip Error with SharePoint

arthur_dom — Fri, 12 Jun 2015 14:06:10 GMT

I copied the URL on you error and there is no excel file, but a login page, please verify with the provider of file the address

https://one.terex.com/CookieAuth.dll?GetLogon?curl=Z2FglobalZ2FitZ2520dashboardZ2520masterZ2520filesZ2FitZ2520dashboardZ…

Re: Zip Error with SharePoint

Tue, 16 Jun 2015 11:13:45 GMT

Arthur the URL is internal, not something you can get to without some credentials. I did however figure it out, the issue was that the proxy server was causing issues with the websites certificates thus causing the files to not come across.