Run Macro on Reload (From Server)

[#1]

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]

Hi,

Did you find a solution to this?

Any solution on this please post here.

Facing a similar issue.

thanks,

Rajesh Vaswani

[jonathandienst]

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]

Thanks Jonathan,

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

Will try out your suggestions.

regards,

Rajesh Vaswani