• Click on Tools->Web Recorder.
• Enter the starting URL for e.g. http://www.partsgeek.com/catalog/2003/bmw/z4/air_intake/air_mass_meter.html and click on Start button.
• Extract list of Related Parts from left panel on webpage. For that, 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 a part from list for e.g. ‘Air Filter’. 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 for e.g. ‘Air Mass Meter’. Screenshot0
• Specify the Column Name in 'Extract Data Field' window and save. Screenshot1
• After you captured the field, click on 'Next' link. In Step2, you can specify if data is in multiple pages. In this case, the data is in single page so you can skip this step and click on Next button.
• In Step3, specify the name and path of CSV file, where you need to save the extracted data for e.g. C:\Parts.csv. You can view the data using 'Preview Data' button. Eventually, click on Finish button to complete the wizard.
• Click on any Part under ‘Related Parts’ say ‘Air Pump’.

• To extract unstructured Part details on right side of webpage, 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.
• In Step1 of wizard capture/add number of fields you want to extract data from webpage (Screenshot 2). For e.g. Part Name, Part Number and Price. Screenshot 3
• After you captured all the fields, click on 'Next' link. In Step2 click on Next button.
• In Step3, specify the name and path of CSV file, where you need to save the extracted data say C:\PartDetails.csv. Click on Finish button to complete the wizard.
• Stop the recording and save the task.

• Open the recorded task in Task Editor from Tools-> Task Editor.
• After you extracted the list of Parts at Line #2, insert ‘Read from ‘CSV/Text File’ command to open C:\Parts.csv.
• After ‘Read from ‘CSV/Text File’ command, insert ‘Loop for each row in CSV/Text File’ command.
• Inside this loop block, put commands that clicks on Part link and extracts the Unstructured data.
• Double-click on command that clicks on Part link and replace the actual Part with system variable, $Filedata Column(1)$. Save the command. Screenshot 4
• Entire task will look as in Screenshot 5.

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 T79.atmn under location, My Documents\Automation Anywhere\Automation Anywhere\My Tasks
• Copy Data.xls under C:\
• Launch Automation Anywhere and from Task List select T79.atmn and click on RUN button to run the task.