• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1244
  • Last Modified:

How to use external application with Javascript and WSH

Hi,

  I would like to know how to use an external application like getting field info, cliking on button, menu etc.. with Javascript and WSH unless it can be done with something else that does not require a licensing fee.

Thank you
0
Dogofwars
Asked:
Dogofwars
  • 5
  • 5
1 Solution
 
bpmurrayCommented:
External to what? Do you mean a standalone app? If so, perhaps using HTC/HTA is a good solution, if all you want is a Web UI.  Have a look at http://msdn2.microsoft.com/en-us/library/ms536496.aspx and http://www.microsoft.com/technet/scriptcenter/hubs/htas.mspx.

You could also try SilverLight.

If you don't want too fancy a UI, then WSH is easy to use.
0
 
DogofwarsAuthor Commented:
I don't need a really fancy UI, all I need is a way to get the information I need from few field in an application. By that I need to click on certain button in the application that use a database of client. I do not have access to the database itself but I do have access to the information from the application. Anyhow I have a list of account number and than I need to lookup every account one by one and get the amount of balance of every account. I use javascript, I saw that there is the WSH but I do not find any goot example in doing that other than opening an application and sending key message to the app.
0
 
bpmurrayCommented:
OK, now I understand - you want to automate a local application and retrieve information from the fields, often referred to as UI Automation.

Unfortunately, I'm in a rush right now, so I can't spend any time on this. However, have a look at these examples - they may help direct you to the correct result: http://www.scala.com/advancedscripting/infochannel3/vbjscript.html

0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
DogofwarsAuthor Commented:
Ok I'll wait for your reply
0
 
DogofwarsAuthor Commented:
Anybody to explain how it work
0
 
bpmurrayCommented:
It's really difficult to guess what your app has, but this is something that launches an app (here, calculator), finds its window and brings it to the top, and presses a bunch of keys to emulate playing with your app.
'********* CHANGE THIS STUFF BELOW **********
Const APPLICATION_NAME = "C:\Windows\System32\calc.exe"
Const WINDOW_TITLE = "Calculator"
'********* CHANGE THIS STUFF ABOVE **********
 
' Start the application
Set objShell = CreateObject("WScript.Shell")
objShell.Run APPLICATION_NAME, 1, False
 
' Grab the window, using the window's title
isAppRunning = False
Wscript.Sleep 200 'Make sure it's running
Do While isAppRunning = False
   isAppRunning = objShell.AppActivate(WINDOW_TITLE)
Loop
Wscript.Sleep 200 'Make sure it's pulled to the front.
 
'********* CHANGE THIS STUFF BELOW **********
' Now send keys to the app
objShell.SendKeys "2{+}2{+}2=" ' Should show "6" in the screen
objShell.SendKeys "+{Home}"    ' Highlight the answer (Shift-Home)
objShell.SendKeys "^C"         ' Copy to the clipboard (CTRL-C)
 
' We're finished so quit
Wscript.Sleep 2000 ' Wait so we can see that it's correct
objShell.SendKeys "%{F4}"      ' Exit (Alt-F4)

Open in new window

0
 
DogofwarsAuthor Commented:
IS there a way to get a field like for instance after it has done the calculation can you get the result, it's really important to do so otherwise I cannot probe the database through the interface. Thank you so far.
0
 
bpmurrayCommented:
Unless you give a lot more detail, it's pretty much impossible to guess the correct solution. The code above illustrates how to start the application, input the data into the appropriate fields and cause the correct result to be displayed. Have you managed to make that happen? If so, you can now copy the data from the result field (or fields) into a file, and then read the contents of that file. It's not elegant, but it'll work - the main problem being that WSH doesn't have any clipboard support. Here's a little more detail:

'********* CHANGE THIS STUFF BELOW **********
Const APPLICATION_NAME = "C:\Windows\System32\calc.exe"
Const WINDOW_TITLE = "Calculator"
'********* CHANGE THIS STUFF ABOVE **********
 
Set objShell = CreateObject("WScript.Shell")
 
' Start the application
RunApp APPLICATION_NAME, WINDOW_TITLE
 
'********* CHANGE THIS STUFF BELOW **********
' Now send keys to the app
objShell.SendKeys "2{+}2{+}2=" ' Should show "6" in the screen
objShell.SendKeys "+{Home}"    ' Highlight the answer (Shift-Home)
objShell.SendKeys "^C"         ' Copy to the clipboard (CTRL-C)
 
' We're finished so quit
objShell.SendKeys "%{F4}"      ' Exit (Alt-F4)
 
' Now start Notepad to copy the data to a file
RunApp "notepad.exe", "Notepad"
objShell.SendKeys "^V"         ' Paste the content
objShell.SendKeys "%FAC:\work.txt" ' File/Save As/filename
objShell.SendKeys "%S"         ' Save
objShell.SendKeys "%{F4}"      ' Exit (Alt-F4)
 
' Read the data from the file
Const OpenFileForReading = 1
Set fso = CreateObject("Scripting.FileSystemObject")
Set textStream = fso.OpenTextFile("c:\work.txt", OpenFileForReading, True)
MyResults = textStream.ReadAll
textStream.Close
FSO.DeleteFile("c:\test.txt")
 
 
MsgBox MyResults,0,"Results field contents"
 
' Launch the application & bring it to the foreground
Sub RunApp(ApplicationName, Title)
   objShell.Run ApplicationName, 1, False
   isAppRunning = False
   Wscript.Sleep 200 'Make sure it's running
   Do While isAppRunning = False
      isAppRunning = objShell.AppActivate(Title)
   Loop
   Wscript.Sleep 200 'Make sure it's pulled to the front.
End Sub

Open in new window

0
 
DogofwarsAuthor Commented:
I guess you have no way to specify a field directly than!?
0
 
bpmurrayCommented:
Not by name, but you can use a number of mechanisms to drill down to the field: number of tabs, accelerator key, etc. If you know the application, you can simply track (exactly) what it takes to do this manually and then transpose that to the automation in your script.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now