Macro is not working while refreshing task from QMC

[nagarajupinnibo]

Hi,

I created sample procedure to update value in database.. I need to run macro after every post reload..

I called my macro under document properties->triggers->on post reload. Here, Iam calling run macro with name as "updatestatus'.

And, I selected security options as "system access" and "Allow system access" under current local security.

While doing manual reload, my macro is working fine and value is updated in database.

But, when Iam refreshing task from QMC, reload is working fine but my macro is not working..

In QMC ,under system-> setup, I enabled "Allow macro on server" and "Allow unsafe Macro execution on server" check boxes.

While refreshing task, Macro is not working..

Please provide solution for it..

Thanks

Nagaraju

[jerrysvensson]

A standard Publisher job will not run Macros. See Reference manual.

Workaround is to use "batch" reload instead.

For instance qv.exe /r app.qvw

You can use an external program task to do this.

[Anonymous]

Hi Nagaraju,

Macros won't run on QMC.

To run macros, you need to create a batch file and run the application through it.

You can run batch files thought external tasks on QMC.

Hope this helps.

Thanks

R N

[nagarajupinnibo]

Hi Jerry,

Can u please provide some sample document.. Iam unable to find the answer for it..

[jerrysvensson]

Any app will do.

To reload a QlikView app you can use commandline: c:\program files\qlikview\qv.exe /r  yourapplication.qvw

The path to qv.exe might be another on your installation.