topic Re: QlikView Load Script HTTP vs UTC in Publisher in QlikView

QlikView Load Script HTTP vs UTC in Publisher

Wed, 24 Oct 2012 19:10:20 GMT

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.

Re: QlikView Load Script HTTP vs UTC in Publisher

Anonymous — Thu, 25 Oct 2012 01:16:32 GMT

Is the shared folder available for the account running the QlikView Services on the server?

Re: QlikView Load Script HTTP vs UTC in Publisher

Thu, 25 Oct 2012 13:28:36 GMT

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.

Re: QlikView Load Script HTTP vs UTC in Publisher

Wed, 07 Nov 2012 10:34:56 GMT

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?