topic Problem with Batch File and Reloading the QVW with Post Reload macro in QlikView

Problem with Batch File and Reloading the QVW with Post Reload macro

Wed, 27 May 2009 20:05:12 GMT

Dear Friends,

In my Qv application ,i am using macro for converting the reports in PDF and i triggered the macro to run after Post reload of the application automatically. When i reload the QV application manually which contains the macro for PDF conversion it's working fine and all the PDF reports are getting stored in the mentioned path but when i run the same QV application using the batch file ,the application is reloading without any issues but the batch file is quitting immediately after the appliation gets reloaded so that the macro process for PDF conversion is not completing so that the PDF reports are not generated and stored in the mentioned path...Is there any command or syntax to make the batch file to wail until the macro for PDF gets over ? Can anybody help me to sort out this problem...?

Regards

Muruganantham S

Qlikview Developer

Problem with Batch File and Reloading the QVW with Post Reload macro

Anonymous — Thu, 28 May 2009 01:08:24 GMT

A possible way:
1. Create a macro that runs on open, and checks a variable (let call it CreatePDF) which it uses as condition. If it is =1, run your PDF macro, and set variable back to 0.
2. In a batch file, use two command lines:
qv.exe /vCreatePDF=0 /r filename.qvw
qv.exe /vCreatePDF= filename.qvw
First line will reload the application and close it. The second line will create the PDFs, no reload.

Problem with Batch File and Reloading the QVW with Post Reload macro

Anonymous — Thu, 28 May 2009 01:16:30 GMT

Another approach is to create a .vbs file that creates an instance of QlikView, loads a document and then runs the vbscript code you want before quitting again. Here's an example on how it could look:

rem ** VBScript **

set test= CreateObject("QlikTech.QlikView")

set newdoc = test.OpenDoc ("C:\ExportCSV.qvw","user","pass")

test.reload

Insert macro code here. Make sure to call any objects using the prefix 'test' since that is the QlikView object.

test.quit

Problem with Batch File and Reloading the QVW with Post Reload macro

Mon, 04 Jan 2010 17:09:00 GMT

I had a very similar problem, where the macro wouldn't run when it was triggerede by post-reload. The document was reloaded, but the macro didn't work and the batch window (cmd) kept open together with the proces qv.exe

I used the suggestion made in the topic's 1. reply with succes.

Problem with Batch File and Reloading the QVW with Post Reload macro

Mon, 04 Jan 2010 17:41:05 GMT

You can try to attach the macro function to a button ( call it BU01 for example).

Then in your vbs. after the reload of your document add the line to press your BU01 button:

Here is an example that will load your document then press the button:

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

Regards,

Sébastien

Problem with Batch File and Reloading the QVW with Post Reload macro

Tue, 02 Feb 2010 10:09:10 GMT

Hi Muruganantham S,

I have same problem with reloading

i have implemented send mail application by using information posted on Qlikview forum

and set module security as system access

Thats why its not working for scheduling through batchfile it gives Fail to open Document

Please share , how you have solve this problem of reloading through batch file , of application which is having system access

eagerly waiting for your reply....

Thank you

Rahul

Problem with Batch File and Reloading the QVW with Post Reload macro

Mon, 12 Apr 2010 15:55:13 GMT

Is possible to execute this script :

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

with "/NoSecurity" option like when you execute by batch ?

(c:\progra~1\qlikview\qv.exe /r /NoSecurity "X:\MyQlikviewfile.qvw")

Problem with Batch File and Reloading the QVW with Post Reload macro

james — Wed, 26 May 2010 18:29:09 GMT

If i try to run ActiveDocument.GetSheetObject("BU01").Press through Windows Task scheduler, it fails and states "Object Required: 'Active Document'

If i run the VBS script myself, it runs fine..

Any ideas

Problem with Batch File and Reloading the QVW with Post Reload macro

boorgura — Wed, 26 May 2010 18:47:39 GMT

The problem should be -

