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://local.yahoo.com/ just for illustrative purposes.
T66.atmn
Note: Save the .atmn file in My Documents -> Automation Anywhere -> Automation Anywhere -> My Tasks
|
| Solution |
 |
Record a new task
- Click on Web Record link.
- Specify the website http://local.yahoo.com/ and click on Start button.
- Type in "Restaurants" in the ‘Find Business Name’ textbox.
- Specify the location for e.g. San Diego, CA
- Click on ‘Search Local’ button.
|

Screenshot 1

Screenshot 2

Screenshot 3

Screenshot 4

Screenshot 5
|
 |
Extract all restaurant businesses in your area using 'Extract Multiple Data' wizard
- When the resulting webpage is loaded, click on 'Extract Data' button in the Web Recorder toolbar.
- From Extract Data Option window, select 'Pattern Based Data' option and click on 'Next' button to start 'Extract Multiple Data' wizard.
- Step1 of wizard is to select the fields you need to extract. Click on 'Add' button and capture the field you need to extract say for e.g. name of restaurant. You will be presented with a small window having 'Capture' button. Click on that 'Capture' button to capture another instance of same field in order to match the pattern. Specify the Column Name and the action in 'Extract Data Field' window. Similarly, add number of fields you want to extract data from. For e.g. Name, Address and Phone number.
- After you captured all the fields, click on 'Next' link. In Step2, you can specify if data is in multiple pages and using 'Capture' button capture the button or link that loads the next page. Click on Next button.
- In Step3, specify the name and path of CSV file, where you need to save the extracted data. You can view the data using 'Preview Data' button. Eventually, click on Finish button to complete the wizard.
- Stop the recording and save the task.
|
 |
How to run the task
- In case you do not have Automation Anywhere installed, please download and install it from, http://www.automationanywhere.com/download/freeTrial.htm.
- Save T66.atmn under location, My Documents\Automation Anywhere\Automation Anywhere\My Tasks.
- Launch Automation Anywhere and from Task List select T66.atmn and click on RUN button to run the task.
|
|
| |
| When you run this task, it extracts information about all the restaurants in your area. |
|
 |
| Wow! This program is fantastic. I was given the task to figure out how to get a list of over 1000 contacts off of a website and into Excel. I was trying to write some kind of macro for days through Excel's VB extension and was making no progress. So I went online and found Automation Anywhere, it took me only minutes to write a macro to copy the addresses. I owe Tethys Solutions hours of my life that I was prepared to spend copying and pasting. Thank you so much Tethys" |
- Ben Kinney, Monterey media
|
| Read Customer Testimonies >> |
|