topic Re: Getting data from share point into qlikview 11 in QlikView

Getting data from share point into qlikview 11

Mon, 16 Jul 2012 06:05:39 GMT

Hi All,

I just want to know the steps for getting the data from share point and i am very new to this and even i want know we need any connector for this. Please let me know the details. and please guide me step by step.

Really m looking for ur help.

Regards,

Kamala

Re: Getting data from share point into qlikview 11

Mon, 16 Jul 2012 08:30:58 GMT

Anybody have any idea please let me know

Re: Getting data from share point into qlikview 11

mikecrengland — Mon, 16 Jul 2012 20:57:59 GMT

this might help:

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

Re: Getting data from share point into qlikview 11

Tue, 17 Jul 2012 05:34:22 GMT

hi mike,

thanks for ur reply is thr any connecter needed for this

Re: Getting data from share point into qlikview 11

qlikviewforum — Mon, 27 Aug 2012 09:42:22 GMT

Have you achieved it? I am also looking for the same...

Re: Getting data from share point into qlikview 11

chematos — Wed, 29 Aug 2012 19:20:04 GMT

Using QlikView Desktop as a browser:

1.- File -> Open URL (using the URL to go to the login page of your sharepoint)

2.- Logging in sharepoint

3.- Follow the steps in the document http://community.qlik.com/docs/DOC-1308

hope this helps, if you want take a look to this thread

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

Re: Getting data from share point into qlikview 11

avastani — Thu, 30 Aug 2012 02:00:19 GMT

you can get data from Sharepoint lists via Web Files option

FROM [http://server.address.com/sites/projectdirectory/Docs/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List=%7B69106315%2DA1D6%2D47A6%2DB97A%2DC9E4A7BE001E%7D] (XmlSimple, Table is [xml/data/row])

Re: Getting data from share point into qlikview 11

qlikviewforum — Thu, 30 Aug 2012 05:19:48 GMT

Thanks for your help! But the sharepoint URL from where I am trying to fetch the data is authenticated. Do you think it will work out?

Do you mean to say that I just need to replace the above URL with mine to reload the data? Could you please elaborate?

Re: Getting data from share point into qlikview 11

avastani — Thu, 30 Aug 2012 13:24:42 GMT

Are you not in the intranet when reloading?

-afv.

Tel: 646.773.7936

Re: Getting data from share point into qlikview 11

qlikviewforum — Fri, 31 Aug 2012 05:12:09 GMT

Yes I am in intranet when I reloading the data. I am trying to reload from the server. Due to security reason I need to pass the credentials to access the sharepoint link. Where as when I am connected to my onsite machine as it is is already in network I can access the link without passing the credentials. Hope it is clear now.

Also as discussed please elaborate on how to do the below with more explanation!

FROM [http://server.address.com/sites/projectdirectory/Docs/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List=%7B69106315%2DA1D6%2D47A6%2DB97A%2DC9E4A7BE001E%7D] (XmlSimple, Table is [xml/data/row])

Re: Getting data from share point into qlikview 11

qlikviewforum — Fri, 31 Aug 2012 12:10:24 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 that? Any help please?

Thanks,

qlikviewforum

Re: Getting data from share point into qlikview 11

avastani — Fri, 31 Aug 2012 12:52:13 GMT

Writing a connector is then your only option.

-afv.

Tel: 646.773.7936