Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

Not applicable

Can't run .bat file with QMC > Supporting Tasks > External Program

Hi,

I'm trying to automate table to csv -export on reload. I've figured out that QMC automation doesn't handle the document events properly, and I need to do this from the command line, eg. Qv.exe /R xxx.qvw.

For some reason though, I can't get the Supporting Tasks > External Program task to work properly.

At the moment I have a simple .bat:

REM ... my real load ....

ECHO "Test"

EXIT

I have configured the external task with this parameter:

Command line statement: cmd "c:\reload.bat"

When I start the task, it just gets stuck on "Running" status, and never completing.

What should I set as the "command line statement" parameter?

1 Solution

Accepted Solutions

Re: Can't run .bat file with QMC > Supporting Tasks > External Program

If you change the name into reload.cmd, you can just enter the following into Command line statement:

  C:\Reload.cmd

The shell will be started automatically.

This works for us. The only thing we have to take care of are spaces in path names. In that case, put the path between double quotes.

Peter

2 Replies
danielrozental
Honored Contributor II

Re: Can't run .bat file with QMC > Supporting Tasks > External Program

I believe you should use cmd.exe /C so the command line interface will close after performing the requested command.

Re: Can't run .bat file with QMC > Supporting Tasks > External Program

If you change the name into reload.cmd, you can just enter the following into Command line statement:

  C:\Reload.cmd

The shell will be started automatically.

This works for us. The only thing we have to take care of are spaces in path names. In that case, put the path between double quotes.

Peter

Community Browser