Task Description:
Extract people data from web and transfer it to a database.
Note: This sample task uses an example of searching people by last name and city on Yahoo and putting their name and
address information in the database.
| Solution |
| 1. | Record a new task |
- Click on Tools->Web Recorder.
- Type in the http://people.yahoo.com/ and click on Start
- Specify last name, City and Click on Search button.
|
| 2. | Extract the addresses and phone numbers |
- Click on the 'Extract Table' button from the bottom right corner toolbar.
- Click on the search results table that lists the people who met the search criteria.
- Save the search results to a csv file.
- Click Next to fetch the next set of results.
- Again extract the table of search results. Repeat this step as per your requirement.
- Stop the recording and save the task.
|
| 3. | Save the addresses and phone numbers in the database |
- After every Extract Table command is executed, you can use System Variable command, $Table Column(index)$ to extract the row data of the Table.
- Insert Database commands to connect and insert the Tabular data extracted from the web into the database.
- The task would look as shown in Screenshot 1
|
| |
| When you run this task, it searches people by last name and city and
extracts their addresses and phone numbers and saves them to a .csv file and inserts them into your database. |
Customer Testimony
"Wow! This program is fantastic. I was
given the task to figure out how to get a list of over 1000 contacts off of a
website and into Excel. I was trying to write some kind of macro for days
through Excel's VB extension and was making no progress. So I went online and
found Automation Anywhere, it took me only minutes to write a macro to copy the
addresses. I owe Tethys Solutions hours of my life that I was prepared to spend
copying and pasting. Thank you so much Tethys"- Ben Kinney, Monterey media
Read more Customer Testimonies |
Screenshot 1: 
|
Automation Anywhere - The Automation Software