You are here: Home » All Software Solutions » How to extract web data regularly?

How to extract web data regularly?

Automation Anywhere is an intelligent automation software for IT & business processes.
This month's most popular software guide you should know - How to move photos from my iPhone to my computer

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

Note: Let's say you are a calling card or a phone service provider company and you want to regularly check the international calling rates that your competition is providing. In this sample task we are using an example from Vonage just for illustrative purposes.



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 Import Table Template Click Tools->Templates and select Internet template category. From right, select "Import 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.vonage.com and click on Start
  • Click on International Rates.
2.
Extract the price list and save them to a .csv file.
  • Click on the 'Import Table' button from the bottom right corner toolbar.
  • Click on the pricing table that appears on the International Rates 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 etc. 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 it opens the competition website and extracts the price list and saves them to a csv file and emails the csv file.

Screenshot 1:

Automation Anywhere

Screenshot 2:

Automation Anywhere

Screenshot 3:

Automation Anywhere

Related Software: Automation Anywhere -    

Recommended Essentialware
Windows media player 12
With it, you can play audio, video and viewing images on Windows 7 and have a great experience.
Norton Internet Security 2010
Norton Internet Security 2010 offers comprehensive protection against all types of online threats.
WinRAR 3.9
WinRAR is an powerful archiving utility that completely supports RAR and ZIP archives.

Recommended Mac Software
Senuti for Mac
Use Senuti to quickly and easily transfer music from your iPod or iPhone to your Mac.
VLC Media Player for Mac
VLC for Mac OS X is distributed as a disk image. Download the .dmg file, open it, and copy VLC to your hard drive.
iSquint
iSquint a program for converting videos from the internet to iPod or TV.

by on 22/08/2007Web Developer
Tags:Automation Anywhere, import data from excel to acess, automate complex task, intelligent automation software for it, intelligent software, automation software for business

Tips & Guides Related to How to extract web data regularly?

  • How to use Web Slices in IE 8?

    Guide on how to use Web Slices in IE 8

    by christ on Jul 31, 2009

  • How To Recover Lost Data

    How to recover lost data - An excellent data recovery tool, Spotmau Powersuite 2009 is used to recover lost data from formatted hard disks or partitions.

    by Amber on Mar 10, 2009

  • How To Restore Deleted Data

    How to restore deleted data - Using Data Rescue of Spotmau Powersuite 2009 to restore deleted data or files from emptied Recycle Bin!

    by Amber on Mar 24, 2009

  • How To Restore Lost Data After System Restore

    How to restore lost data after System Restore - Restore data deleted from System Restore, Spotmau Powersuite 2009 can restore lost data or files after a System Restore!

    by Amber on Mar 25, 2009

  • How to extract music from DVD to AAC on BlackBerry

    How to extract music from DVD to AAC on BlackBerry? You can have a try on DVD to BlackBerry Suite, which can help you to extract iPod music from DVD to BlackBerry AAC totally with high quality.

    by clair on May 6, 2009

Top Reviews

on Web Developer

  • Adobe Flash Player - SWF Player
    Adobe Flash Player - SWF Player

    "Cross-platform flash video plug-in for web browsers to deliver users wonderful visual effects."

    by Owen Wilson on Sep 7, 2009

  • Flash Gallery Builder
    Flash Gallery Builder

    "Flash Gallery Builder Reviews & Free Download"

    by Heren Watson on Jan 10, 2008

  • CoffeeCup HTML Editor
    CoffeeCup HTML Editor

    "CoffeeCup HTML Editor Reviews"

    by Dr. File Finder on Jan 29, 2008

  • SiteSpinner
    SiteSpinner

    "SiteSpinner Review & Download"

    by Dr. File Finder on Feb 23, 2008