| T61 - Extract people data from Web and transfer it to a database |
| Task Description |
Extract people data from web and transfer it to a database.
Note: This sample task uses an example of http://www.builders.org.uk/search/builders.aspx just for illustrative purposes.
 T61.atmn
 Buildersdb.mdb
Note: Save the .atmn file in My Documents -> Automation Anywhere -> Automation Anywhere -> My Tasks and create Contact_Details.xls in C:\.
|
| Solutions |
 |
Web Recording
- Click on Web Record link.
- Specify URL, http://www.builders.org.uk/search/builders.aspx and click on Start button.
- Specify postal code let’s say BS11 9LD
- Click on ‘Search for a builder’ button.
|
Screenshot 1
Screenshot 2
Screenshot 3
Screenshot 4
Screenshot 5
|
 |
Extract Data
- 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. 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.
- 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. In this case, capture ‘2’ link and click on ‘Advanced View’. Now, replace ‘2’ in caption with any user variable say ‘Prompt-Assignment’ and save it. After recording, edit the task to increment the value of variable $Prompt-Assignment$ so in each iteration of loop, next page number will be clicked.
- In Step3, specify the CSV file path where you need to save the extracted data. Also, if you have captured the image in Step1 then specify the folder name where you need to download the images.
- 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.
|
 |
Save the extracted data in the database
- After recording, edit the task to transfer the extracted data into database buildersdb.mdb.
- Use ‘Read from CSV/Text File’ command to connect the CSV, where data is extracted and use system variable, $FieldDataColumn(index)$ to extract each row of CSV file.
- Insert Database commands to connect and insert the extracted data into the database (.mdb).
|
 |
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
- Use ‘Read from CSV/Text File’ command to connect the CSV, where data is extracted and use system variable, $FieldDataColumn(index)$ to extract each row of CSV file.
- Save T61.atmn under location, My Documents\Automation Anywhere\Automation Anywhere\My Tasks
- Save .mdb file under C:\.
- Launch Automation Anywhere and from Task List select T61.atmn and click on RUN button to run the task.
|
|
| When you run this task, it searches people by last name and city and extracts their addresses and phone numbers and saves them to a .csv file and inserts them into your database. |
|
 |
| We started using this product to copy data from legacy system to new system. Now we use it just to do about anything automated. Countless hours saved. Thank you guys. |
- Jack Greenberg
|
| Read Customer Testimonies >> |
|
