Forum Discussion

Don's avatar
Don
Contributor
8 years ago

Getting the Index of Object with 4 processes running

Hello,    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)   The Mapped N...
  • KSQian's avatar
    KSQian
    8 years ago

    JScript sucks compared to Javascript. 

    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.

     

    BUT, that's spilled milk and we shall overcome.

     

    In jscript, FindAllChildren returns not an array-like-object but some other kind of ... thing (aka multi-dimensional VB array)

     

    So:

     

     

    function findProc(name) {
   return Sys.FindAllChildren(["ProcessName"],[name],1).toArray()
}

     

     

    function findExcel(index) {
  var arr = findProc("EXCEL")
  for ( var i = 0 ; i < arr.length ; i++) {
    if (arr[i].Index === index) {
      return arr[i]
    }
  }
}

     

     

Don's avatar
Don
Contributor

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.

 

 

 

KSQian's avatar
KSQian
Contributor
8 years ago

I am not exactly sure what you need. Are you looking for the third instance and only the third instance?

 

I like to think more generally so I'd probably write something extensible like a process finder. 

 

function findProc(caption) {
    for (let i = 0 ; i < 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. 

 

Or you can make it return an array if there are more than 1... 

 

function findProc(caption) {
    let arr = [] 
    for (let i = 0 ; i < 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. 

 

Edit : I just checked excel. Looks like its index.

 

So here's a specific piece of code just to find excel 3 that uses findProc array.

 

function excelFinder(index) {
     const excelProcs = findProc("EXCEL") //yay array.
     return excelProcs.filter( function(excel) { return excel.Index === index }) 
}

const excel3 = excelFinder(3)

 

Not sure if this helps your case?

 

 

  • Don's avatar
    Don
    Contributor
    8 years ago

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

    • KSQian's avatar
      KSQian
      Contributor
      8 years ago

      -- Why is my post being removed ? --- 

       

      Nevermind : Just for you I opened up testcomplete and banged out the actual solution instead of some concept code.

       

      Below code is assuming you're running TestComplete 12 with es6 support and using Javascript.

       

      Let me know if thats not the case. 

       

      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.
}

       

      • Don's avatar
        Don
        Contributor
        8 years ago

        So the code works to an extent. I'm using JSCript which is practically Javascript but for some reason it's not allowing me to use Filters and returns an error Message.

         

        I've uploaded a screenshot of what works but the process in the array returns all array's as Undefined. It also crashes around the point of Array.isArray(arr);

         

        I have to removed the isArray clause but then it doesn't log anything.

         

        Not sure what I can do about the arr.filter since it keeps crashing and I don't know what to replace it with. 

         

         

    • KSQian's avatar
      KSQian
      Contributor
      8 years ago

      HAHA really!?

       

      Oh man we need to ask smartbear to add some anti-kudos to these forums so I can give some to myself.

       

      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.

       

      In the meantime, I made a little demo using jsbin. I know its not testcomplete code but its the concept I wanted to demo. 

       

      http://jsbin.com/godoji/edit?html,js,console,output

       

      • KSQian's avatar
        KSQian
        Contributor
        8 years ago

        Nevermind : Just for you I opened up testcomplete and banged out the actual solution instead of some concept code.

         

        Below code is assuming you're running TestComplete 12 with es6 support and using Javascript.

         

        Let me know if thats not the case. 

         

        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.
}