topic Re: Run Macro on Reload (From Server) in QlikView

Run Macro on Reload (From Server)

Thu, 01 Dec 2011 08:05:28 GMT

Hi Guys,

I have a macro that I need to run during the reload on server.

I tried to put actions on the following document triggers:

OnAnySelect, OnOpen, OnPostReduceData, OnPostReload

None of them works, it only works when I actually open the document and reload it.

Is it possible to run the macro on server scheduled reload? What the macro does is it export one particular table to excel.

Thanks and hope you can help me.

-skip-

rajeshvaswani77 — Wed, 06 May 2015 07:28:05 GMT

Hi,

Did you find a solution to this?

Any solution on this please post here.

Facing a similar issue.

thanks,

Rajesh Vaswani

jonathandienst — Wed, 06 May 2015 07:43:25 GMT

AFAIK, none of these events are fired for a server reload.You have a couple of options that come to mind:

Perform the export from the reload script using a STORE command to a csv file.
Do the reload from a batch file with <program files>qv.exe /r <models>mymodel.qvw. I think this option will fire the trigger.
Move the macro to a VBS script and execute the script using an external task in publisher that is dependent on the reload.

HTH

Jonathan

rajeshvaswani77 — Wed, 06 May 2015 07:50:20 GMT

Thanks Jonathan,

Surprised to know that these events do not fire for reload.

Will try out your suggestions.

regards,

Rajesh Vaswani