How do I create an user login workflow in a particular website. Steps given below.
drag in the “workbook>read cell” element from the search bar in the activity panel
give in the username and password in the spreedsheet{after creating .xls file} which is created anywhere in the system
give in the path of this spreedsheet in the “>workbook_read cell” along with its location in the sheet1 (for example “A3” or “B2”)
above step ensures that the elements in the given locations are retrieved
open browser
give in user credentials (username and password)
click on login
WELL ABOVE THINGS CAN BE DONE EASILY SO MY QUESTION IS HEREAFTER
-I need to make more than one combinations of usernames and passwords in the given sheet1. (such as if A2 is not the correct password check is the next one ie: A3)
At the same time, keep track of the number of attempts needed to ensure that the given combination (of username and password is correct and login is done. )
Finally after the login attempt is correct display the “message box” saying that which all attepmts were made and which {2nd or 3rd or 1st or …} attempt was correct.
I hope i made my question clear enough. Please make sure you understand my question. If need some clarification, kindly let me know about it.
@dumb
One more way could be as you have data in the excel sheet probably
username password as column names
and several rows for the correct and incorrect combinations of password and username
quick way could be
read the excel sheet using read range activity store it in a datatable
Add a column “status” in datatable
for each datatable activity will allow to iterate through the datatable
When the login is success add status success or if incorrect credentails log status - failure.
Finally either copy the whole datatable to excel sheet or just read the status column
Condition “isError” need to have “Expression as Object” as Boolean to return. Please let me know, what Expression need to write for browser login success or failure.
Thank you for reply. This “Element exists” activity is always returning true and not able to proceed.
I have tried with “Get Attribute”, “Find Element” & “Get Text”. Only “Get Text” activity worked for me after trimming the get text to compare whether that specific attribute exists in the variable or not.
If condition as “getText.Trim.Equals(“Dashboard”)” to make it work as “Get Text” variable having lot of spaces at the end and line break also.