topic Execute a batch file on the server in QlikView

Execute a batch file on the server

Thu, 08 Jul 2010 10:35:54 GMT

Hi all,

I want to execute a batch file on the server via a macro. I'm not used to create macro so i check the forum in order to find my response and i've found this subjet :

Server Side macro : http://community.qlik.com/forums/t/22605.aspx

When i try to execute the code below

sub launchbatPlain
Set objshell = createobject("Wscript.Shell")
sCmd = Chr(34) & "\\server\folder\mybatch.bat " & Chr(34)
objshell.Run(sCmd), 0, False
end sub

Is there something wrong in this macro ?

Thanks for answer.

Execute a batch file on the server

rwunderlich — Fri, 09 Jul 2010 00:15:04 GMT

I don't think it's possible to execute server-side directly. You'll have to use one of the workarounds discussed in the other thread.

-Rob

Execute a batch file on the server

Fri, 09 Jul 2010 07:04:49 GMT

Just thinking out loud here...

If your batch script is stored on the server - and it has to be "fired" off via a QV app - can you not just load the URL into an Add Action (External) that is triggered OnPostReload in the Document Properties/Triggers ?

The QV can then be scheduled to reload as and when ?