topic Calling the bat file through Qv in QlikView

Calling the bat file through Qv

svsudhakar — Mon, 30 Dec 2013 09:18:17 GMT

Hi ,

Is it Possible to call the bat file from qvw. if it is possible please let me know the process or provide me an sample app.

Thanks in advance

Regards,

Sudhakar

Re: Calling the bat file through Qv

NareshGuntur — Mon, 30 Dec 2013 09:25:01 GMT

Hi Sudhakar,

Try using the below code.

EXECUTE cmd.exe /c "D:\Project\qv.bat"

Best Regards,

Naresh

Re: Calling the bat file through Qv

Anonymous — Mon, 30 Dec 2013 09:29:31 GMT

Use Triggers,

open external programs ,

in Action tab..

Re: Calling the bat file through Qv

Mon, 30 Dec 2013 09:56:52 GMT

Hi Sudhakar,

You can add following action through either creating a button or through Trigger (as per your requirement)

Action Type -> External : Action ->Open URL

& Set URL of the file path where the .BAT is saved.

make sure that, .BAT file must be given an access to the user who want to access it through QlikView.

-Regards,

Kiran

Re: Calling the bat file through Qv

svsudhakar — Mon, 30 Dec 2013 11:30:06 GMT

Hi ,

Thanks for u r reply ..

its working fine in my local system but when I published in server getting failed to Launch Error.

Please suggest on this..

Re: Calling the bat file through Qv

vikasmahajan — Mon, 30 Dec 2013 11:36:24 GMT

Hello ,

Batch File will not work in Web Browser !!!!

You need to schedule through windows schedular to execute the same.

Vikas

Re: Calling the bat file through Qv

Miguel_Angel_Baeyens — Mon, 30 Dec 2013 11:36:36 GMT

Make sure that in the QMC > System > Setup > QlikView Servers you have checked "Allow Unsafe Macro Execution" on server and in the script dialog editor Settings tab, allow external commands.

Miguel

Re: Calling the bat file through Qv

Mon, 30 Dec 2013 12:00:02 GMT

Hi Sudhakar,

Make sure the path you have specified is correct. Since on server you have to give Server path.

Eg.

If your server Address is 172.16.0.255 & Batch file is saved in E:\QlikView\ProjectName\Batch\Sample.bat

Then you have to write in Open URL = \\172.16.0.255\QlikView\ProjectName\Batch\Sample.bat

& again, this folder should be given access to the user who want to access it through QlikView.

-Regards,

Kiran

Re: Calling the bat file through Qv

svsudhakar — Fri, 03 Jan 2014 08:36:23 GMT

Hi Kiran,

I have modified path as u suggested.but still I am getting the same error.

Failed to launch the application.Please suggest

regards

sudhakar