For running a .bat file I have successfully used the EXECUTE command in the script - just place at the start and end. For the external file event I "think" this might be possible using Publisher. Otherwise search in this forum for using EDX and you can use just about any trigger you want.
Hope this helps,
First of all, thanks a lot for your reactivity.
Can you provide me an example of script using (successfully for you) the EXECUTE command ? This is just to save time by avoiding errors wrongly using quotes/brackets/commas….
I did find EDX could be the solution, but I also need to investigate a little bit more to catch the correct way to use this feature.
De : Jason Michaelides email@example.com
Envoyé : lundi 2 avril 2012 12:45
À : TRONEL, Denis
Re: Best practice to run batch program before and after QlikView reload ?
created by Jason Michaelides<http://community.qlik.com/people/jason.michaelides> in Deployment and Management (Server/Publisher/AJAX/IE/Web Parts) - View the full discussion<http://community.qlik.com/message/206490#206490
From the F1 help:
Execute With the execute statement it is possible to run other programs during the re-execution of the QlikView script, e.g. conversions that are necessary. The syntax is: execute commandline where: commandline is a text that can be interpreted by the operating system as a command line. Examples: Execute C:\MSOffice95\Excel\Excel.exe; Execute winword macro.doc; Execute cmd.exe /C C:\BatFiles\Log.bat Note: The /C needs to be included as it is a parameter to cmd.exe.
You also need to ensure you check the "Can Execute External Programs" checkbox in the Settings tab of the script.
Hope this helps,