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.msnmoney.com just for illustrative purposes.
 T61.atmn  T61.mdb  T61.csv
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.msnmoney.com. Click on Start Button.
- As the web page opens, type MSFT in Text box next to Get Quote.
- Click on Get Quote to get all the details for Microsoft Corp.
- Click on Options Link on the page, to get stock trends in Tabular form.
|
Screenshot 1
Screenshot 2
Screenshot 3
Screenshot 4
Screenshot 5
|
 |
Extract Data
- Click on "Extract Table" in the web recorder taskbar.
- Capture Cursor appears. Take the capture cursor on the respective table of the webpage to be extracted in CSV format.
- A preview of extracted data opens.
- Click on Next to save the table.
- Save the table as C:\msntableaccess.csv.
- Stop Recording & Save the Task.
|
 |
Save the extracted data in the database
- Create an Access file as msntable.mdb.
- Connect msntable.mdb file using Connect tool in Database option of Task Window Editor.
- Click on Connection String.
- Data Link Properties window opens. Go to the Provider tab and select "Microsoft Jet 4.0 OLE DB Provider". Click Next.
- Connection tab of Data Link Properties window opens. Browse for the Respective Access file created i.e. MSNTABLE.mdb.
- Click on Read from CSV file command.
- Click on Loop command to Read Each Row In A CSV/Text File.
- Click on Database command and select SQL Query.
- Keep Session Name Default.
- In Enter Insert/Delete Statement field: type {Insert into Table1 values ('$Filedata Column(1)$','$Filedata Column(2)$')}
- End Loop and Disconnect from Database.
- Close Browser.
|
 |
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.
|
|
| |
|
 |
| 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 >> |
|
