+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: How to use Datatable values for automating Weblist in a web page (/Thread-How-to-use-Datatable-values-for-automating-Weblist-in-a-web-page)
How to use Datatable values for automating Weblist in a web page - kkishore12345 - 12-29-2008
Hi team,
Can anyone provide solution on the below mentioned scenario?
In one URL, the pages are like as I mentioned below:
1.First page, click on Create New account
2.second page, click on continue in the Registration process page
3.third page, select Country, Language, Date of birth and continue
4.fourth page, click "Master account"
5.fifth page, "terms and service" will be displayed.
My task is to automate the entire process. In the 3rd step, there is dropdown for countries(several countries are present) for some countries, there is more than 1 language.For example Belgium has English and Deutsch;
I have hardcoded for one country and one language, it is working fine now. But I want to use DataTable which has all the countries,languages and IELangPref as columns, Test script should take values from DataTable.
For example, Australia(Country) is chosen, then English (Language) is chosen and Date of birth should be taken.
I have used Object Spy to find out the property of dropdown, and found to be "Web List"
Please provide your suggestions on how to solve my problem.
Thanks,
Kishore
RE: How to use Datatable values for automating Weblist in a web page - nageshpv - 12-29-2008
Hi,
This can be handled in many ways, but i will explain what i did in this kind of scenario.
First in a datatable, gather all the available countries and their respective languages and then do a loop
Sno Country Language
1 US English
2 India Hindhi
3 India Tamil
etc..
else, dynamically write in to the datatable from the weblist of all country and langauge and then do loop.
Hope, you got my point.
RE: How to use Datatable values for automating Weblist in a web page - sreekanth chilam - 01-01-2009
Hi kkishore12345,
Try with the following procedure:
First of All, Store all required test data in Datatable(Global or Local Sheet) & then In File Menu --> Settings --> Run Tab --> Choose "Run On only One Iteration" Option) :
Code:
rc=Datatable.GetSheet("Global").GetRowCount
For i=1 to rc ' Start of Main Loop
Datatable.GetSheet("Global").SetCurrentRow(i)
Browser("browser").Page("Page1").link("Create New Account").Click
Browser("browser").Page("Page2").link("Continue").click
Expected_DOB=trim(Datatable("DateOfBirth",dtglobalSheet))
Browser("browser").Page("Page3").Weblist("Date Of Birth").Select Expected_DOB
Expected_country=trim(Datatable("countries",dtglobalSheet))
country_Count=Browser("browser").Page("Page3").Weblist("Country").GetROProperty("Items Count")
For j=1 to country_Count
Actual_country=trim(Browser("browser").Page("Page3").Weblist("Country").GetItem(j))
if (Expected_country=Actual_country) then
Browser("browser").Page("Page3").Weblist("Country").Select j
Exit for
end if
Next
Expected_Language=trim(Datatable("IELangPref",dtglobalSheet))
Languages_Count=Browser("browser").Page("Page3").Weblist("Languages").GetROProperty("Items Count")
For k=1 to Languages_Count
Actual_Language=trim(Browser("browser").Page("Page3").Weblist("Languages").GetItem(k))
if (Expected_Language=Actual_Language) then
Browser("browser").Page("Page3").Weblist("Languages").Select k
Exit for
end if
Next
Browser("browser").Page("Page3").link("Continue").click
Browser("browser").Page("Page4").link("Master Account").click
' Navigate Back to Page1
Next ' End of Main Loop