I want to have some action on button to reload report
I try 3 Macros
I) works only local but not in Acess Point
||) Dont Work
|'Macro in Doc A|
|Set WshShell = CreateObject("WScript.Shell")|
|Set oExec = WshShell.Exec("C:\Program Files\QlikView\Qv.exe /r D:\Test Reload\ExternalReload.qvw")|
|Set WshShell = nothing|
|Set oExec = nothing|
Set WSHShell = CreateObject("Wscript.Shell")
Any Idea how to achieve goal and reload it on AP with macro?
To reload a document on the Server, schedule a task in the Management Console. With a trigger "on external event", you could launch a reload from another source than the Distribution Service.
I set in management console
Start the task : On an external event.
In a list of tasks now I have start\schedule : On EDX.
but still when i click a butons with above macros - nothing happend.
A) You can use the QMSEDX.exe to reload from the command line: QMSEDX Enhanced
B) You could use the QlikView extension that allow reload from the Ajax-client - although you should not allow
all or many users to do the reload. Google: Qlikblog.at and goto the site and find QlikTip #47.
Both these approaches use the QMS EDX task method - but you don't have to write your own program to use it.
I'll try to use QMSEDX.exe
I test it by add an action in button
And when i test it by:
1) localy - QV - File --> Open in Server ( something reloaded)
2) on Acces point - after click on button i get new tabpage(about:blank)
You can never start an EXE-file (a program) from a browser. That would be a very very serious security risk and breach. So that has nothing to do with limitations of QlikView. You will have to use option B if you want to trigger a reload from a browser (QlikView Extension).