Page 1 of 1

Scrape single and multiple rows from table at the same time

Posted: Mon Feb 04, 2013 10:57 am
by edvukass
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

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

Posted: Mon Feb 11, 2013 6:02 pm
by webmaster
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.