topic Re: Reload documents on Server in QlikView

Reload documents on Server

lukas_sokol — Thu, 18 Feb 2016 22:14:29 GMT

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

Re: Reload documents on Server

Peter_Cammaert — Thu, 18 Feb 2016 22:27:00 GMT

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

Re: Reload documents on Server

lukas_sokol — Fri, 19 Feb 2016 13:37:29 GMT

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.

Re: Reload documents on Server

Colin-Albert — Fri, 19 Feb 2016 13:43:36 GMT

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.

Re: Reload documents on Server

Colin-Albert — Fri, 19 Feb 2016 14:26:51 GMT

Try this Using EDX in QlikView 11 - basic example

Re: Reload documents on Server

petter — Fri, 19 Feb 2016 14:27:46 GMT

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.

Re: Reload documents on Server

lukas_sokol — Fri, 19 Feb 2016 15:08:48 GMT

Thank's

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)

Re: Reload documents on Server

petter — Fri, 19 Feb 2016 17:49:33 GMT

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