topic Re: QlikView reading Excel file in SharePoint in QlikView

QlikView reading Excel file in SharePoint

Thu, 17 Jan 2013 17:40:29 GMT

I have a QlikView doc that creates QVD files (using v. 11). I want to be able to read in Excel files that will be stored on our company's SharePoint server. On my QlikView server I have mapped to the location on the SharePoint server where these files are. When I am logged into the server and have QlikView open I can manually execute the script and the QVD is produced. However when I try to reload the file in Management Console I get an error saying that access to the file is denied. Is this because the Management Console runs under a different user? Ultimately, is it possible to have the Management Console execute this procedure as I have set it up, on a scheduled basis without me having to be logged in? If not, is there a better way?

Thank you.

Re: QlikView reading Excel file in SharePoint

Bill_Britt — Thu, 17 Jan 2013 18:18:47 GMT

Here is the problem. A service does not understand a mapped drive. So, you are required to use the UNC to the share.

\\servername\sharename

Bill

Re: QlikView reading Excel file in SharePoint

Thu, 17 Jan 2013 19:12:04 GMT

This is the connection string I am using within the script:

[\\intranet.mfri.com\DavWWWRoot\Companies\MidwescoFilter\Metrics\Filter Metric Documents\ExchangeRates.xlsx]

As I mentioned, when I have the doc open in QlikView and I run the script it runs just fine. When I run the same script through the Management Console, I get the access denied error.

Re: QlikView reading Excel file in SharePoint

Bill_Britt — Thu, 17 Jan 2013 19:16:52 GMT

It has to be a rights issue. Try logging in as the account that is running publisher and see what happens.

Bill

Re: QlikView reading Excel file in SharePoint

Mon, 21 Jan 2013 09:02:33 GMT

Hi Rob,

I had a similar issue with sharepoint in Qlikview before. Try adding the Sharepoint site to local intranet sites in the security tab in internet explorer on the machine that Qlikview Server runs on. This worked in my case.

Kind Regards,

Footsie

Re: QlikView reading Excel file in SharePoint

Wed, 03 Jul 2013 15:56:40 GMT

I was having this issue but I've found the solution!!

You need to make sure that you have the WebClient service installed and running on the server and the user has access to the sharepoint library.

To install the service on the server follow these steps:

Start the Windows Server Manager.
In the tree view, highlight the Features node.
In the details pane, click Add Features.
In the Add Features Wizard, check the Desktop Experience box, and then click Next.
Click Install.
When the Add Features Wizard has finished, click Close.
Click Yes when promoted to restart the computer.