topic Re: How to call a batch file with parameters from qlikview in QlikView

How to call a batch file with parameters from qlikview

Mon, 26 Aug 2013 06:53:45 GMT

Hi All,

I need to call a batch file from qlikview script and also send 5 parameters to batch file. So can anyone send me the script .

I tried below script but didnt work .

Execute cmd.exe /C E:\Qvd to be pushed to Mysql\Textfile.bat 3313 DatamapLoad Deletemetemp;

where 3313 ,DatamapLoad and Deletemetemp are arguements to be passed to batch file .

Re: How to call a batch file with parameters from qlikview

vikasmahajan — Mon, 26 Aug 2013 07:29:06 GMT

Please explain in details what is exact you are looking for ?

Re: How to call a batch file with parameters from qlikview

Mon, 26 Aug 2013 07:37:39 GMT

I need to execute a bat file through Qlikview script. After relaod of the applicatio .bat file needs to execute.

Execute cmd.exe /c "E:\Qvd to be pushed to Mysql\Textfile.bat" works well.No issues uptill now. But when i try to pass the parameters to batch file ,it doesnt work .

When i execute the script through cmd it works fine .

That means issue is with the qlikview. Does QV allow us to pass parameters to batch file in first palce ??

Re: How to call a batch file with parameters from qlikview

vikasmahajan — Mon, 26 Aug 2013 07:50:37 GMT

1. Qlikview Allows us to pass parametes along with batch file

2. You can execute the script through qvw create new qvw2 in script edit

type following commands

EXECUTE cmd.exe /C C:\Export-Email-Automation\TriggerMacro.bat;

EXIT SCRIPT;

moment when you reload qvw2 your batch job will execute .

Hope this you are looking for .

Vikas

Re: How to call a batch file with parameters from qlikview

Andrea_Ghirardello — Mon, 26 Aug 2013 08:00:15 GMT

Hi,

Try the WScript.Shell object.

The following is an example to run a preview report from NPrinting:

The following example shows you how to run a batch file:

Re: How to call a batch file with parameters from qlikview

Mon, 26 Aug 2013 08:48:58 GMT

Hi Vikas,

The script which you sent works well. But now how will i send the parameters to TriggerMacro.bat file ?

Re: How to call a batch file with parameters from qlikview

vikasmahajan — Mon, 26 Aug 2013 08:52:56 GMT

Yes you can pass parameters to macros Following command TriggerMacro is parameter passed.

"C:\Program Files\QlikView\QV.exe" /Vv TriggerMacro=0 "C:\Export-Email-Automation\Dashboard.qvw"

Vikas

Re: How to call a batch file with parameters from qlikview

Mon, 26 Aug 2013 09:02:39 GMT

Sorry for the trouble , but can you give me the example using below script

EXECUTE cmd.exe /C C:\Export-Email-Automation\TriggerMacro.bat;

EXIT SCRIPT;

I tried 1)EXECUTE cmd.exe /C "C:\Export-Email-Automation\TriggerMacro.bat" Parameter1 Parameter2;

2)EXECUTE cmd.exe /C "C:\Export-Email-Automation\TriggerMacro.bat; Parameter1 Parameter2";

Both the above scripts didnt work

i dont understand

"C:\Program Files\QlikView\QV.exe" /Vv TriggerMacro=0 "C:\Export-Email-Automation\Dashboard.qvw"

Can u explain it a bit .

Re: How to call a batch file with parameters from qlikview

Andrea_Ghirardello — Mon, 26 Aug 2013 09:06:56 GMT

Try to use WScript.Arguments...

Dim obj

Set obj = CreateObject("WScript.Shell")

Set oArgs = wscript.Arguments

obj.Run "c:\test.bat " & oArgs(0), , TRUE

Re: How to call a batch file with parameters from qlikview

Mon, 26 Aug 2013 09:42:31 GMT

Andrea its not working ,,,

i tried

copied the below script in VBS file

Dim obj

Set obj = CreateObject("WScript.Shell")

Set oArgs = WScript.Arguments

obj.Run "E:\Qvd to be pushed to Mysql\Textfile.bat " & oArgs(0) & oArgs(1)& oArgs(2), , TRUE

and called the vbs file through button

But sadly not working

Re: How to call a batch file with parameters from qlikview

Andrea_Ghirardello — Mon, 26 Aug 2013 10:40:04 GMT

Try this...

In your qv macro:

Set obj = CreateObject("WScript.Shell")

Arg0 = "first_parameter"

Arg1 = "second_parameter"

obj.Run "C:\test\Test.bat" & Arg0 & " " & Arg1

In your batch use %1 for Arg0 and %2 for Arg2

Re: How to call a batch file with parameters from qlikview

marcus_sommer — Mon, 26 Aug 2013 11:03:48 GMT

Perhaps you tries these indirectly - you could stored the parameter in a text-file and the batch-file read this file before it executed the main-tasks.

- Marcus

Re: How to call a batch file with parameters from qlikview

Mon, 26 Aug 2013 12:05:42 GMT

Thanks Andrea for help and patience .

After inumerable trial and errors below script worked

Sub TestingV

Dim obj

Set obj = CreateObject("WScript.Shell")

obj.Run "E:\Qlikview\Test\textfile.bat "&"locationmaster" &" CramerB" &" 3326", , TRUE

End Sub

Re: How to call a batch file with parameters from qlikview

Wed, 28 Aug 2013 21:08:09 GMT

Hi All,

I am also stuck in similar requirement.

I have chart with link , when users click link , batch file needs to be triggered & pass values from Qlikview. This batch file is basically gonna open another app with the parameters passed from QV.

Format is

'\\server\xyz.bat' -ab <Values from QV> -cd <Values from QV> -de<values from QV>

** -ab , -cd , -de are the parameters name for bat file.

Currently i am trying to use link repsenation of chart & using <url> '\\server\xyz.bat' It works fine without parameter. But as soon as i add parameter , it doesnt execute.

I am not familiar with macro coding. So if you can send me step by step instructions or way to do without macro it will really help!!

Appreciate your response !!

Thanks