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]

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?

As soon I closed the qvw manually taskeng.exe also got closed automatically. I think if we manage to close the qvw automatically then taskeng.exe will also get closed automatically.

[qlikviewforum]

subin6600 wrote:

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. 

Hey I think once we trigger this application to refresh the excel. We need to use the same qvw in QEMC to reload the qvw so that it creates the QVD. Am I correct? If I am correct then only point where we got stuck is how to refresh the data in excel from sharepoint site which needs authentication.

Please reply me back in your convenient time. I think you must be busy now...

[subin6600]

First try to manually referesh the excel when you have logged into the sharepoint site.

Let me know what is the result..

[qlikviewforum]

I have managed refresh the excel when I am logged into my client newtwork. Here I don't need to give userid and password as the links opens automatically. But whereas when I tried to refresh in the server I couldn't refresh the excel. Any help please?

I have one good idea! I thought of refreshing the excel in my client network then with the use of scheduled tasks I thought of moving the qvd to the server. But the problem is I don't have qlivkiew installed in client network and also client are not going to accept it.

So please let me know what has to be done so as to refresh the excel in the server.

[subin6600]

Ohh....then that would be a problem as you should be able to refresh the excel where you get to have the QVD creator.

Just a wild idea... you can try though..

Let the Excel be in you local network...

And qvd creater QV program in server...

And the excel path should lead to your excel in local client network... like if say 128.25.1.12 is your system IP.

\\128.25.1.12\d$\QlikView Storage\Development\Source\In Production\refreshexcel.xls

[qlikviewforum]

Yes! What to do? I don't have any other alternative solution for this. By the way any idea how can I close the qvw application automatically through the batch file on the qvw is opened and trigger is completed. Any help please?

As discussed(If this process didn't work we can have different alternative!) if you have anyother alternative share with me.

[subin6600]

Have you included /r command in the batch file?

This should automatically open the QV document reload save and close it...

[qlikviewforum]

Yes I have already included it in the batch file!

[subin6600]

How are you trigerring macro?? it should be trigered upon open of the qvw document...

[qlikviewforum]

Yes it was triggered upon open of the qvw document!