Macro Automation on QV Server

[#1]

I have been looking at the following task for our business.

I have setup a macro that saves an image of a sheet from my Qlikview document. I user the folliowing macro:

sub Image
ActiveDocument.Sheets("Dashboard").ExportBitmapToFile "D:\Qlikview.jpg"
ActiveDocument.Save
End Sub

This works fine when the document is manually reloaded but when scheduled to run via Qlikview Publisher, it does not run the macro and the image file is not created.

Any ideas?

[#2]

Hi,

i am using V9 and share the same problem.

I have a macro which exports a chart to a xls with ExportBiff and sends it via Email to specified users in my document.

This is triggered by the ON_POST_RELOAD Event.

When reloading manually or from commandline "Qv.exe /R Mydocument.qvw" or when calling this in the suporting tasks it works.

But its a p.i.t.a to create an extra external task for every Document i want to export and its a big problem to maintain this either.

Isnt there a solution within publisher for this?

[#3]

It's normal, schedule an external reload with qv.exe /R doc.qvw from Publisher or other scheduler, native Pubisher reload doesn't execute on post reload macro by design.
regards

[amien]

cant this be done without publisher?

[#5]

Yes, schedule a reload with your scheduler invoking qv.exe /R yourdoc.qvw, see Reference Manual for additional info, Regards.

[amien]

with scheduler you mean the windows task scheduler?

[#7]

Yes, Windows scheduler or others you like, Regards

[amien]

ok .. too bad .. i was hoping for an qlikview embedded solution