Getting the Index of Object with 4 processes running

Question

Hello,&nbsp;&nbsp;I am having problems when I open 4 instances of an Excel Application when Testing. The process are as Follows:Process("EXCEL",2)Process("EXCEL",3)Process("EXCEL",4)&nbsp;The Mapped Name stays under Aliases.EXCEL but I am trying to get the Name to Identify the proper Index of the program.For Example I want to assign Process("EXCEL",3) to a Variable I have tried the following code with no results.&nbsp;var excel = Aliases.EXCEL.FullName(Sys.Process("EXCEL").Window("XLMAIN","Microsoft Excel", 3));var excel = Sys.Process("EXCEL").Window("XLMAIN","Microsoft Excel", 3);var excel =&nbsp;Aliases.EXCEL.Name("Process","EXCEL",2);&nbsp;even when I try getting the index it would only get the Index of the first Excel so it would return a value of 1 instead of 3.&nbsp;I have uploaded a screenshot showing excel having 4 processes opened but unable to find any when running the automation test.&nbsp;Can anyone point me in the right direction that allows me to get the proper index for excel or any other program.&nbsp;Thanks in Advance.

ksqian · Accepted Answer

JScript sucks compared to Javascript.&nbsp;Edit : okay okay. There's nothing with Jscript. But we'll need TestComplete to upgrade the compiler for their JScript to match their Javascript implementation.&nbsp;BUT, that's spilled milk and we shall overcome.&nbsp;In jscript, FindAllChildren returns not an array-like-object but some other kind of ... thing (aka multi-dimensional VB array)&nbsp;So:&nbsp;&nbsp;function findProc(name) {
   return Sys.FindAllChildren(["ProcessName"],[name],1).toArray()
}&nbsp;&nbsp;function findExcel(index) {
  var arr = findProc("EXCEL")
  for ( var i = 0 ; i &lt; arr.length ; i++) {
    if (arr[i].Index === index) {
      return arr[i]
    }
  }
}&nbsp;&nbsp;

ksqian · Answer

I am not exactly sure what you need. Are you looking for the third instance and only the third instance?&nbsp;I like to think more generally so I'd probably write something extensible like a process finder.&nbsp;&nbsp;function findProc(caption) {
    for (let i = 0 ; i &lt; Sys.ChildCount ; i++ ) {
        if (~Sys.Child(i).CommandLine.IndexOf(caption)) return Sys.Child(i) 
    }
}This uses commandline to determine process, but you can probably use others.&nbsp;&nbsp;Or you can make it return an array if there are more than 1...&nbsp;&nbsp;function findProc(caption) {
    let arr = [] 
    for (let i = 0 ; i &lt; Sys.ChildCount ; i++ ) {
        if (~Sys.Child(i).CommandLine.IndexOf(caption)) arr.push(Sys.Child(i))
    }
    return arr
}so now you have an arr of processes that matches a certain criteria.&nbsp;&nbsp;Edit : I just checked excel. Looks like its index.&nbsp;So here's a specific piece of code just to find excel 3 that uses findProc array.&nbsp;function excelFinder(index) {
     const excelProcs = findProc("EXCEL") //yay array.
     return excelProcs.filter( function(excel) { return excel.Index === index }) 
}

const excel3 = excelFinder(3)&nbsp;Not sure if this helps your case?&nbsp;&nbsp;

ksqian · Answer

-- Why is my post being removed ? ---&nbsp;&nbsp;Nevermind : Just for you I opened up testcomplete and banged out the actual solution instead of some concept code.&nbsp;Below code is assuming you're running TestComplete 12 with es6 support and using Javascript.&nbsp;Let me know if thats not the case.&nbsp;&nbsp;function findProc(name) {
  return Sys.FindAllChildren(["ProcessName"],[name],1) //Find all processes with a given name. Depth 1 to indicate root processes.
}

function findExcel(index) {
  const arr = Array.from(findProc("EXCEL")) //This turns the FindAllChildren obj into arr.
  Log.Message(Array.isArray(arr)) // Its true :)
  return arr.filter(function(process) { //Now I can safely run filter on it.
    return process.Index === index
  })[0] //I access the first element since filter returns an arr. 
}

function testExcel() {
  const proc = findExcel(1) //Gives us the process!
  Log.Message(proc.FullName) //prints out fullname just to show.
}&nbsp;

don · Answer

Ok so I was able to figure it out with more trial and error.

var excel = Sys.Process("EXCEL", 3);

I got to this solution by studying and trying different things using the Object Explorer. One thing I was confused about is getting the Property Sys.Process since I was using Aliases.Excel i thought I would have to use both together but it looks like you can do it with one or the other.

However, if The process EXCEL does not have more than 3 opened processes it will Fail the test as Object not found. I tried using Sys.WaitProcess("EXCEL",3) but this only gets the first process and not the 3rd.

I will continue to research and update as I find more solutions.

don · Answer

Tried the solution as well as trying to modify it a bit. It crashes my TestComplete. Thanks for the Help :)

ksqian · Answer

HAHA really!?&nbsp;Oh man we need to ask smartbear to add some anti-kudos to these forums so I can give some to myself.&nbsp;I usually write my codes on the forum adhoc without testing so its possible (although it looked so simple). You're welcome to send me your code and Ill take a look.&nbsp;In the meantime, I made a little demo using jsbin. I know its not testcomplete code but its the concept I wanted to demo.&nbsp;&nbsp;http://jsbin.com/godoji/edit?html,js,console,output&nbsp;

Forum Discussion

Getting the Index of Object with 4 processes running

10 Replies

Related Content

Listener events not getting registed when running through maven

recommended upgrade process for SoapUI

Capturing the Command Line of a Process running in the Task Manager

test run takes longer than actual processing

Function to wait for processing to complete

Recent Discussions

Testing Blazor in WPF on Desktop?

Error The Application Frame Host process is not running.

Overwriting Files with aqFile.WriteToTextFile

Object Recognition different during recording on VM

secure channel support error while runnning API code