topic qv.exe /R sometimes runs OnPostReload macro, sometimes doesn't? in QlikView

qv.exe /R sometimes runs OnPostReload macro, sometimes doesn't?

Wed, 11 Nov 2009 03:23:10 GMT

Has this issue happened to anyone else? I have a QVW that run a OnPostReload() and when reloaded via qv.exe /R it doesn't always run. When reloaded "manually" it works perfect. Anyone have any suggestions?

qv.exe /R sometimes runs OnPostReload macro, sometimes doesn't?

Tue, 24 Nov 2009 12:22:01 GMT

so anyone know why this can be happening?

qv.exe /R sometimes runs OnPostReload macro, sometimes doesn't?

Tue, 24 Nov 2009 16:39:13 GMT

I never trust the trigger as I have experienced the same problem. I use one of two methods:

1) After the reload with a /R I then invoke the document again passing a variable with a specific value using the /V switch. I have a macro that runs as the OnOpen trigger and if the variable value is as per the passed value, it runs some code. I wrap these 2 lines in a .bat file.

CALL "C:\PROGRAM FILES\QLIKVIEW\QV.EXE" /R "E:\QVApplications\QVCustomers\CUSTOMER SEGMENTATION.QVW"
CALL "C:\PROGRAM FILES\QLIKVIEW\QV.EXE" /VvExport=1 "E:\QVApplications\QVCustomers\CUSTOMER SEGMENTATION.QVW"

2) Create an alert that runs On Post Reload in batch mode to send an email if something unusual was detected in the load script (such as a file not found)

Hope this helps,

Gordon

qv.exe /R sometimes runs OnPostReload macro, sometimes doesn't?

Tue, 24 Nov 2009 16:42:42 GMT

regards solution 1) the macro is like this:

sub ExportData

set doc=ActiveDocument

vExport = doc.Variables("vExport").GetContent.String

if vExport = "1" then

......

doc.GetApplication.Quit

end if

end sub

qv.exe /R sometimes runs OnPostReload macro, sometimes doesn't?

Tue, 24 Nov 2009 16:58:18 GMT

What I do is assigning the macro to a button (call it BU01 for example).

Then create the following vbs code:

Set MyApp = CreateObject("QlikTech.QlikView")
Set MyDoc = MyApp.OpenDoc ("C:\test\toto.qvw","","")
Set ActiveDocument = MyDoc
ActiveDocument.Reload
ActiveDocument.GetSheetObject("BU01").Press

Set MyDoc = Nothing
MyApp.Quit
Set MyApp = Nothing

This will open the document then reload then run the macro.

Then the document is closed.

In Publisher you can then create an external command task.

Rgds,

Sébastien

qv.exe /R sometimes runs OnPostReload macro, sometimes doesn't?

Wed, 25 Nov 2009 02:38:57 GMT

thanks spastor, it works perfectly.

qv.exe /R sometimes runs OnPostReload macro, sometimes doesn't?

Thu, 26 Nov 2009 02:47:41 GMT

Sébastien,

Your code is working great but OpenDoc() is using the QV window that is currently opened. Is there a way to instantiate a new QV window? Thanks.

qv.exe /R sometimes runs OnPostReload macro, sometimes doesn't?

Mon, 23 Apr 2012 18:22:56 GMT

problem : can't set macro to allow system access from RELOAD (option /r not work)

Ref : http://community.qlik.com/message/18973

Ref : http://community.qlik.com/message/21833

Ref : http://community.qlik.com/message/165717

1.Create Batch file ==> "C:\Program Files\QlikView\qv.exe" /l "path_to_document"

2.Create Task Scheduler to RUN Batch file (1)

3.QVW Document ==> Document properties > OnPostReload ==> Add RUN MACRO

4.add (end of script)

ActiveDocument.Save

Application.Quit

don't forget

1. User Preference >Security > select "Module..." and "File.."

2. Document Properties > Security > Macro Override Security

Re: qv.exe /R sometimes runs OnPostReload macro, sometimes doesn't?

tdupasqu — Fri, 17 Aug 2012 07:41:36 GMT

Thanks for this useful summary! Switching from qv.exe /r to /l fixed it for me.