topic Re: Automatically export Chart to .jpeg from web interface in QlikView

Automatically export Chart to .jpeg from web interface

Tue, 19 Jun 2012 07:06:49 GMT

Hi all,

I have a qvw that export jpeg file from chart after reload the document.

It works correctly.

Now I have to complete this job, with task schedulation in the Qw Web Management Console.

I created the task and it runs... on qlik server task manager it appear a qvb.exe process... but nothing happened... jpeg file is not created.

It's a permission problem? I haven't error message to read...

Thank you!!!

Barbara

Re: Automatically export Chart to .jpeg from web interface

Tue, 19 Jun 2012 17:47:33 GMT

Qlikview Publisher will not fire any macro code within a document. To get your OnPostReload trigger to fire, you need to reload the document from the command line with a batch file. The batch file can be scheduled with windows task scheduler. Search for 'command line syntax' in the Qlikview Reference manal (not the server manual) for details on the syntax for reloading from a batch file.

Re: Automatically export Chart to .jpeg from web interface

Wed, 20 Jun 2012 07:57:38 GMT

Thank you very much Tammy,

I supposed that was not possibile to run macros from Publisher.

So I scheduled on win task scheduler this batch file:

Set qlik = CreateObject("QlikTech.QlikView")

Set Doc = qlik.OpenDoc("E:\SMI-QLIK-SRV\QLIK-PUBLISHER\SALES\STATISTICHE VENDITA.qvw")

Set QvDoc = qlik.ActiveDocument

Doc.ReloadEx 2, 1

Doc.Save

Doc.CloseDoc

qlik.Quit

Set qlik = Nothing

It works!

Thank you!

Barbara