How to extract web data regularly?
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 |
|
|
2.
|
Extract the price list and save them to a .csv file. |
Note: You can create multiple similar tasks to get information from multiple competitors. |
|
3.
|
Share the .csv file with your 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 |
|
| 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:

Screenshot 2:

Screenshot 3:
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.
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.
Tags:Automation Anywhere, import data from excel to acess, automate complex task, intelligent automation software for it, intelligent software, automation software for business



