Automation Anywhere Call: 1-888-484-3535   

 
Web Data Extraction
  Home > Product > Solutions > Web Data Extraction > T61  
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.
Automation Anywhere

Next Steps
Buy Now Buy now
Download Free Trial Download free trial
Compare versions Compare versions
Watch a flash demo Watch a flash demo
Contact me Contact me
Ask the Expert Ask the Expert
Request live demo Request live demo

Call 1-888-484-3535

Our Customers
ibounce

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 >>
  Products     Download     Purchase     Services     Support     Customers     Company     Sitemap     Trademark © Tethys Solutions 2008 Privacy Policy
Web Data Extraction (structured) Web Data Extraction Automation Anywhere Free Trial