Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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).