topic Run Macro from Qlikview Management Console in QlikView

Run Macro from Qlikview Management Console

Anonymous — Thu, 29 Aug 2013 17:15:27 GMT

I'm having some problems getting a macro to run from the Management Console. I have a qvd (macro.qvd) that has a macro set to run when the file is opened. Then I have a batch file (trigger.bat) that opens that qvd. I also have a second qvd (execute.qvd) that executes the batch file. In the Management console I have a task that reloads the execute.qvd. When running it does execute the the batch file but doesn't appear to run the Macro. Everything works great if I reload the execute.qvd file manually.

Here is what the files look like.

Execute.qvd:

EXECUTE cmd.exe /C C:\Qlikview\DevDocuments\SourceDocuments\Applications\Manufacturing\Emails\Batch\TriggerMacro.bat;

EXIT SCRIPT;

Trigger.bat:

TITLE RELOAD - EXPORT - MAIL BATCH

ECHO OFF

CLS

ECHO The Dashboard is reloading.

ECHO This may take several minutes to execute and may appear

ECHO to be unresponsive. This is normal.

ECHO Please be patient and do not exit.

"C:\Program Files\QlikView\QV.exe" /NoSecurity /VvSendEmail=1 /VvEmailType=Interior /VvTestEmail=0 "C:\Qlikview\DevDocuments\SourceDocuments\Applications\Manufacturing\KPI- Doors Manf.qvw"

EXIT

Any suggestions why this is not working from the Management Console?

Re: Run Macro from Qlikview Management Console

Miguel_Angel_Baeyens — Thu, 29 Aug 2013 17:29:12 GMT

Hi,

Make sure that you have checked in the QMC, System, Setup, QlikView Server, Security tab, "Allow unsafe macro execution on Server".

Hope that helps.

Miguel

Re: Run Macro from Qlikview Management Console

Thu, 29 Aug 2013 17:32:43 GMT

Macros are not triggered by publisher.

Look through the site for info about it; for example http://community.qlik.com/message/62917

Re: Run Macro from Qlikview Management Console

Anonymous — Thu, 29 Aug 2013 17:52:04 GMT

The "allow unsafe macro" option has already been selected.

Re: Run Macro from Qlikview Management Console

Anonymous — Thu, 29 Aug 2013 17:54:57 GMT

Alessandro,

I'm not trying to get the publisher to run the macro. I want the publisher to reload the qvd (execute.qvd). Then the batch file should open my qvd file and the trigger is set to run the macro when the file is opened.

Re: Run Macro from Qlikview Management Console

Miguel_Angel_Baeyens — Mon, 02 Sep 2013 09:52:42 GMT

Hi Heather,

If you want to run BAT files, try using the Supporting Tasks in the QMC, System, Supporting Tasks, External Program, and the command line.

Make sure you create dependencies in the Triggers between tasks, so all of them are triggered in order.

Hope that helps.

Miguel

Re: Run Macro from Qlikview Management Console

Mon, 02 Sep 2013 11:00:38 GMT

Hi,

Not possible to Run Macro Directly through QMC. You must have to call Windows Tasks using QMC....& with the help of windows task macro will run.