Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
rajni_batra
Specialist
Specialist

Share Point

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

38 Replies
qlikviewforum
Creator II
Creator II

Hi Subin

What I have done is,

1. Written a batch file to open qv.exe and reload the required qvw.

2. In the qvw I have triggered a macro to open the excel and fetch the data from site then close it.

3. What I doing is, I am manually running the task to check whether it is working or not.

4. As expected it qv.exe got lauched and opened the qvw and the trigger started as expected. As the trigger started it opened the excel automatically and then closed the excel sheet.

But the problem here is still the qvw application is open. May I know what do be done here.

If not please let me know if you have anyother alternative.

Thanks,

qlikviewforum

subin6600
Creator III
Creator III

Ok.. What is the value given to wait. function in macro????

Rgds,

Subin

qlikviewforum
Creator II
Creator II

00:00:15

Don't think this could be the reason. As I don't think reload is also happening here!

Can you send the batch file code again. So that I can copy paste anc check.

subin6600
Creator III
Creator III

Here is the batch file I am using

"C:\Program Files\QlikView\qv.exe" /r "D:\xyz\xyz\QVD Creators.qvw"

qlikviewforum
Creator II
Creator II

I am doing the samething in my batch file as well. Not sure what is missing though?

subin6600
Creator III
Creator III

try "taskkill /f /im qv.exe" for killing the appliocation then

qlikviewforum
Creator II
Creator II

Thanks Subin

I have already done that but it didn't work out!

qlikviewforum
Creator II
Creator II

Hi Subin

Any help? Forget about closing qvw. First I would like to fetch data from sharepoint which needs authentication. If this is done then I can work on other things.

As discussed may I know what are other process of doing the same? I am also trying but unfortunately couldn't find any solution.

Thanks,

qlikviewforum

qlikviewforum
Creator II
Creator II

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 the same? Any help please?

Thanks,

qlikviewforum