Automation Anywhere Call: 1-888-484-3535   

 
Automation AnywhereWeb Data Extraction
  Home > Product > Solutions > Web Data Extraction > T61  
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.
Buy Now Free Trial

Next Steps
Compare versions Compare versions
Watch a flash demo Watch a flash demo
Contact me Contact me
Ask the Expert Ask the Expert
Request live demo Request live demo

Call 1-888-484-3535

25,000+ Customers
25,000+ Customers
Customer list | Case Studies

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 >>
  Products     Download     Purchase     Services     Support     Customers     Company     Sitemap     Trademark FacebookTwitterAutomation Anywhere Blog © Automation Anywhere 2010 Privacy Policy
Web Data Extraction Pattern Matching Automation Anywhere Free Trial