QTP: An interesting solution

<< Charleston Code Camp | Home | My IDE is broken, and I can't debug up >>

QTP: An interesting solution

So, here I am working on our VBScript communication shell wrapped around QTP for testing (for all of you QTP purists who would scoff at the use of this, read some of my earlier posts about why we use this) and I realize I need a way to handle nested tables. Now, the problem really is this: I have nested tables used to format some pages. Trouble is that deep down in there, there is an image on which I need to click. So, how to get there dynamically? I need code that will search the tables and find the particular thing for which I am looking, be it a string, or an object of some sort.

Well, I have a way on which I am working that seems to be the right track, and it looks something like this:

Set oDesc = Description.Create()
oDesc("html tag").Value = "TABLE"

Set oChild = Browser("Browser").Page("Page").ChildObjects(oDesc)
iTableCount = oChild.Count

Msgbox "We have " & iTableCount &" tables"

For lCount = 0 to iTableCount - 1 'Zero-based
  For lRowCount = 1 to oChild(lCount).RowCount
   'Msgbox "Table " & CStr(lCount) & " has " & oChild(lCount).RowCount & " rows and " & Cstr(oChild(lCount).ColumnCount(lRowCount + 1)) & " columns."
   For lColumnCount = 1 to oChild(lCount).ColumnCount(lRowCount)
    Msgbox "Current Cell: " & lRowCount & "," & lColumnCount
    Msgbox "CellData: " & oChild(lCount).GetCellData(lRowCount , lColumnCount)

   Next

  Next
Next
oChild(0).ChildItem(2,2,"Image",0).Click

Set oChild = Nothing

Set oDesc = Nothing

Note that I've left some of the less interesting stuff out that opens the page, declares variables, etc. This will allow me to grab an array of all of the tables, interate through them, in turn looping thru each column and row. The click line works for my example HTML, but I need to tweak it to use the dynamic stuff above for the determination.

We are using the Descriptive programming to get at our array of tables. Some interesting notes:

1) The tables array is zero-based

2) The rows/columns seem to be collections, and are therefore 1 based

3) The two tables in my example HTML are nested, but both show up in the tables array. I find this interesting, but very useful. Since it works that way, I don't have to loop a table's row/column combination to determine if a particular cell contains a nested table. Allows for a much more dynamic way to get at certain information.

Any thoughts?

posted @ Tuesday, October 11, 2005 8:58 PM

Comments on this entry:

# re: QTP: An interesting solution

Left by Joseph at 11/18/2005 6:08 AM

Hi this is cool and we are working for some thing different that is the
("Browser").Page("Page").ChildObjects(oDesc) code will be in a vbs file bu I am unable to find the object which qtp uses if you guys know kindly mail me raju_ax@yahoo.com

# re: QTP: An interesting solution

Left by Kevin Abel at 1/1/2006 4:47 AM

The worst part of QTP is finding a way to pass variables between actions.

I have 12 years of WR experience. 6 months of QTP. I just finished my last gig on Friday. Do you know of any work in North or South East of the U.S? I am a U.S. citizen and live in NYC and FL. bklabel@aol.com

# re: QTP: An interesting solution

Left by Kazmi at 2/15/2006 2:11 PM

How to get the Browser object with descriptive programming.
Can u help me?

# re: QTP: An interesting solution

Left by Theo Moore at 2/15/2006 2:16 PM

Sure! The Browser object can be accesed using descriptive programming pretty easily, really. The easiest way to do that is to use Object Spy and find a property that uniquely identifies that browser...usually title is a good option. Then, you can refer to the browser like so:
Browser("title:=<insert your browser name")....

You can use a Description object, but I tend to stay away from it most of the time since I usually only need one property to get the object I need.

Hope that helps!

Theo

# re: QTP: An interesting solution

Left by Mettelsome at 3/28/2006 6:29 AM

Hello frienz,
I want to close all the browser in my desktop.following lines

flag=0
while (flag=0)
If (Browser("name:=.*").exist) Then
msgbox "Hello"
Browser("name:=.*").Close
else
flag=5
End If
wend

r working if one browser is open bt when more than one browser is open it won't work.

# re: QTP: An interesting solution

Left by Sourav Nandi at 7/17/2006 10:54 PM

Hello,

The browser have some page links present at the below of WbfUltraGrid table. While I am trying to add the links in Object Reprository, it adds WbfUltraGrid table, not able to identify the links. Also when I record the steps QTP is not able to record the steps to move from one page to another. The environment I am using is .Net Webforms. Can anyone help me out?

# re: QTP: An interesting solution

Left by shivani at 7/24/2006 4:22 PM

I also had to do something similar in the application. I am using an external exe called pskill.exe and calling it in my QTP code.

