topic Re: Loading a List from SharePoint in QlikView

Loading a List from SharePoint

alec1982 — Wed, 25 Jul 2012 18:25:24 GMT

Hi,

I was able to load data from sharepoint using the List name and the web file bath.

I have noticed that it relaods normally if I am logged to the Sharpoint site.

but if I am not then it fails.

Is there anyway I can pass the credentials so it doesn't fail?

Thxs,

Re: Loading a List from SharePoint

alec1982 — Wed, 25 Jul 2012 21:28:18 GMT

I tried to run some batch files to make the connection but no luck!

Re: Loading a List from SharePoint

rajni_batra — Thu, 26 Jul 2012 07:57:15 GMT

when u login to browser and enter the credentials,

select the option save credential there in pop up.

after that try to reload,

hope it would work..

Re: Loading a List from SharePoint

alec1982 — Thu, 26 Jul 2012 14:02:14 GMT

This way works but the problem is everytime the system restart I will get an error.

I have created a batch file to set the current credntials as defult and added it to the publisher as supporting task and run it before the application run.

It works just fine!

Re: Loading a List from SharePoint

rajni_batra — Fri, 27 Jul 2012 05:30:12 GMT

Hi alec,

Can u share the batch file with us i think it would be helpful for me also..

Re: Loading a List from SharePoint

alec1982 — Mon, 30 Jul 2012 13:50:25 GMT

Just create a new batch File and add the following:

$webclient = new-object System.Net.WebClient

$webClient.UseDefaultCredentials = $true

Run the batch file as an external task before you load the QVW from Sharepoint.

Thxs,

Re: Loading a List from SharePoint

Tue, 21 Aug 2012 04:48:06 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. Can same be done with the help of batch file?

Created the new thread for the same below.

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

Thanks,

qlikview forum

Re: Loading a List from SharePoint

Tue, 04 Dec 2012 16:01:01 GMT

If you are using same user & pwd than your WIndows log on, do following:

- Open Internet Explorer and go to 'Internet Options'>'Security'>'Trusted Sites' then add your QV Server there

- Then, press button 'Custom Level' and in listed options select 'Automatic logon with current username and password'

This will allow your PC to use same user name & password you used to login into WIndows.

Then, you should be able to work with Web Pages that require your windows user name & password for authentication.

QlikView do not store User Name & Password for web pages, so It's the only way I find out to make it works.

Said that, you should do same in QV Server to make it work for reload tasks as well.

If it doesn't work, you can try to mark it by command line with a bat file:

$webclient = new-object System.Net.WebClient

$webClient.UseDefaultCredentials = $true