topic Re: macro execution does not work after reloading through scheduler in QV 11 in QlikView

macro execution does not work after reloading through scheduler in QV 11

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I have written a macro to create pdf after reloading is done.

This works fine if the report is reloaded through QV Desktop.

but when the same report is reloaded through QV server using scheduler, reloading works fine but pdf does not get generated.

This is the macro I have written in Edit module and have triggered it on PostReload.

sub PrintReport

ActiveDocument.GetApplication.Sleep 2000

ActiveDocument.PrintReport "RP01", "PDF-Xchange 4.0", false ' This line of code pops up save as dlg

ActiveDocument.GetApplication.Sleep 10000

end sub

macro execution does not work after reloading through scheduler in QV 11

jerrysvensson — Wed, 11 Apr 2012 11:40:57 GMT

Macros doesn't work in Publisher.

You need to run it as a Supporting task / External program.

macro execution does not work after reloading through scheduler in QV 11

Wed, 11 Apr 2012 11:45:31 GMT

How to create supporting task /External Program?

How to call it after reloading?

I have QV 11 and No Publisher.

Please reply fast as I need to complete this today.

macro execution does not work after reloading through scheduler in QV 11

magavi_framsteg — Wed, 11 Apr 2012 14:44:04 GMT

External Tasks is only avaiable when using Publisher.

Instead, schedule a .cmd/.bat-file which executes qv.exe /r <path\filename.qvw>.

Only qv.exe will trigger OnPostReload-events, NOT Publisher.

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

macro execution does not work after reloading through scheduler in QV 11

Thu, 12 Apr 2012 04:04:25 GMT

Hi Magnus,

How to schedule .bat file? using QV scheduler?

if yes how and if no then also how?

macro execution does not work after reloading through scheduler in QV 11

Thu, 12 Apr 2012 04:48:17 GMT

Hi Magnus,

I did try to create the .bat file but when executing the macro, it gets hung.

If I disable the postreload trigger the .bat file works fine.

what can be the reason?

macro execution does not work after reloading through scheduler in QV 11

magavi_framsteg — Thu, 12 Apr 2012 08:08:53 GMT

Hi again.

What happens if you logon to the server on which qlikview publisher runs with the same user that runs the publisher service.

And then open your document with qv.exe (standard QlikView) and do a manual reload?

Does that work?

ActiveDocument.PrintReport "RP01", "PDF-Xchange 4.0", false ' This line of code pops up save as dlg

The macro cannot answer YES on the prompt for "save as", so you could try and delete the PDF first if it already exists, and then print the new PDF.

Hope this helps.

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

macro execution does not work after reloading through scheduler in QV 11

Thu, 12 Apr 2012 08:38:32 GMT

Hi Magnus,

I do not have Qlikview Publisher.

But when I run the report manually, It will create the PDF.

I have bypassed the saveas dialog. So it will not ask for path and filename. It will drectly create the PDF.

When I reload the report through QV server, it reloads the report but do not create the pdf.

I also did try by deleting the old pdf and reloaded through QV server. But stlll no PDF.

So I am asking how to schedule the .bat file and why does it hung it when macro is included.

macro execution does not work after reloading through scheduler in QV 11

magavi_framsteg — Fri, 13 Apr 2012 07:13:25 GMT

Hi Apu.

OK.

- When you do it manually;

Do you reload it using the same user which runs the "QlikView Server" service?

Log on to Windows using that user OR run qv.exe as that user.

- When QlikView Server does the reload;

Does it execute the rest of the macro code?

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Re: macro execution does not work after reloading through scheduler in QV 11

Thu, 14 Jun 2012 05:39:22 GMT

Hello All,

I used windows batch file to create the PDF and its working fine now.

Thanks for everyone's help.

Re: macro execution does not work after reloading through scheduler in QV 11

Fri, 15 Mar 2013 19:50:54 GMT

Hi Apu,

I also try to export sheet imageafter reloading. Will you please send me your batch file which worked for you?

Thanks

Re: macro execution does not work after reloading through scheduler in QV 11

Mon, 18 Mar 2013 05:25:07 GMT

Hi,

follow the below steps to create a batch file:

1. open notepad.

2. write statement as - "C:\Program Files\QlikView\Qv.exe" "E:\Documents\Sales.qvw"

1st parameter is the location of the qlikview software and

2nd parameter is the location of qvw file.

3. save the file with the name as test.bat

4. close the file.

To test

1. double click the batch file.

This will open the qvw file.

Hope this helps you.

Re: macro execution does not work after reloading through scheduler in QV 11

Anonymous — Mon, 04 Nov 2013 10:21:52 GMT

Hello I have a similar problem maybe smb can answer this thread

http://community.qlik.com/thread/97887

Thx

chesterluck