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

[subin6600]

I also had this problem. Once try to log in seperately on the browser to the sharepoint site & try again in Qlikview.

If this is an internal sharepoint site you can add this link in the Internet options as one of your trusted sites.

This would solve your problem.

Hope some1 els have any better answer.

BR/Subin

[rajni_batra]

no but i dont have the authority to add this as trusted site.and also this is not an internal sharepoint.

[subin6600]

Ok. Have you tried to login on a browser & then simulatenously check thru qlikview..

[rajni_batra]

Have already tried this but showing the same result.

n if i try to open this URL on server its not working on browser but working only on local system what can b the reason.

[subin6600]

Hi,

There is an option where you can download the Excel sheet using spreadsheet int he sharepoint site itself.

This will save a file with the type 'ovwssvr.iqy'. After that

We have a task for refreshing the data in Excel sheet from the SharePoint site.So we have to make some settings which would enable the Excel sheet to beRefreshed & Updated every time it opens.

To achieve this follow these steps for enabling refresh once the Excel sheet is open.

Go to Data and Click, which would open the below windowand click properties.

And check the below two options and click ‘OK’ followed by closing the previouswindow.

Save the Excel sheet and close it.

Now we need to do it from the Qlikview report side...

Create a report which reads the data from this excel and add the below conditions..

On open of the Qlikview report a Macro gets executed which has the below script.

This is a Trigger which gets executed upon Open of the report.

This ensures the Excel application has been refreshed and closes it.

A batch file is created whichlaunches the Qlikview application and the specified report.

This triggers the macro and the Excel gets refreshedand the report is reloaded and closed.

The script for the batch file is

Hope this work around helps you achieve it.

Let me know incase if any other issues

BR/Subin

[subin6600]

Hi,

You could prbably change the variable that I used in here i.e., 'Test' to be replaced with any other variable.

And you need to make few settings in the macro edit script.

Shortcut for Macro Edit Script is 'Ctrl+M'

Select System Access for Requested Module Security &

Select Allow System Access for Current Local Security in the left below corner.

Then click on check on the left top corner or click on Test for checking the script.

Let me know incase if you are still finding any difficulties.

Regards,

Subin Thomas

[subin6600]

it is 'test.Application.Workbooks'... please check the macro script screenshot carefully..

Regards,

Subin Thomas

[subin6600]

Did you change the variable 'test' into any other name? if so please use the same in every line..

Regards,

Subin Thomas

[subin6600]

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.

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

and the refresh should automatically happen

Yes its working for me..

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?

Rgds,

Subin