How to use same script for multiple URLs

[QTPScript]

PLEASE SEE ATTACHMENT. I THINK THAT'S THE PROBLEM. PLEASE CONFIRM ONCE PROBLEM SOLVED SO THERE USER CAN USER CAN UNDERSTAND EASILY.

---

Code:

DataTable.Import("C:\nis.xls")

For i =1 to DataTable.GetSheetCount
DataTable.SetCurrentRow i

Print DataTable("Username",dtGlobalSheet)
Print DataTable("password",dtGlobalSheet)

Print"id"& DataTable.Value("Username")
Print DataTable.Value("password")

Next

Above code is working and tested. please see

[mansis]

Hi,

Thanks a lot.. Now the described error is removed.. it was because of while pasting code, it copies wrong ", which is now corrected.

Now new error occurs which is attached.... Please help me with it..

[Sathiya]

Before loop try to get the number of rows and assign that to some variable like "rowcount=DataTable.RowCount"
msgbox rowcount

For i=rowcount
xxxx
yyyy
Next

[mansis]

Hi,

Tried as per your suggestion.. but same error occurs.. pls review attached screen shot..

Thanks,
Mansi.

[Sathiya]

Try with the below one

Code:

sVal=Datatable.GetRowCount
For i = sVal

[mansis]

Hey,, now its fully working, without error

Thank you so much..

But still I have one issue.. Please review below code and attached snap shot of datasheet.. According to me, on running this script, it should first login into first URL and then next one and after that it should be stopped.. But with below code, it first login into with first URL, then next one and "AGAIN login with first URL and second one" which is wrong.. Can you please corrrect me what is wrong in below code??

--------------

Code:

DataTable.Import("D:\Book1.xls")

For i=1 to Datatable.GetRowCount
DataTable.SetCurrentRow i
SystemUtil.Run DataTable("URL",dtGlobalSheet)
Browser("InSync :: Login").Page("InSync :: Login").WebEdit("txtUsername").Set DataTable("Username",dtGlobalSheet)
Browser("InSync :: Login").Page("InSync :: Login").WebEdit("txtPassword").Set DataTable("Password",dtGlobalSheet)
Browser("InSync :: Login").Page("InSync :: Login").WebButton("Login").Click

'Select facility'
'Browser("InSync :: Login").Page("InSync :: Login_2").WebList("ddlFacility").Select ("Local Facility")
Browser("InSync :: Login").Page("InSync :: Login_2").WebButton("Ok").Click

Browser("InSync :: Login").Close
Next

------------

[mansis]

Hi,

Can anyone please help me urgently....

When I run below script, it performs goes into infinite loop.. Consider that in datasheet I have 5 rows in my data sheet, it executing scripting multiple times, though all 5 URL are once opened and described operations are mentioned. It should open each 5 URL one time instead of multiple time.. Please let me know where I am wrong in below script?

---------------

Code:

DataTable.Import("D:\Book1.xls")

For i=1 to Datatable.GetRowCount
DataTable.SetCurrentRow i
SystemUtil.Run DataTable("URL",dtGlobalSheet)
Browser("InSync :: Login").Page("InSync :: Login").WebEdit("txtUsername").Set DataTable("Username",dtGlobalSheet)
Browser("InSync :: Login").Page("InSync :: Login").WebEdit("txtPassword").Set DataTable("Password",dtGlobalSheet)
Browser("InSync :: Login").Page("InSync :: Login").WebButton("Login").Click
Browser("InSync :: Login").Page("InSync :: Login_2").WebList("ddlUsers").Select DataTable("User",dtGlobalSheet)

'Select facility'
Browser("InSync :: Login").Page("InSync :: Login_2").WebButton("Ok").Click
Wait (1)

'Access Scheduler
Browser("InSync :: Login").Page("InSync :: Dash Board").Image("ctl00$Header1$Image2").Click
Wait (1)

'Access Patient Search
Browser("InSync :: Login").Page("InSync :: Dash Board").Image("ctl00$Header1$Image3").Click
Browser("InSync :: Login").Page("InSync :: Patient Search").Image("Edit Patient").Click
Wait (1)

'Access Facesheet
Browser("InSync :: Login").Page("InSync :: Dash Board").Image("ctl00$Header1$Image4").Click
Wait (1)

'Access New Charge
'Browser("InSync :: Login").Page("InSync :: Dash Board").Image("ctl00$Header1$Image5").Click
'Wait (1)

'Access Document Manager
Browser("InSync :: Login").Page("InSync :: Dash Board").Image("ctl00$Header1$ibtndocumnetmgr").Click
Wait (1)

Browser("InSync :: Login").Close
Next

-----------

Thanks,
Mansi.

[mansis]

Help me pleaseeeeeeeeeeee...

[basanth27]

Is the test settings for datatable run on all rows?

[mansis]

Hi Basanth,

Yes Test setting for datatable run on all rows, which was wrong.. Due to which loop enters in infinite... Now it is working fine for me..

Thanks a lot to all of you for your precious help. .. With all of your help, I was able to prepare a complete script for my project..Thanks again..