topic Re: Loading data from share point in QlikView

Loading data from share point

Thu, 15 Mar 2012 06:06:03 GMT

hi all

i have few xlsx files (data files) in our SharePoint location. I tried loading those files by using Data From Files > Web Files (i gave the SharePoint http URL) wizard but the file loading failed. (It gave some zip error in the wizard's panel)

Any idea how to read or load xlsx files from SharePoint Server to QV (ver 10) ? Please Advice ?

Thanks in advance

Loading data from share point

chriscammers — Thu, 15 Mar 2012 10:11:20 GMT

Take a look at this thread http://community.qlik.com/message/52874#52874

The two issues I encountered were identify and use UNC path

Adding web client service to machine attempting to load the sheet.

Good Luck

Chris

Loading data from share point

shelvinpatel — Thu, 15 Mar 2012 10:41:13 GMT

First check is to copy url in IE browser on same server with same user logged in and ensure that you can open the file without prompting any credentials.

Let me know the outcome.

Re: Loading data from share point

qlikviewforum — Mon, 20 Aug 2012 13:34:19 GMT

The particular sharepoint where I am going to fetch the data needs authentication. Could you please let me how that can be done please.

Created the new thread for the same below.

http://community.qlik.com/message/249859#249859

Thanks,

qlikview forum

Re: Loading data from share point

qlikviewforum — Mon, 27 Aug 2012 07:49:27 GMT

What is that you have done regarding the issues you have encountered?

Re: Loading data from share point

qlikviewforum — Wed, 29 Aug 2012 12:43:31 GMT

What is the next step once you have found the UNC path and have installed the WebClient. Please guide me regarding the same please!

Re: Loading data from share point

chriscammers — Wed, 29 Aug 2012 16:07:15 GMT

You then use the unc path as the file location of a table file in your script...

did you read this thread? http://community.qlik.com/message/52874#52874

Re: Loading data from share point

qlikviewforum — Wed, 29 Aug 2012 16:17:04 GMT

I have already read that but still I am not clear about what loading the data using the unc path. Can you please elaborate little bit. It will help us!

Also first of all may I know how to find the unc path. As per me I have exported the report to excel and there is one column called as path I am considering that as unc path. Am I correct?

But when I try to locate the file from table file in the edit script it is not going to the next step. Seems to be this is not the path.

Re: Loading data from share point

chriscammers — Wed, 29 Aug 2012 17:09:33 GMT

Here is a good explanation for finding the UNC path of a document on sharepoint

http://whitepages.unlimitedviz.com/2010/12/unc-path-naming-for-files-stored-on-sharepoint-2/

once you have your path to the document you can treat is like whatever kind of file it is, text, csv, excel... whatever

Load * from

[\\ServerURL\DavWWWRoot\Site1Name\Site2Name\LibraryName\FolderName\ExcelFile.xlsx]

(ooxml, embedded labels, table is Table1);

I hope this helps

Re: Loading data from share point

qlikviewforum — Thu, 30 Aug 2012 05:38:36 GMT

Hi Chris

Thanks for the whitepage! But I couldn't do anything with the that because I URL from which I am trying to fetch the data is from .aspx page. So I don't know how could I find the UNC path using .aspx page.

What I thought was when I exported the report to excel I could see one column called path. So I thought this could be the UNC path. Also the path is something like this rterter/erterter/dfyd/ete. There is nothing like ExcelFileName.xlsx. Hope your are clear what I am confused about.

Any help on this please!

Thanks,

qlikviewforum

Re: Loading data from share point

qlikviewforum — Fri, 31 Aug 2012 12:12:06 GMT

Hi All,

I tried my level best but unfortunately couldn't able to succeed yet.

I read some where about QVSource. Is it possible to load the data from secured sharepoint site using the same? Any help please?

Thanks,

qlikviewforum

Re: Loading data from share point

chriscammers — Fri, 31 Aug 2012 12:18:30 GMT

Are you trying to get data from a Sharepoint list?

That would be totally different and not related to the original question posed in this thread. Take a look at this this thread http://community.qlik.com/thread/57573

Re: Loading data from share point

qlikviewforum — Fri, 31 Aug 2012 12:31:13 GMT

Yes! I want to fetch the data from sharepoint list only.By the way I have already reffered the above post but still couldn't make it work. Any idea where I am going wrong? Please!