Copy sheet to JPG file in the server.

[ariel_klien]

Hello all Experts,

Today i'm opening Qlikview model through batch file (in task scheduler).

my command is:

start "ss" /MAX /I "C:\Program Files\QlikView\Qv.exe" /l "D:\QV_Production\CopyToJpg.qvw"

(the command also opens the file in a maximize window state)

when the model is opened i'm running a macro to copy the sheet into a JPG image:

Function ExportImageJpg (objID,fileName)
  ActiveDocument.GetSheet(objID).ExportBitmapToFile fileName
end function

Sub CallExample
    'ActiveDocument.getapplication.sleep 10000
     ExportImageJpg "SH08","\\qlikserver\c$\inetpub\wwwroot\test.jpg"
     ActiveDocument.Save
     ActiveDocument.getapplication.quit
end sub

It is working fine.

Now, i have a publisher, and i want to move this to the server side. and not to use batch file.

is it possible?

Ariel

[jagan]

Hi,

Without macro it is not possible to automate, try using this macro in Document Level OnReloadTrigger, when the dashboard completes reloading this trigger is fired and the images is generated.

If it is not working then you have to use batch file.

Regards,

jagan.

[jerrysvensson]

Yes and no.

Publisher will not run macros as a standard reload task.

But you can create an external program task and run your batch from Publisher. Basically the same as Windows Scheduler with the addition that it can be triggered by another task, for instance when your data load is finished.