Scrape single and multiple rows from table at the same time

Questions and Answers about programming Helium Scraper.
Post Reply
edvukass
Posts: 13
Joined: Wed Jan 30, 2013 3:58 pm

Scrape single and multiple rows from table at the same time

Post by edvukass » Mon Feb 04, 2013 10:57 am

Hi, is it possible to extract single and multiple rows from a table (or multiple tables on the same page) at the same time?
For example:

There are multiple product tables on a page where
1 row is Product name
2 row active ingredient
3 form
and 1 or more extra rows are prices for different quantities of product

Here is a link: http://www.cbip.be/GGR/MPG/MPG_LAAE.cfm#MP_01735

What I want to achieve is create records in helium database so that each Price would be assigned to specific Product

webmaster
Site Admin
Posts: 479
Joined: Mon Dec 06, 2010 8:39 am
Contact:

Re: Scrape single and multiple rows from table at the same t

Post by webmaster » Mon Feb 11, 2013 6:02 pm

Do you mean something like having a Product table and a Price table where many prices are related to a single product? You can simply use many Extract actions, starting with the one that extracts to the Product table, and then the one that extracts to the Price table, and on this one, extract the ID_Product property from the kind that selects the product. This will keep your tables properly related. Here is a video that shows how to extract hierarchical data like this. Note, however, that on the video data is been extracted from many pages. On your case you'd set all your Extract actions to extract from the same page.
Juan Soldi
The Helium Scraper Team

Post Reply