Your batch files reloads the app, saves it and closes it even before the macro is triggered.

Try the option to uncheck the Close on completion for the reload status dialog box.

Problem with Batch File and Reloading the QVW with Post Reload macro

james — Wed, 26 May 2010 18:54:09 GMT

This is my VBS script, and it is not a BAT file

Set MyApp = CreateObject("QlikTech.QlikView")
Set MyDoc = MyApp.OpenDoc ("c:James\.qvw","","")
Set ActiveDocument = MyDoc
ActiveDocument.GetSheetObject("BU1").Press

Set MyDoc = Nothing
MyApp.Quit
Set MyApp = Nothing

Any help is appreciated

AW:Re: Problem with Batch File and Reloading the QVW with Post Reload macro

biester — Thu, 27 May 2010 06:29:54 GMT

James,

in reply to your latest post:

I attached a simple James.qvw with a button (action is a macro which does a reload).

With this external VBS Script

Set MyApp = CreateObject("QlikTech.QlikView")
Set MyDoc = MyApp.OpenDoc ("c:\James.qvw","","")
Set Button = MyDoc.GetSheetObject("BU01")
Ret = Button.Press
MyDoc.Save
Set MyDoc = Nothing
MyApp.Quit
Set MyApp = Nothing

the James.qvw should be reloaded and saved.

Rgds,
Joachim

AW:Re: Problem with Batch File and Reloading the QVW with Post Reload macro

james — Thu, 27 May 2010 14:16:16 GMT

Joachim,

Ret = Button.Press

This isnt triggering the button to be pressed, am I missing somehting?

AW:Re: AW:Re: Problem with Batch File and Reloading the QVW with Post Reload macro

biester — Thu, 27 May 2010 14:26:16 GMT

This IS triggering the button to be pressed (at least it is here with me). Obviously in this context Press is more a property than a method (or at least has to be treated as a property) so you have to assign it to a value. So, "Ret" is the result which the Button.Press returns.

Have you tried it?

Rgds,
Joachim

AW:Re: AW:Re: Problem with Batch File and Reloading the QVW with Post Reload macro

james — Thu, 27 May 2010 16:29:17 GMT

Yes, I have this in a vbs cript called "Daily.vbs"

If i click on the vbs to run, it diesnt press the button (the button triggers a macro that exports an excel file to a loactaion on the server)

Very odd.... I cant think this is that difficult 🙂

Set MyApp = CreateObject("QlikTech.QlikView")
Set MyDoc = MyApp.OpenDoc ("James.qvw","","")
Set Button = MyDoc.GetSheetObject("BU01")
MyDoc.Reload
Ret = Button.Press
MyDoc.Save
Set MyDoc = Nothing
MyApp.Quit
Set MyApp = Nothing

AW:Re: AW:Re: AW:Re: Problem with Batch File and Reloading the QVW with Post Reload macro

biester — Fri, 28 May 2010 07:48:24 GMT

If your VBScript runs without error but just the macro is not executed, then I'd say it can only be a security issue of the module (have you checked "Requested Module Security" and "Current Local Security"?) or the "Security" settings of the "Document Properties" or the user executing the script has no right to write to the server location. Try to set security to the "most unsecure level" and try script again. If it does not execute then, I ain't got no idea any more...It works just fine here with me.

Rgds,
Joachim

Problem with Batch File and Reloading the QVW with Post Reload macro

danielrozental — Tue, 01 Jun 2010 16:59:13 GMT

This is totally a bug.

Check out QV9 SR3 release notes

24192Macro Trigger OnPostReload doesn't work if you have more than one document opened

AW:Re: Problem with Batch File and Reloading the QVW with Post Reload macro

james — Thu, 05 Aug 2010 18:39:08 GMT

Has anyone ever seen and figured out why the VBS Script will run fine, than intermittently error out stating Object Required? Even though the object is there and it ran fine 10 minutes ago; The only fix I have is when I restart my PC it runs