How to use same script for multiple URLs

[mansis]

Hi,

Imported file with .xls file, still same syntax error occurs. Please review below updated script and see error screen shot from my previous post. Please do needful.

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

Code:

Datatable.Import"D:\Datasheet\book1.xls" For i=1 to DataTable.RowCount SystemUtil.run DataTable(“URL”,dtGlobalSheet) Browser(“InSync :: Login”).Page(“InSync :: Login”).Webedit().Set DataTable(“Username”,dtGlobalSheet) Browser(“InSync :: Login”).Page(“InSync :: Login”).Webedit().Set DataTable(“Password”,dtGlobalSheet) Browser("InSync :: Login").Page("InSync :: Login").WebButton("Login").Click 'Select facility' Browser("InSync :: Login").Page("InSync :: Login_2").WebButton("Ok").Click 'Open Scheduler page' Browser("InSync :: Login").Page("InSync :: Dash Board").Image("ctl00$Header1$Image2").Click Wait (3) 'Access Patient Search page' Browser("InSync :: Login").Page("InSync :: Dash Board_2").Image("ctl00$Header1$Image3").Click Browser("InSync :: Login").Page("InSync :: Patient Search").Image("Edit Patient").Click Wait (3) ''Access Facesheet' Browser("InSync :: Login").Page("InSync :: Patient Search").Image("ctl00$Header1$Image4").Click Wait (3) 'Access New charge page' Browser("InSync :: Login").Page("InSync :: Dash Board_2").Image("ctl00$Header1$Image5").Click 'Access Document Manager' Browser("InSync :: Login").Page("InSync :: Dash Board_2").Image("ctl00$Header1$ibtndocumnetmgr").Click Wait (3) Browser("InSync :: Login").Close Next

-----

Thanks,
Mansi.

[sshukla12]

Hi,
I used the below code and it works fine for me:

Code:

DataTable.Import("D:\Book1.xls") DataTable.SetCurrentRow 1 SystemUtil.Run DataTable("URL",dtGlobalSheet)

Just make sure u passed the URL of application in datasheet

Regards,
Sankalp

[mansis]

Hi Sankalp,

Thanks for helping me in solving described error. But now new error occurs (refer attachment). Please review below script-

-----------

Code:

DataTable.Import("D:\Book1.xls") DataTable.SetCurrentRow 1 For i=1 to DataTable.RowCount 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

----

Thanks
Mansi.

[sshukla12]

Hi,
Have u put the datasheet at D drive?

Regards,
Sankalp

[mansis]

Hi,

Yes, It is in D drive and it is fetching URL correctly.. But error occurs for username and password.. Please review my script and error screen from previous post..

[mansis]

Hi,

Please help me urgently on mentioned issue.

Thanks,
Mansi.

[sshukla12]

Hi,
Could you please provide the datasheet snapshot?

Regards,
Sankalp

[mansis]

Hi,

Please review attached datasheet snapshot..

Thanks,
Mansi.

---

Help me plssss.........

Thanks,
Mansi.

[sshukla12]

Hi,
Try to use below code

Code:

DataTable.Import("D:\Book1.xls") For i=1 to DataTable.RowCount [color=#FF0000]DataTable.SetCurrentRow i[/color] 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

Regards,
Sankalp

[mansis]

Hi,

Not working.. again same error occurs.. Now I am hopeless. can you help me by using goto meeting??

Thanks,
Mansi.