Loading a List from SharePoint

[alec1982]

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,

[alec1982]

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

[rajni_batra]

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..

[alec1982 · Accepted solution]

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!

[rajni_batra]

Hi alec,

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

.

[alec1982]

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,

[#7]

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. 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

[#8]

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