Call Toll Free: 1-888-484-3535    

  Automation Anywhere - The Automation Software

Web Data Extraction -> T60 - Web Data Extraction: Extract competitor's price list regularly and stay ahead of competition

Task Description: Extract competitor's price list regularly and stay ahead of the competition.

Note: Let's say you are a LG dealer and you want to regularly check the LCD monitors prices that your competition is providing. In this sample task we are using an example of LG LCD monitors just for illustrative purposes.

Solution
You can extract competitor's price list from their web page using pre-defined automation template. See Solution - A.

Alternatively, you can use Web Recorder feature as well. See Solution - B.

Solution - A

1.Use Extract Table Template Click Tools->Templates and select Internet template category. From right, select "Extract Tabular Data from a Web page" template and follow the wizard. Screenshot 1

Solution - B

1.Record a new task
  • Click on Tools->Web Recorder.
  • Type in the http://www.shopbot.com.au/~lg and click on Start
  • Click on LCD Monitors.
2. Extract the price list and save them to a .csv file
  • Click on the 'Extract Table' button from the bottom right corner toolbar.
  • Click on the pricing table that appears on the LCD Monitors web page.
  • Save the price list to a csv file.
  • Stop the recording and save the task.
  • The task would look as shown in Screenshot 2

Note: You can create multiple similar tasks to get information from multiple competitors.

3.Share the .csv file with your team
  • You can either save the .csv file on a shared folder OR
  • Record or Insert Keystroke/Mouse Click actions at the end of your task that attaches the .csv file to your Email client like Microsoft Outlook or Microsoft Outlook Express and sends email to the team.

When you run the task it generates a .csv file. When you open the .csv file in Excel, it looks like Screenshot 3

4.Schedule the task
  • Select the task in the main Automation Anywhere window and click on Schedule Tab.
  • Specify the schedule options such that your task runs once a week so that you are up-to-date with the competition.
 
When you run this task, it launches the website, extracts the price list, saves them to a csv file and emails the csv file.

Screenshot 1:

Screenshot 2:

Screenshot 3:

 

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

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