topic Re: How to call a bat files by using jscript in qlikview? in QlikView

How to call a bat files by using jscript in qlikview?

gunji767 — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

I am trying to call bat files using macros with the help of j script. But while trying to run the program exception is happens. Below is the jscript code i have used in macros.

<html>

<head>

<title>Run Exe or Bat files from HTA by Hackoo</title>

<HTA:APPLICATION

APPLICATIONNAME="Run Exe or Bat files from HTA by Hackoo"

ID="MyHTMLapplication"

VERSION="1.0"/>

</head>

<script>

function RunExe(){

var shell = new ActiveXObject("WScript.Shell");

var path = '"D:/run.bat"';

shell.run(path,1,false);

}

</script>

<input style="width: 170px; height:23px; color: white; background-color: #203040;

font-family:Book Antiqua;" type="button" Value="bat" onClick="RunExe();"

</html>

Re: How to call a bat files by using jscript in qlikview?

Anil_Babu_Samineni — Thu, 31 Aug 2017 06:19:29 GMT

May be run it as this?

<script language="JavaScript" type="text/javascript"> MyObject = new ActiveXObject("WScript.Shell") function Runbat() { MyObject.Run("\"C:\\Private\\Anil_ITPL\\Desktop\\welcometest.bat\""); } </script>

Re: How to call a bat files by using jscript in qlikview?

gunji767 — Thu, 31 Aug 2017 06:24:00 GMT

Hi Anil,

I have run this script, but it shoes syntax error like below

Re: How to call a bat files by using jscript in qlikview?

Anil_Babu_Samineni — Thu, 31 Aug 2017 06:27:08 GMT

You can not write Script Tags over Module. May be this?

function Runbat() {

MyObject = new ActiveXObject("WScript.Shell")

{

MyObject.Run("\"C:\\Private\\Anil_ITPL\\Desktop\\welcometest.bat\"");

}

Re: How to call a bat files by using jscript in qlikview?

gunji767 — Thu, 31 Aug 2017 06:31:00 GMT

Dear All,

If possible, to call bat files through VBScript or any another ways please update me.

Regards

Hareesh.

Re: How to call a bat files by using jscript in qlikview?

gunji767 — Thu, 31 Aug 2017 06:39:32 GMT

Dear Anil,

Some exception is happens please have a look.

Regards,

Hareesh.

Re: How to call a bat files by using jscript in qlikview?

PrashantSangle — Thu, 31 Aug 2017 06:45:28 GMT

Hi,

If you want to execute only bat file

then you can use below command.

EXECUTE D:\temp\test.bat;

Regards,

Re: How to call a bat files by using jscript in qlikview?

Anil_Babu_Samineni — Thu, 31 Aug 2017 06:48:14 GMT

For me, This is okay

Re: How to call a bat files by using jscript in qlikview?

gunji767 — Thu, 31 Aug 2017 06:51:42 GMT

Hi Prasanth,

I am run this code by using macros. It is not working properly please have a look.

Regards,

Hareesh.

Re: How to call a bat files by using jscript in qlikview?

gunji767 — Thu, 31 Aug 2017 06:54:53 GMT

Hi,

code is working, but while trying to execute exception is happens like 'Automation server can't create object'

Re: How to call a bat files by using jscript in qlikview?

PrashantSangle — Thu, 31 Aug 2017 06:55:22 GMT

No need to write in macro.

In qlikview script you can use it.

see help menu for how to use EXECUTE..

Regards,

Re: How to call a bat files by using jscript in qlikview?

Anil_Babu_Samineni — Thu, 31 Aug 2017 07:10:11 GMT

Now Question to you

1) Why are you looking / calling thru Macro for that Bat file rather we have direct EXECUTE function.

Re: How to call a bat files by using jscript in qlikview?

gunji767 — Thu, 31 Aug 2017 07:35:06 GMT

I want to run the bat file through button. It should not be on every reload.

Re: How to call a bat files by using jscript in qlikview?

gunji767 — Thu, 31 Aug 2017 07:36:31 GMT

Hi Prasanth,

Thanks for your help, it is working fine at script level. But i want to run the bat file through button. It should not be on every reload.

Re: How to call a bat files by using jscript in qlikview?

Anil_Babu_Samineni — Thu, 31 Aug 2017 07:47:39 GMT

Read this - run batch-file via button