Using wildcard in load script for sharepoint folder

[Anonymous]

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

[petter]

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.

[Anonymous]

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

[petter]

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

[Anonymous]

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.

[petter]

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

[Anonymous]

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

[petter]

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 ....

[Anonymous]

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.