# This script executes an external program.
# In this case, this is the equivalent to either:
# * [window key]+[r] and entering "http://google.com"
# * entering the url on an 'explorer' window
#Script Parameters
program = 'explorer'
url = 'http://google.com'
#A. We need the Process class to execute external programs
from System.Diagnostics import Process
#B. Create new process instance
p = Process()
#B.1 Configure your process
p.StartInfo.UseShellExecute = False
p.StartInfo.RedirectStandardOutput = True
p.StartInfo.FileName = program
p.StartInfo.Arguments = url
#C. Start the process and wait
p.Start()
p.WaitForExit()
Unofficial Spotfire Collection of Script Snippets
Customer Banners (Ads) - SpiceUp. AX and SpotfireX Disclaimer
.gif)
10 comments:
I have put one more line at the end of this code:
print "IE has exited."
And i could see that WaitForExit() returns even when IE is not exited. Although this may be because IE has it's own way to live alive after some programs start it.. not sure or WaitForExit() not working.
Hello Pushpendra,
I believe that, in this particular case, IE launches as a thread or different process. Maybe I put a bad example here, but it was meant for illustration purposes but might be useful when dealing with non threaded processes such as 'calc' (calculator).
WaitForExit Instructs the Process component to wait indefinitely for the associated process to exit. You can find a description to all properties and methods here:
https://msdn.microsoft.com/en-us/library/system.diagnostics.process(v=vs.110).aspx
Hi,
Thanks a lot for this interesting post. I have modified your code to open instead a cmd window and create an empty file "blabla.txt" using:
program = "cmd.exe"
url= "/c echo.>blabla.txt"
When I run it on Spotfire, cmd window briefly pops up but the action is not performed. Could you guess why this is not working? Thanks!
Hello daniel,
instead of calling cmd, you can create a file.bat that contains:
echo %1 > %2
on the script:
program='file.bat'
url='. blabla.txt'
but your blabla.txt file will be created where the spotfire is setup, something like:
C:\Users\xxx\AppData\Local\TIBCO\Spotfire\7.6.0\Modules\Spotfire DXP Forms_25.11.10220.7834
so it's better to put the entire path:
url='c:\\temp\blabla.txt'
file.bat can also be as simple as:
%1
on the script:
program = 'c:\\temp\\hello.bat'
args = 'echo.>c:\\temp\\blabla.txt'
Hello Jose,
Thanks a lot. It works now :)
I would like to delete all intermediate txt files produced in an ironpython script at the end f its execution - something like
DEL /Q *.txt
I tried putting this in "program" and "URL" but it complained that it could not find the file (DEL is a built-in DOS command and hence it doesn't exist anywhere in system or system32 folders.
How would I set this up using this bat file approach? thanks
ewalker, just create a yourdelete.bat file say in c:\your\folder\deleter.bat and change:
program="explorer"
to:
program="c:\\your\\folder\\deleter.bat"
thanks,
I created a bat file containing the del command. I didn't use anything for argument and I removed that line. when I run the script, I see the cmd window coming on briefly but the txt files are not removed. If I execute that bat file in a cmd window outside of spotfire, it works
it works for me. My deleter.bat file is:
cd c:\temp\test
del *.txt
sorry I had a space in the file name - had to enclose the full path in double quotes - now it works
Post a Comment