topic Extracting sharepoint list data into qlikview in QlikView

Extracting sharepoint list data into qlikview

Wed, 05 Oct 2011 10:10:00 GMT

Hi all,

Ive done a search and found some articles, but I can't get this to work.

Ive gone into sharepoint list settings to extract the link to my list, and using the guide here http://community.qlik.com/docs/DOC-1308 I have constructed a link as follows:

http://rtfs01/Prod/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={%7B8EC98D85%2D4C5E%2D4298%2DB598%2D8880D9E6A3B0%7D}

I then go into the internet file wizard and paste this into the internet file line.

i should note that in the guide it says the listGUID format should be XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX, however my GUID is separated by % symbols not - symbols and appears to be more characters than in the guide.

It finds something (i.e it seems to connect to something) but my list data is not there.

Can anyone help?

Thanks

Dan

Extracting sharepoint list data into qlikview

Wed, 05 Oct 2011 10:40:10 GMT

Found the solution.

I simply needed to omit the curly brackets around the list ID and it worked.

The guide therefore needs updating.

Extracting sharepoint list data into qlikview

Tue, 14 Feb 2012 13:11:43 GMT

Are you able to reaload this qvw from the qlikview server?. We are NOT able to read sharepoint list when it runs on the qlikview server. But it works on my local machine

Thanks

Re: Extracting sharepoint list data into qlikview

qlikviewforum — Mon, 27 Aug 2012 09:50:30 GMT

Hi Dan

May I know how you gone into share point list settings? We are not able to achieve the same. I request you to help me out regarding the same.

Thanks,

qlikview forum

Re: Extracting sharepoint list data into qlikview

qlikviewforum — Fri, 31 Aug 2012 12:21:26 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: Extracting sharepoint list data into qlikview

Qvmaster2019 — Tue, 09 Apr 2013 13:14:06 GMT

This also happens to me. Qliktech sent me a patch for this but it seems not working as well.

Re: Extracting sharepoint list data into qlikview

saumyashah90 — Wed, 14 Aug 2013 08:40:56 GMT

Hi All,

I have gone through these links http://sharepointqlik.blogspot.com/2012/03/how-to-connect-sharepoint-list-to.html#!/2012/03/how-to-connect-sharepoint-list-to.html

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

also http://community.qlik.com/message/253960

i successfully made URL which is working fine, But when i load it in Qlikview i get this

and when i select XML file type i get

please help me out.

Re: Extracting sharepoint list data into qlikview

Tue, 07 Jul 2015 03:59:06 GMT

Hi,

I have been successfully extracting data from Sharepoint list using RPC call process with the help of list ID.

But the problem is that if in list any column/field is blank then I am not able to pull that column/field into qlikview can anyone suggest me how to pull all columns from list even if column is blank/empty without any data.

Thanks,

Rakesh.