LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: SambaDancer

Hi all,
is it at all possible to execute, through a command line, external programs?
For example, I'm thinking of a VBScript called from within Lavastorm to make my Excel spreadsheets pretty.
Is that possible?
best regards from The Netherlands,
Bart Roeleveld,
Coney.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ejones

There are many options for doing this and it depends on where you want the command to be executed. You could set things up so that the HTTP node causes some command to be executed on a web server. You could set things up so that you can use the Oracle host() to execute an OS command on the Oracle server from . The R node could be set up to execute the system() function on the R server. The Java and Python nodes can execute any library made available to them and Java has the java.lang.Runtime library and Python has the subprocess library.

The Java and Python nodes are not available in all licenses. For example, in the Workgroup License in LAE 4.6 many of these options are not available without adding a license package that enables them. I have not yet seen exactly what the LAE 5.0 Workgroup license provides.

The attached provides an example of the Python node being used. I recommend customizing what it does depending on what you need. Use this at your own risk. Lavastorm does not officially support the use of any these methods of executing OS commands.
Attachments:
ExecuteSystemCommand.7z.zip

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: SambaDancer

Thanks! That sounds really promising!
I will certainly give this a try!
thanks again and greetings from The Netherlands,
Bart Roeleveld (Coney B.V.)