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. |