Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
kmcgovern1
Contributor

Dynamically Load Files From SharePoint

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.

5 Replies
Not applicable

Re: Dynamically Load Files From SharePoint

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

kmcgovern1
Contributor

Re: Dynamically Load Files From SharePoint

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.

Not applicable

Re: Dynamically Load Files From SharePoint

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

kmcgovern1
Contributor

Re: Dynamically Load Files From SharePoint

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.

fseregaza
New Contributor III

Re: Dynamically Load Files From SharePoint

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.

Community Browser