topic Batch file not working. in QlikView

Batch file not working.

ajaykumar1 — Mon, 13 Oct 2014 11:24:36 GMT

Hi All,

I have created the batch file and written some macro in the application.

How we can send the mail and exporting data by using macro with the batch file calling?

When am clicking in the macro for test then everything working fine as per my micro code like sending mail and exporting data.

My Batch file code:

"C:\Program Files\QlikView\Qv.exe" /vvSendSalesMail=1 /NoSecurity "D:\Macros_Test.qvw"

Thanks in advance,

Ajay

Re: Batch file not working.

pandiarajan — Mon, 13 Oct 2014 11:42:17 GMT

Dear ajay,

you can create trigger after reload

Settings - > Document Property -> Triggers -> onpostreload ->addaction-> macroname

macroname -> it will be mail related macro name

Re: Batch file not working.

jonathandienst — Mon, 13 Oct 2014 11:43:08 GMT

I don't think that you can fire a macro in a QVW document directly from the command line. You could use an OnOpen trigger to fire the macro, or move the macro code to an external vbs script that create a Qlikview object, opens the document and performs the required actions. The object model is the same once you have created the object and opened the document.

HTH

Jonathan

Re: Batch file not working.

vikasmahajan — Mon, 13 Oct 2014 12:08:19 GMT

Following command works fine with me

"C:\Program Files\QlikView\qv.exe" /l /noSecurity "D:\Production\Mail Distribution\Indoco_SIM_HOD_WISE_SUMMARY.qvw"

Please try

Vikas

Re: Batch file not working.

ajaykumar1 — Mon, 13 Oct 2014 14:13:29 GMT

Thanks Pandiarajan its working as per current requirement.

Ajay