Hello,
We are not able to launch the URL that you have sent. However, this can be easily done using variable in 'Open Browser' command. What you can do is, first open excel file having list of agent id number. Using 'Get Cells' Excel Command get the id number and store it in some variable say $Prompt-Assignment$. 'Open Browser' web recorder command has variable support so use the same variable, $Prompt-Assignment$ to open webpage for that particular agent id. You can replace PubID number with $Prompt-Assignment$ (insert variable using F2).
You can put the entire process of data extraction in loop to repeat the same process for all the agent ids in excel file. Text format of commands would appear something like this,
1) Excel : Open Spreadsheet "C:\A.xls". Active Sheet: Default
2) Excel : Go to cell "A1"
3) Excel : Get value of Active Cell and assign to variable "Prompt-Assignment"
4) Start Loop "100000" Times
5) Open "http://agentwebpage.com/Member.asp?pubID=$Prompt-Assignment$"
6) Comment: Commands to extract data.
7) Close Browser
8) Excel : Go to one cell below the active cell
9) Excel : Get value of Active Cell and assign to variable "Prompt-Assignment"
10) If $Prompt-Assignment$ Equal To "" Then
11) Exit Loop
12) End If
13) End Loop
For your convenience, we have attached sample task. Please copy it under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder. Copy A.xls under C:\.
Before running this task, please change the excel file name and path having list of agent ids at line #1. Also, in case URL is not correct then please change the URL at line #5. Task will loop for all the agent ids you have in an excel file.
Hope that helps. |