Call Toll Free: 1-888-484-3535    

  Automation Anywhere - The Automation Software

Web Data Extraction -> T66 - Extract restaurant data from a Website

Task Description: Let's say you are in a restaurant business and you want to regularly find out all the restaurant businesses in your area.

Note: This sample task uses an example of http://www.switchboard.com just for illustrative purposes.

Solution
1.Record a new task
  • Click on Tools->Web Recorder.
  • Specify the website http://www.switchboard.com
  • Type in "restaurants" in the Business Name textbox.
  • Specify the location for e.g. San Jose, CA
  • Click on Search button.
  • When the results comes up, click on Next link at the bottom of the page.
  • Stop the recording and save the task.

Please follow the below-mentioned steps to edit the task and extract all the restaurant businesses in San Jose.

2.Extract all restaurant businesses in your area
  • You need to edit the above recorded task in order to extract all the restaurant businesses.
  • Select the task and click on 'Edit' to open it in editor.
  • Find the action where it says click on 'Next' link.
  • Insert a Loop for 10 times around that action.
  • Following are the keystroke actions used to copy the data from Internet Explorer page and paste it into the Excel file.
  1. Copy the entire content of IE page using Ctrl + A and then Ctrl + C.
  2. Paste the content into a notepad window using Ctrl + V.
  3. Remove some of the unwanted text from the top and bottom of the notepad window that gets copied. In order to do that we have used the 'Find' feature of notepad and we look for specific word based on the pattern of this particular website.
  4. After formatting copy the entire text from notepad using Ctrl + A and then Ctrl + C.
  5. Paste it into the Excel window using Ctrl + V.
  • Since the above actions are in a loop, it will keep on clicking on 'Next' link and copy the information to an Excel file.
  • The complete task will look as shown in Screenshot 1
  • At the end of the task you will have an Excel file that will look as shown in Screenshot 2

Note: You can insert the number of times to loop based on the number of your search results.

3.Schedule the task
  • Using the schedule property of Automation Anywhere, you can schedule this task to run once a week. That way you are in tune with the latest information pertaining to your business.
 
When you run this task, it extracts information about all the restaurants in your area.

Screenshot 1:

Screenshot 2:

 

Tags: Web data extraction, web data mining, screen scraping

E-Mail: Enter your email address to receive information about new products & offers from Tethys Solutions.


 PRODUCTS

 Automation Anywhere
   Standard & Premier
   Enterprise
 Workspace Macro Pro
 Workspace Macro
 Launch-n-Go
 Free Downloads
 Compare Products
 

 SOLUTIONS FOR

 Home & Home Office
 Business & IT
 Partners
 Developers
 

 SERVICES

 Ask The Expert
 Consulting Service
 

 PURCHASE

 BUY NOW
 Pricing
 Upgrades
 Our Guarantee

 SUPPORT

 FAQ & Examples
 Have a Question?
 Open A Support Case
 Forums
 

 QUICK LINKS

 Productivity Essentials
 Pre-defined Templates
 

 GENERAL

 Tell A Friend, Win a CD
 Affiliates
 Articles: Macro &
 Automation

 Get RSS Feeds

 Press & News
 Contact Us
Home |Site Map |Privacy Policy |About Us |Contact Us

Copyright © 2003-2008 Tethys Solutions, LLC. All rights reserved. Trademarks