Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am loading an excel document from SharePoint. Both of the following methods work from my local machine using the QlikView client:
Load * From [http://Server/00/XYX/Shared%20Documents/Good%20Document/RATES.xls]
and
Load * From [\\Server\00\XYZ\Shared Documents\Good Document\RATES.xls]
On the server using publisher, ONLY the http address method works. Using the Path I get an error Cannot open file...the network name cannot be found,
The reason I HAVE to use the path is in a future load (which works great on my local machine) I am loading using a wildcard (*) so it grabs all of the spreadsheets in a specific directory. I cannot use a wildcard in an HTTP format....not allowed, but can using the path.
Is the shared folder available for the account running the QlikView Services on the server?
Yes the User running the QlikView Services is authorized to the shared folders. I've made some progress with a change to the proxy for the service id that has helped. Now I get the message that Access is Denied. It appears the widows credentials are not being passed through when accessing via the path. When manually trying to access the path via windows, it always prompts me for my credentials from the server only. From my local machine it does not prompt me.
I have similar problem. When using the Publisher in the server and folder access (i.e. not the http) I get the Access denied error in the file reload log.
When manually reloading from desktop client also in the server with the folder access there is no problem accessing the same list of files.
I also need the folder access with * to work. Otherwise script will become quite complex.
So any news on this?