Share Point

[rajni_batra]

Hello i am extracting an excel from share point.

when i use the URL on browser it asks me the user name and password and opens the file.

but if i use the same URL in QV it displays you are nor authorized o view this.

why so?

can anyone suggest me how to extract from sharepoint

[qlikviewforum]

Are you having access to the sharepoint site??

If yes.. when you login the session gets expired in say 5-10 mins.

Check this duration and make this program to run so frequently... that the login session never dies.. This is some kind of workaround if the access is external.

- Yes, I have access to the sharepoint site. As I am logged into the network it doesn't need anymore authentication. But when I try to access the site in server it asks for authentication. As recommended I will try to run the program frequently!

If internal sharepoint site- please add the site as local site in internet properties

and the refresh should automatically happen

I think it is internal sharepoint site when access from my citrix machine. But when I try to access from the server it is asking for the authentication. As it is in the server I couldn't add as a local site in the internet properties.

Please let me know what can be done for this.

Are you having the data in Excel format at the sharepoint site?? Is it local http site or https site??

The user ID which you are trying to access is having admin rights to the site?

It is not in excel format, I have exported the data into excel format. It is https site and user ID which I am trying to access doesn't have admin rights ofcourse.

Please let me know if you have any more questions!

[subin6600]

Please dont run this code directly in the server under QEMC.

This is a normal trick which I applied is.. I created a batch file which

1. triggers the qv report to open

2. Upon open trigger the macro (this setting in QV document itself)

3. after the macro it saves the whole data into qvd local file. (this setting in QV document itself)

4. save it & close.(this setting in QV document itself)

This batch file should be scheduled by Windows Scheduler..

With this ur server authentication is solved...

Try this and let me know if it works or else will tell you whole together another method.

I know sharepoint to qlikview is hell lot of sleepless nights that I had to get it working.

But don worry i ll make u get it working..

Regards,

Subin Thomas

[qlikviewforum]

Hi Subin

Thanks for explaing me the steps. I have created the batch by refering your screen shot. But the problem is there is no Windows Scheduler in my server. First I will need to resolve this before I proceed further. But there is something called task scheduler, hopefully I can use that. Can I?

Thanks for giving me some confidence. With you I am sure I will finish this task soon.

Please let me know if you have any more questions.

Thanks,

qlikview forum

[subin6600]

Please follow the path

Start> Accessories> System Tools> Scheduled Tasks

This is what I referred too which is in default with every Windows OS..

Please check

[qlikviewforum]

Thanks! As I am using Windows Server it is there are Tasks Scheduler. Ok I will try the same as per your instructions and will update you.

[qlikviewforum]

Hi Subin

Just wanted to update you that I have created the batch file and trigger in the qvw. I have tried to execute the batch file manually and as expected qv.exe got lauched and qvw got opened and as triggered excel got opened and closed automatically(Though not refreshed as I have commented test.ActiveWorkbook.RefreshALL 'this gets excel sheet to be refreshed).

But the issue is qvw did not get refreshed and also the command prompt did not got closed automatically. Any help please?

Thanks,

qlikviewforum

[subin6600]

The procedure that I have told you now is to read the whole data from the sharepoint site into QVD's...

Then use this qvd to read the data into the original report which is scheduled in the QEMC.

Check the below shown option for auto close after the reload.

[qlikviewforum]

Hi Subin

I have added exit in the last line of the batch file and managed to close the command prompt automatically. But there is something called taskeng.exe which is not getting closed(taskeng.exe: shows the lines which is there in the batch file). Any idea what is the mistake I am doing?

Thanks,

qlikviewforum

[qlikviewforum]

Hi Subin

To create the qvd first the document should be loaded into a table then only we can store it in a qvd right? So without reloading the qvw then how we can create the qvd.

That is not happening with these procedure.

Thanks,

qlikviewforum

[qlikviewforum]

Also for your information!

When I trying to refresh the excel sheet manually it is throwing the below error.

A connection to the SharePoint site cannot be established. To synchronize or refresh your table, you must be able to connect to the SharePoint site.

I think the issue is that SharePoint site needs authentication. May I know how to overcome this issue. Because if the refresh doesn't happens then there is no point in going further.

Thanks,

qlikviewforum