Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lukas_sokol
Contributor II
Contributor II

Reload documents on Server

||Hi,

I want to have some action on button to reload report

I try 3 Macros

I) works only local but not in Acess Point

sub ReloadRep

ActiveDocument.Reload

end sub

||) Dont Work

sub Reload() 
'Macro in Doc A 
Dim WshShell 
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 

end sub 

III)Dont Work

Sub External2

Set WSHShell = CreateObject("Wscript.Shell")

     WSHShell.Run("D:\Test Reload\reload.bat")

  

End Sub  

Any Idea how to achieve goal and reload it on AP with macro?

Regards

Lukasz

7 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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.

Peter

lukas_sokol
Contributor II
Contributor II
Author

Hi,

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.

Colin-Albert

Macros to initiate a reload and the Reload action are not supported on a QlikView server.

You can initiate a reload via an EDX task.

petter
Partner - Champion III
Partner - Champion III

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.

lukas_sokol
Contributor II
Contributor II
Author

Thank's

I'll try to use QMSEDX.exe

I test it by add an action in button

Capture.PNG

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)

Capture2.PNG

petter
Partner - Champion III
Partner - Champion III

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).