topic Dynamically Load Files From SharePoint in QlikView

Dynamically Load Files From SharePoint

Anonymous — Wed, 12 Jun 2013 18:23:16 GMT

Hi all, I'm trying to load a dynamic list of files from a specific directory in SharePoint. I've tried using both the HTTP and the UNC paths for the SharePoint directory and to load the files using both a wildcard load and a for loop that utilizes FileList() but nothing is working. Using the UNC path with a wildcard works on my local machine but as soon as I move the dashboard to our QV server it says the directory cannot be found. Does anyone have any ideas on whether this can be accomplished or not and if it is possible, how I would go about doing it? I appreciate your help in advance.

Re: Dynamically Load Files From SharePoint

Wed, 12 Jun 2013 19:50:51 GMT

Please check you QV server Windows account access to share point or not ?

Re: Dynamically Load Files From SharePoint

Anonymous — Wed, 12 Jun 2013 20:00:54 GMT

Yes, the server definitely has access to SharePoint. I am able to read the files if I specify individual paths for each file but not when I try to read the filelist from the directory.

Re: Dynamically Load Files From SharePoint

Mon, 06 Jan 2014 09:48:15 GMT

Hi Kevin,

Even i am working on the same issue did u got the solution for this or is there any workaround for it,

Please let me know

Thanks & Regards

Mallikarjuna

Re: Dynamically Load Files From SharePoint

Anonymous — Mon, 06 Jan 2014 13:45:04 GMT

I was never able to come up with a solution to this problem. We eventually had to move these files to a local folder to be able to read the meta-data on each of them. Sorry I couldn't be of more help.

Re: Dynamically Load Files From SharePoint

fseregaza — Wed, 11 Jun 2014 10:03:00 GMT

Hello,

Actually, we had the same issue and we had to turn our URL into a path.

Sample:

Original URL = http://wssemea.sample.com/ws/MTPlanManagement/QlikView Folders/GLOP/*.xls'

Path used = \\wssemea.sample.com\ws\MTPlanManagement\QlikView Folders\GLOP\*.xls'

This solution works perfectly on our side.