'Killing IE if any open
Dim WshShell, oExec
Set WshShell = CreateObject("WScript.Shell")
Set oExec = WshShell.Exec("pskill iexplore.exe")

Just sharing but not sure if you want to do it that way.

# re: QTP: An interesting solution

Left by satya at 8/19/2006 9:11 PM

Request for below info when using excel sheet for data: How do i check values in excel sheet and update value in dropdown, if not then select the value from the drop down

Browser("XX").Page("X_1").WebEdit("fieldname:xx", "xxx"),Select (......)

# re: QTP: An interesting solution

Left by Theo Moore at 8/19/2006 9:22 PM

I am not sure I follow what you are doing. Are you intending to import the Excel sheet into the DataTable? Are you intending to use the Excel COM object to get at your sheet? Once you have the Excel sheet available, it should be pretty simple to compare values and set the dropdown values appropriately. If you give me some more info, I might be able to help you about a bit more.

Theo

# re: QTP: An interesting solution

Left by satya at 8/20/2006 5:07 PM

No, already excel sheet is available and trying to use the data from excel sheet

Problem is for a dropdown field:
Pick the data (data updated in the excel sheet from the existing dropdown) from the excel sheet and update the dropdown
else if not available
Pick the data from the dropdown

I request what function i should use or what is the logic i should use

# re: QTP: An interesting solution

Left by Vinod at 8/22/2006 12:20 AM

Hi All,

This is my first mail to this community. My problem is - when i tried to create execute the below lines of code(its from QTP Help) it giving me "Object required: 'WScript'"error. Why it is happening so.

Dim Controller, RemoteScript
Set Controller = WScript.CreateObject("WSHController")
Set RemoteScript = Controller.CreateScript("test.js", "remoteserver")
WScript.ConnectObject RemoteScript, "remote_"
RemoteScript.Execute

# re: QTP: An interesting solution

Left by Theo Moore at 8/22/2006 5:04 AM

I've never tried to use the WSHController object via QTP, although I've used the Shell object successfully many times. It seems to me that we simply can't get to some of the objects under the WSH. My guess is that some of the objects under the WSH can't be instantiated via QTP since you have to have an instance of WScript first. You can instantiate some of the objects via a standard CreateObject statement (like Shell) because those are designed to be accessed without the instantiated WScript. Sorry I can't be more help on that.

T.

# re: QTP: An interesting solution

Left by Shonit at 8/30/2006 11:03 PM

Hi,
I need to find some email from INBOX of hotmail.
I want to know how I will read all my mails from the inbox of hotmail and use it as collection?
I should find mail by his subject.
Thanks,
Shonit

# re: QTP: An interesting solution

Left by Naveen at 8/30/2006 11:06 PM

Hi,

Have any one worked with the telerik controls using QTP. My issue is that, the QTP doesn't identify the telerik object as it is. (eg: Microsoft Share Point). If any one Knows any kind of solution for this, please revert

# Re: QTP: An interesting solution

Left by Chaitanya at 10/17/2006 7:50 AM

Hi,

Till yesterday QTP is working fine, I didn't change any code, now it is not selecting items in tree list and says Object not found
Can any one help us regarding this.
Thanks in advance

# re: QTP: An interesting solution

Left by Fulge at 12/5/2006 9:19 AM

Hi, Im looking information of how to access Microsoft Office with QTP, I need to do things like
1. Open Word
2. Go to File>New
3. Type Something
4. Go to File>Save As
5. Save
6. Close
7. Open file just created
8. Edit
9. Save
10. Print
11. Close word

So i know QTP dosn't recognize the Menu Bar and that inside of the Word, Excel, etc windows, I manage to do the File>New (well I just use a wshShelll command to send Keys, like alt+fn for a New File) but I can't seem to do anythinge else, like I tried to Type something on the excel book and its not doing it unless I record the action, which I dont want to because if they upgrade the Office version I dont know what the names of the new version windows would be, so I wanted to do it all like
Window("text:=.*Book.*").WinObject("name:=Book.*").Type "This is the test text"
but is not working.

Any ideas? is there a better way to do this? I basically have to do those 11 step I mentioned before for Word, PowerPoint and Excel.

Thanks a lot for your time. Any idea is welcome!

# re: QTP: An interesting solution

Left by Theo Moore at 12/5/2006 9:36 AM

Well, is the goal to test something in the office stuff, or is it to merely use it? If you are using the office stuff rather than testing, then how you get info into the app isn't important, right?
In that case, I might use the Office API and write code to handle it rather than interact via the GUI. If you have to use QTP to get at the app, then I wouldn't.

T.

# re: QTP: An interesting solution

Left by Fulge at 12/5/2006 9:47 AM

