Running a Batch file through Publisher

[sivarajs]

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

[bnichol]

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

Good luck,

B

[bnichol]

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

Good luck,

B

[#4]

Hi Bill,

I use the same for reload qlikview document through publisher.

[Bill_Britt]

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.

[wardzynski]

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

[vasilev]

Hello Bill,

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

BR

Rumen

[Bill_Britt]

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