Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

souadouert
Contributor III

Macros and planification

i need to know if i have the possiblity to automatically trigger (schedule) qlikview macros from server:

example the macro x will exécute one time per week with date variable



Labels (2)
1 Solution

Accepted Solutions

Re: Macros and planification

It's the same. Here further examples:

Execute Command for QV.EXE without saving.

Re: Reloading more qvw files in Qlik Sense using EXECUTE command

Further it could be useful to to trigger the qvw directly else with a further batch or a windows-task.

- Marcus

11 Replies
YoussefBelloum
Esteemed Contributor

Re: Macros and planification

Hi,

you can't schedule a part of your script from server, but you can do it on the script itself.

example:

beginning of the script..

.

.

.

IF  CONDITION OK THEN

     processing...

ENDIF

the rest of your script


make sure you have done the necessary (a lot of topics on the community tell you what to do exactly)  so that your macros are not blocked by the server

Re: Macros and planification

A qmc-task won't execute any macros. But you could trigger external tasks with an EXECUTE statement. In your case this statement would open the qlikview desktop client which then runs your qv-application and with an OnOpen- or OnPostReload-trigger starts your macro. See here for an example: Re: Run Excel macro via QMC.

- Marcus

souadouert
Contributor III

Re: Macros and planification

i mean qlikview macro Marcus

Re: Macros and planification

It's the same. Here further examples:

Execute Command for QV.EXE without saving.

Re: Reloading more qvw files in Qlik Sense using EXECUTE command

Further it could be useful to to trigger the qvw directly else with a further batch or a windows-task.

- Marcus

YoussefBelloum
Esteemed Contributor

Re: Macros and planification

Hi Marcus,

so it's just impossible to run macros on the server ?

Re: Macros and planification

Yes, within qmc-tasks executed by the qvb.exe it's impossible. I'm not really sure about the reasons - it could be security restrictions or what I think is more likely that the qvb.exe only contained purely the load-engine and no GUI or API ...

- Marcus

YoussefBelloum
Esteemed Contributor

Re: Macros and planification

because on the QMC the is an option to allow macros..

it is a bit confusing

Re: Macros and planification

This meant the server (qvs.exe) and not the publisher-part (qvb.exe) and only if you accessed the server per desktop client or IE plugin.

- Marcus

YoussefBelloum
Esteemed Contributor

Re: Macros and planification

I'm not sure I can follow here..

no matter if we have publisher or not, on the QMC:

image030.jpg

if i have an app running on the server (publisher on not), with that option enabled, on that app we have a Macro, the macro will run or not ?