topic Re: Using wildcard in load script for sharepoint folder in QlikView

Using wildcard in load script for sharepoint folder

Anonymous — Tue, 01 Sep 2015 16:43:46 GMT

Hi guys, I'm working on a script which should only read the latest uploaded file in a sharepoint folder, so I'm using * to read all the files in the folder and after that I peek the one with greatest FileTime, it works just fine in local machine, but then when IT runs it in QMC server it fails, has anyony gone through this or anyone has a clue how to solve it?

LOAD FilePath() as Name,FileTime() as Time

FROM \\hpi12.sharepoint.hp.com\teams\PPSA-SC-QV-REPOSITORY\NACC_BUILD_TRIGGER_ORDERS\*.XLSM (ooxml, embedded labels, table is [BT])

Error: Cannot open file '\\hpi12.sharepoint.hp.com\teams\PPSA-SC-QV-REPOSITORY\NACC_BUILD_TRIGGER_ORDERS\*.XLSM' The network path was not found.

Regards

Re: Using wildcard in load script for sharepoint folder

petter — Tue, 01 Sep 2015 17:03:02 GMT

It is probably due to access rights to SharePoint for the QMS service account (user). It must have rights to read the file in SharePoint.

Re: Using wildcard in load script for sharepoint folder

Anonymous — Tue, 01 Sep 2015 17:06:01 GMT

Nope the sharepoint has the QMS service account added to the owners group

Re: Using wildcard in load script for sharepoint folder

petter — Tue, 01 Sep 2015 17:21:10 GMT

and you have checked that the \\hpi12.sharepoint.hp.com is accessable from the QlikView Server manually?

Re: Using wildcard in load script for sharepoint folder

Anonymous — Tue, 01 Sep 2015 17:24:48 GMT

It should, but I have no way to check it, as all server/QMC activities are on IT side

I've read SharePoint lists before in QV and they have worked, that's why I'm guessing it should be fine.

I read in a another post, that wildcards are not supported when reading a web folder, but I'm not sure.

Re: Using wildcard in load script for sharepoint folder

petter — Tue, 01 Sep 2015 17:36:06 GMT

This is not a web folder but a UNC-path... If it was a web folder it should start with http: or https:

Re: Using wildcard in load script for sharepoint folder

Anonymous — Tue, 01 Sep 2015 17:40:51 GMT

It is a web folder in a SharePoint site, the original URL does start with https:

But in order to make it work with wildcard in my pc I had to use it as UNC-path

Running it with web format:

LOAD * FROM

[http://hpi12.sharepoint.hp.com/teams/PPSA-SC-QV-REPOSITORY/FCT/*.xlsx]

(ooxml, embedded labels);

Gives me this error:

Bad Zip File

Re: Using wildcard in load script for sharepoint folder

petter — Tue, 01 Sep 2015 17:46:14 GMT

If you don't use HTTP ....

Then you are using your Windows AD group and user rights to both go through Windows Share and Windows NTFS rights to get access to the directory (folder) ... this does not involve SharePoint rights in the same way although SharePoint also use AD. So then the QMS service account need the same rights for the Windows Share and Windows NTFS ....

Re: Using wildcard in load script for sharepoint folder

Anonymous — Wed, 11 Oct 2017 10:16:39 GMT

Hello,

I'm having the same trouble.

Did you find any solution?

Just in case, in specifie my problem:

I'm trying to load files from a sharepoint.

So if I put the specific file name, it works. But if I put a wildcard, it doesn't.

Example:

So the commented FROM it works, but the not commented one, if I run it I got an error.

Any solution for this? I can't understand why it doesn't work with the wildcard.

Thank you so much.