topic Re: Loading data from Sharepoint list in QlikView

Loading data from Sharepoint list

alec1982 — Tue, 17 Jul 2012 13:51:21 GMT

Hi,

anybody knows how to load data from a sharepoint list using the URL or any method.

Thxs,

Re: Loading data from Sharepoint list

alec1982 — Tue, 17 Jul 2012 14:46:37 GMT

I was able to load data from SharePoint using the web Files laod from Edit Script.

I entered the URl of the sharepoint list and and loaded it.

It is working normally as long as no changes are made to the list on sharepoint.

I tried to add a ew Item on the SharePoint and loaded again. it faild..

Somehow the name of the tble changes once I add a new item to the sharepoint site.

Any idea on what should I do to have it working perfectly.

Thxs,

Re: Loading data from Sharepoint list

Anonymous — Tue, 17 Jul 2012 18:38:11 GMT

You can load a list via.

LOAD

ows_aaaaa,

ows_bbbbb,

%Key_xml_98C49F546A18E856 // Key to parent table: xml

FROM [http://<path to list>/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={EAAAA340-01EF-40B6-8AB7-8BD5DF076947}] (XmlSimple, Table is [xml/data/row]);

in the script

The tricky thing is to get the Listname: {EAAAAA.....

My way to do this is link the List to Excel, then look at the connection properties to get the Listname:

<LIST><VIEWGUID>{A75A8452-A561-4CFB-92B1-9D02E292320C}</VIEWGUID><LISTNAME>{EAAAA340-01EF-40B6-8AB7-8BD5DF076947}</LISTNAME><LISTWEB>http://<path to list>//_vti_bin</LISTWEB><LISTSUBWEB></LISTSUBWEB><ROOTFOLDER>/sites/germany/coll/wup/IT/Lists/Dell Bestellungen</ROOTFOLDER></LIST>

Once you have the full URL, just link a webfile as XML in Qlikview. You will get fieldnames like ows_xxxx and just need to rename.

I hope this helps.

Regards

Norbert

Re: Loading data from Sharepoint list

alec1982 — Wed, 18 Jul 2012 13:39:42 GMT

Hi,

Thank you for the replay.

I have somequestions about the query:

where could I get the Key to parent table:

%Key_xml_98C49F546A18E856

// Key to parent table: xml

May you please give me more direction specially on how to connect to excel.

Thxs,

Re: Loading data from Sharepoint list

alec1982 — Wed, 18 Jul 2012 16:04:06 GMT

I was able toconnect to excel and i have now the List name and Path:

I am still confused on how to build the query.

I appreciate your help if you could.

Thxs,

Re: Loading data from Sharepoint list

Anonymous — Wed, 18 Jul 2012 17:57:04 GMT

Alec,

open the script, click on "Web Files...." and enter the URL
you got from the instruction above into the "Internet File" field.

Click next and then select File Type "Xml" and press finish.

QV then creates the complete structure for you.

Regards

Norbert

Re: Loading data from Sharepoint list

alec1982 — Wed, 18 Jul 2012 20:09:05 GMT

I love it!!

you made my day.

Thxs so much

Badr

Re: Loading data from Sharepoint list

alec1982 — Wed, 25 Jul 2012 13:55:20 GMT

Hi,

Thanks again for your help.

I was wondering if this method would work on external SharaPoint sites.

I have tested it on our server and everything seems to work fine.

Now let's assume the List is coming from another compay(another sharepoint site), would it work?

I didn't see anything related to credentials? don't we need them?

Again thank you so much for your help. and hopefully you will have time to help me.

Alec,

Re: Loading data from Sharepoint list

Anonymous — Thu, 26 Jul 2012 18:33:11 GMT

Alec, unfortunately I have no experience with access to external sites. What I would try to do linking the list with Excel and see if Excel puts something inside the connection string. I depends how the external website is asking for the credential and if there is a chance to pass the ID and password via the URL.

Regards

Norbert

Re: Loading data from Sharepoint list

Anonymous — Fri, 27 Jul 2012 21:50:06 GMT

Alec, have a look here:

http://community.qlik.com/docs/DOC-1308

There are perhaps other solutions in the Connectivity blog.

Regards

Norbert

Re: Loading data from Sharepoint list

qlikviewforum — Mon, 20 Aug 2012 13:29:50 GMT

Hi Nobert

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 Sharepoint list

qlikviewforum — Fri, 31 Aug 2012 12:26:40 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 Sharepoint list

alec1982 — Thu, 06 Sep 2012 13:49:01 GMT

Hi guys,

Ithis was working pefrect for me when I tried it before.

Now when I add the same internet path including the same lsit name i get access denied.

Any ideas?

Thxs,

Re: Loading data from Sharepoint list

alec1982 — Thu, 13 Sep 2012 14:55:25 GMT

It is working,

Recently I hanged my network password and it is not the same as my PC log in password and that was the issue.

In order for the list to be loaded your log in password to sharepoint and to your PC should be the same.

Thxs,

Re: Loading data from Sharepoint list

qlikviewforum — Fri, 14 Sep 2012 08:04:24 GMT

In my same it is same only but still couldn't managed to load the data from the sharepoint list . Any suggestions appreciated!

Re: Loading data from Sharepoint list

alec1982 — Fri, 14 Sep 2012 13:34:37 GMT

what error are you getting?

and how is the url looks like?

Re: Loading data from Sharepoint list

qlikviewforum — Mon, 17 Sep 2012 05:56:41 GMT

Error:

Internet Error: 12045

URL:

https://trurturtu.turtu.rturtu.wywery.net/uiuy/ytityi/wrqwr/trtert/ewtwet/System.aspx

Any help appreciated!

Re: Loading data from Sharepoint list

alec1982 — Mon, 17 Sep 2012 13:42:00 GMT

Hi,

The error that you are getting is because of the secuurity on the firewall

http://testdrive.mapinfo.com/techsupp/miprod.nsf/2fa3e3416d06d61d85257125006b2533/e0a63e85d9227dbd85256c53005a95f7?opendocument

Also, did you find the name of the List?

Re: Loading data from Sharepoint list

qlikviewforum — Tue, 18 Sep 2012 06:01:27 GMT

Its not the http error. The error is when I am trying to access the URL from QlikView(WebFile). But when I try to access the URL from the Internet Explorer I am able to access the same by passing the Domain\UserId and Password. Hope it is clear?

I did not manage to get the name of the list. May I know how to get the same please?

Re: Loading data from Sharepoint list

Tue, 18 Sep 2012 10:03:33 GMT

i believe you dont have to go thorugh Web file, as i know share point just acts as our regular folder what we have in hard disk.try mapping sharepoin to your local drive then try access it via Table file itself.

hope it helps.