Extract data using a variable URL

[Gman23235]

I am evaluating AA to determine if it meets our needs. I have a URL that I must extract agent data from the web page.

For example:
http://agentwebpage.com/Member.asp?pubID=49071

Where the pubID number will represent the agent id number. Currently I have an excel file with all the PubIDs. The tool definitely launches the URL properly, but I am not able to extract data using the web recorder because it requires a specific URL address. The number will be different for each URL based on the agent code. Any idea on how I can do this? It is critical for me to be able purchase the tool.

[philkryder]

Is it possible that you might be able to use the INSERT KEYSTROKES to change the variable portion of the URL?

Perhaps you could load a cell from the XCEL into a variable (or the clipboard)

then use
Alt+D
to select the address bar with the current URL.

Then use
[Right Arrow]
to get to the end of the URL
Then use
[backspace]
to get to the point of insertion
then
type the value that you extracted from XCEL
using the $clipboard$ variable.


Something like that might get you where you want to go...
Phil

[forumsupport]

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.