Loading data from share point

[#1]

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

[chriscammers]

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

[shelvinpatel]

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.

[qlikviewforum]

Hi

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

[qlikviewforum]

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

[qlikviewforum]

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

[chriscammers]

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

[qlikviewforum]

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.

[chriscammers]

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

[qlikviewforum]

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