topic Loading Excel files from a Sharepoint site in QlikView

Loading Excel files from a Sharepoint site

Anonymous — Fri, 08 Sep 2017 08:05:48 GMT

Hello,

I've created a LOAD script to load data from Excel files stored in a folder of a SharePoint site on the network.

This script works sometimes, but other times I get this error :
Unable to open file '\\ RT-workspace.share.renault.fr \ is \ proj4509 \ 02 Organization AND Resources \ 2-SDA \ *' The network path was not found.

Do you have any idea why do I have this error message sometimes?
Is it a matter of access rights to SharePoint?
I would like to do a test by including in the script LOAD the login and password . Can you help me with that?

Thanks in advance

Re: Loading Excel files from a Sharepoint site

Anonymous — Mon, 11 Sep 2017 09:17:48 GMT

Do you have an idea that can help me?

Thanks

Re: Loading Excel files from a Sharepoint site

shraddha_g — Mon, 11 Sep 2017 09:27:55 GMT

If this is working Sometimes then there should not be any access (Authorisation) issue.

But error suggests that there might be any Network issue

Re: Loading Excel files from a Sharepoint site

ecolomer — Mon, 11 Sep 2017 09:29:46 GMT

See this:

Loading Excel file from Sharepoint into Qlikview.

Import Excel File from SharePoint to QlikView without writing Job

Re: Loading Excel files from a Sharepoint site

Anonymous — Mon, 11 Sep 2017 09:39:14 GMT

Thanks Enrique but the discussions don't adress the same problem

Re: Loading Excel files from a Sharepoint site

Anonymous — Mon, 11 Sep 2017 09:43:17 GMT

Thank you Shraddha for your answer.

Do you have any idea how to detect the network issue?

For accuracy, the SharePoint website is accessible via the browser....