topic Running a Batch file through Publisher in QlikView

Running a Batch file through Publisher

sivarajs — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I am trying to run batch file in publisher

I have tried using Supporting tasks in QEMC but its remains in running state

See the attached sample..

Sivaraj S

Running a Batch file through Publisher

Tue, 03 Apr 2012 06:04:28 GMT

hi, Is that bat file is working whn u r running directly.

Running a Batch file through Publisher

sivarajs — Tue, 03 Apr 2012 06:24:37 GMT

yes its working

Running a Batch file through Publisher

Bill_Britt — Tue, 03 Apr 2012 11:54:32 GMT

Can you paste the continue of the Batch file here? Sometimes the reason it continues to run is because publisher can't tell that the task has finished. Like if you use this to open notepad.exe. Publisher can't tell when notepad has closed so it will contiue to run.

Running a Batch file through Publisher

Tue, 03 Apr 2012 13:14:01 GMT

Hi,

I had the very same problem.

I solved it by running the batch file from the the script of a qlikview file, like this:

LET vExeLine = 'BatchFile' ;

execute cmd /c $(vExeLine);

Hope this helps

Running a Batch file through Publisher

sivarajs — Tue, 03 Apr 2012 13:17:41 GMT

Hi Bill,

i have defined my batch file like..

"C:\Program Files\QlikView\Qv.exe" /l "D:\AM_Scheduled_Report\AM_Daily_Mailer.qvw"

sivaraj s

Running a Batch file through Publisher

Bill_Britt — Tue, 03 Apr 2012 14:05:50 GMT

You are running an EXE and publisher can't tell when this has finished. Search the QlikView Server reference manual for Batch mode. This should work better for you.

Running a Batch file through Publisher

sivarajs — Wed, 04 Apr 2012 05:32:43 GMT

Hi YO,

Can u Attach the sample, i am facing some syntax issue

Sivaraj S

Re: Running a Batch file through Publisher

Tue, 24 Jul 2012 05:32:55 GMT

Hi Bill,

Try this

"C:\Program Files\QlikView\qv.exe"/nosecurity /r "filepath\filename.qvw" file will be reloaded

Re: Running a Batch file through Publisher

Bill_Britt — Tue, 24 Jul 2012 11:56:35 GMT

Sampathpleasure1,

Your example is not the same as running a batch reload in publisher.

Bill

Re: Running a Batch file through Publisher

bnichol — Tue, 24 Jul 2012 20:00:23 GMT

Try adding an 'Exit' command in the batch file on the following line. This should explicitly close the command instance.

Good luck,

Re: Running a Batch file through Publisher

bnichol — Tue, 24 Jul 2012 20:00:29 GMT

Try adding an 'Exit' command in the batch file on the following line. This should explicitly close the command instance.

Good luck,

Re: Running a Batch file through Publisher

Thu, 26 Jul 2012 05:03:44 GMT

Hi Bill,

I use the same for reload qlikview document through publisher.

Re: Running a Batch file through Publisher

Bill_Britt — Thu, 26 Jul 2012 12:14:19 GMT

Sampath,

There isn't anything wrong in doing that way. However, it requires you to tie up a User Cal to do this. With the batch mode you are doing the same thing, but using a QVB process and it does cost you a User Cal.

Re: Running a Batch file through Publisher

wardzynski — Wed, 11 Feb 2015 10:12:30 GMT

I have tried this, and it works perfectly when I execute the .QVW file manually, but when I run it in Publisher it will NOT work. I have enabled the setting "can execute external programs". This script is part of my Extract file, where I call the execution of the external script:

LET vExeLine = 'D:\folder\sftp_transfer.bat';

execute cmd /C $(vExeLine);

This is my batch file in 2 steps:

File 1:

winscp.exe /console /script=my_script.txt

exit

File 2:

# start script code

open login:password@domain.com

option transfer binary

get /folder/*.* D:\folder\

exit

# end script

-----

Hi,

I had the very same problem.

I solved it by running the batch file from the the script of a qlikview file, like this:

LET vExeLine = 'BatchFile' ;

execute cmd /c $(vExeLine);

Hope this helps

Re: Running a Batch file through Publisher

vasilev — Fri, 09 Sep 2016 15:38:27 GMT

Hello Bill,

I have the same issue as Sivaraj. What do you mean with "Batch mode"?

Rumen

Re: Running a Batch file through Publisher

Bill_Britt — Fri, 09 Sep 2016 18:06:34 GMT

When a task is executed, QlikView Publisher invokes QlikView Batch (QVB), which is comparable to QlikView Desktop without the user interface.

Look at page 110 of the QlikView server reference manual.

Bill