Well basically I have to test that the Office is working properly, the test case they gave me do this in order to probe that the instalation was correct.

The main objective of this test is to verify that Office, McAffe, WinZip works correctly after each build in the machine. So the information I save or edit or send to print is irrelevant, the action of being able to save, to edit and to print its what I'm tryng to tests here.

# re: QTP: An interesting solution

Left by milind bhatkar at 12/13/2006 3:34 AM

Would you please tell me , how to take print out of test result at run time itself?

That is I want to add some code at the end of test case which will print the test result of that test case, so that there is no need of manually printing the result.

# re: QTP: An interesting solution

Left by Naveen at 1/24/2007 1:28 AM

Can anybody tell me. How can we import data in data table using the descriptive programming in QTP.

# re: QTP: An interesting solution

Left by Pradeep at 2/9/2007 8:12 AM

It works perfectly....

'USING DESCRIPTIVE PROGRAMMING - WITHOUT OBJECT REPOSTARY

Browser("creationtime:=4").Page("title:=Editorial Company Search").Link("text:=Codes").Click

'OR

Browser("name:=Editorial Company Search").Page("title:=Editorial Company Search").Link("text:=Codes").Click

For descriptive programming the object properties should be extracted first using the QTP object repository and then use it in the code.

Ex., name:= or creationtime:= or title:=

Depends on the objects and its available properties

# re: QTP: An interesting solution

Left by Indira at 3/15/2007 1:46 AM

Hi, Im looking information of how to access Microsoft Office with QTP, I need to do things like
1. Open Word
2. Go to File>New
3. Type Something
4. Go to File>Save As
5. Save
6. Close
7. Open file just created
8. Edit
9. Save
10. Print
11. Close word

hey hi,

i tried with those steps given by you.But even am facing the same problem:(

Can anyone help us out for this Query???

# re: QTP: An interesting solution

Left by Indira at 3/15/2007 1:50 AM

Actually , it gives an error like object not found in Repository. And the object is not getting added to it , so only its giving an error.. plz just try with this and send the code or some tips.

Thanks a lot

# re: QTP: An interesting solution

Left by siva at 3/16/2007 4:33 AM

Hi

In my Project I have to compare the data with excel and Oracle apps data weather it is right or wrong

Please provide the Correct script

Please tell me the valuable url

# re: QTP: An interesting solution

Left by Gaurav at 3/23/2007 4:16 AM

My problem is that i have created a macro in MS Excel. Now i have to exceute that macro on the data. But this execution has to be done through QTP.I need to
-open the file
-Run the Macro
-Save the file again.

can anyone please help me in this?Do you have any similar lines of code?

# re: QTP: An interesting solution

Left by manoj at 3/27/2007 6:21 AM

Hi, i am a new user of QTP, can any one tell how to get the browser name and the webpage name of the current active web.

# re: QTP: An interesting solution

Left by Anusha at 4/13/2007 9:25 AM

I need the solution regarding,
How to Access the data in the datatable from the script in QTP

# re: QTP: An interesting solution

Left by rajeev at 4/14/2007 4:32 AM

How to import any excel sheet into data table.

# re: QTP: An interesting solution

Left by diwakar at 4/16/2007 11:15 PM

hi.. can anyone mail me this info

i want to retrieve a value which is stored in excel sheet in some c or d drive in my pc. i need to bring this value in to a variable which i can use while running QTP.

mail me to kvenkata.diwakar@tcs.com

# re: QTP: An interesting solution

Left by rampa at 4/19/2007 1:24 AM

atfer appening qtp 8.2 , i am unable to open internet explorer, and some time blue desktop is apear. atfer endprocess of qtp it will appear my desktop.

O.S : Windows XP Prof. SP2
H/W : PIV , 512 MB RAM

# re: QTP: An interesting solution

Left by Sri at 5/3/2007 9:41 PM

To close all open browsers use this code

SystemUtil.CloseProcessByName "IEXPLORE.EXE"

# re: QTP: An interesting solution

Left by Anil at 5/11/2007 1:09 AM

Hi All,
can we read all the page objects i.e. no of listboxes, checkboxes etc with descriptive programing.

# How to Copy a Text from Web Table and paste it to excel

Left by Jyllana at 5/15/2007 3:18 PM

Hi guys,

Kindly assist me in copying a text from a certain Web Page(located in a certain WebTable) and paste it to excell.

Any reply are highly appreciated.

Thanks a lot

# How to locate a specific file in HTML code and paste file name into QTP datatable

Left by Mercedes at 6/2/2007 5:16 AM

Hi all,
I am trying to run a quicktest that will search within a web page for an .xls file, download, and save the file. When I open a web page there are two image links. If you place the mouse over one link it will give you the name of the file for example "hello.xls" and the other link will say "hi.doc". I want quicktest to be able to find only the ".xls" image link, click, and save it. If that won't work I would like to be able to locate ".xls" within the HTML code of the webpage and copy the entire file name and output it into a new column in the QTP datatable. I would appreciate any input on how I can do this.

Thank you.

# re: QTP: An interesting solution

Left by Dayaz at 6/6/2007 9:39 AM

Theo,
My problem relates to the original thread you had written. I am supposed to automate a test to click on a webelement which is buried inside a table in QTP.

Here is what I tried.

row=Browser(&amp;amp;quot;abc&amp;amp;quot;).Page(&amp;amp;quot;abc&amp;amp;quot;).Frame(&amp;amp;quot;abc&amp;amp;quot;).WebTable(&amp;amp;quot;xyz&amp;amp;quot;).Getrowwithcelltext(&amp;amp;quot;Yacht&amp;amp;quot;)

Set WebElementobj=Browser(&amp;amp;quot;abc&amp;amp;quot;).Page(&amp;amp;quot;abc&amp;amp;quot;).Frame(&amp;amp;quot;abc&amp;amp;quot;).WebTable(&amp;amp;quot;xyz&amp;amp;quot;).Childitem(row,&amp;amp;quot;2&amp;amp;quot;,&amp;amp;quot;WebElement&amp;amp;quot;,&amp;amp;quot;19&amp;amp;quot;)

WebElementobj.Click

First 2 lines succeed.The third line gives me an error &amp;amp;quot;Object required&amp;amp;quot; .

I am not sure how to fix this. Added an object inside OR. That did not work.I am new to QTP and to the whole realm of scripting.

Any help would be appreciated.
Thanks :)

