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.