| T61 - Extract people data from Web and transfer it to a database |
| 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.
|
| Solutions |
 |
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.
|
Screenshot 1
|
 |
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.
|
 |
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.
|
|
| 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. |
|
 |
| We started using this product to copy data from legacy system to new system. Now we use it just to do about anything automated. Countless hours saved. Thank you guys. |
- Jack Greenberg
|
| Read Customer Testimonies >> |
|