# re: QTP: An interesting solution

Left by Dayaz at 6/6/2007 9:48 AM

No idea what added those amp and quot.

Here is the code one more time.

row=Browser("Abc").Page("xyz).Frame("abc").WebTable("abc").Getrowwithcelltext("Yacht")

Set WebElementobj=Browser("Abc").Page("xyz).Frame("abc").WebTable("abc").Childitem(row,"2","WebElement","19")
WebElementobj.Click

First 2 lines succeed.The third line gives me an error object required.

# Leviathan_(Harsh_Realm)

Left by Dustwallow Marsh at 6/22/2007 2:07 AM

Phase I clone trooper armor Wheel slip Community High School, Teaneck, New Jersey Igmpv3 Palais WÃ¼rttemberg Wall Street (IRT Brooklyn Branch) Asian Rhinoceros Oliver Skeet Richard A. C. E. Erlenmeyer Dustwallow Marsh

# Canada's_landforms

Left by U.S. Croquet Association at 6/23/2007 8:50 PM

SuperFrog Mengistu Lemma South 24 Parganas district William Granet Bradford Township, MN Bilal bin rabah George Mason (architect) Characters in the Contra Series Typhlomys chapensis U.S. Croquet Association

# how to check that items in the datatable are in combobox items

Left by d at 7/31/2007 2:13 AM

plz give the solution

# re: QTP: An interesting solution

Left by saurabh at 8/9/2007 2:24 PM

I have a query on qtp. my application is web based one and it has main menu title, each having sub menus. For entering into ny submenu.. i have to just place the cursor on the main menu and the drop down list is displayed. Now when i record this, it is ok.. but playback time.. it is not running as im not clicking the menu title. Simply moving the cursor there. So QTP is not recognising the object.

Please help me out with this problem.

# re: QTP: An interesting solution

Left by Raja at 8/10/2007 3:55 PM

Hi saurabh,

Do the following ,

Setting.WebPackage("ReplayType") = 2
brow("").Page("").Webelement("Main menu).FireEvent "onmouseover"
brow("").Page("").Webelement("Sub menu").click

Setting.WebPackage("ReplayType") = 1

Above code will set the replay type to mouse and after doing the necessary action, it will set it again default type.

Hope this will work :-)

This will change the replay setting to mouse till

# re: QTP: An interesting solution

Left by Rajesh at 8/20/2007 9:09 AM

Hi guys,

I am Testing a Website, i have some values in webpage (Ex.. Name, DOB, Acct No etc). I have to Automatically Update these values in Excel file... Please help me guys

Please give sample script in QTP or Winrunner

# re: QTP: An interesting solution

Left by Ujwal at 9/11/2007 2:45 PM

Guys,

Here is a simple script that will close all the open browsers.

flag=0
flag1=0
while (flag=0)
If (Browser("index:=flag1").exist) Then
Browser("index:=flag1").Close
flag1 = flag1 + 1
else
flag=-1
End If
wend

cheers,
Scalier ;)