Latest Inquiries - Data Extraction Software

Avon

Submitted: 11/16/2012

I have been looking for a software solution to this problem for many years and I am very pleased that your software Is almost doing everything I need.  I do have a problem though and I have attached my rip file and my sample extracted data.  I have no problem setting up the links and categories, although I just did a small section of the website as a test.

the problem is when you get into the grouping ( for example

BEYOND COLOR Plumping Lip) 

 I can only get your software to return only one single shade of the lipstick(instead of 8 in this example)  into the database or all of the shades and product numbers  into one single excel box

     the element I am saving as shades of lipsticks is spnVariantName

 

I would like them to be listed as follows when I export them into excel instead of only 1 shade per lipstick like in my example output

pgName pgSalePrice pgPrice spnVariantName spnVariantLine
BEYOND COLOR Plumping Lip Color SPF 15 Sale $3.99 Reg. $8.00 Uptown Pink 956-984
BEYOND COLOR Plumping Lip Color SPF 15 Sale $3.99 Reg. $8.00 cocoa 422-398
BEYOND COLOR Plumping Lip Color SPF 15 Sale $3.99 Reg. $8.00 twig 422-201
BEYOND COLOR Plumping Lip Color SPF 15 Sale $3.99 Reg. $8.00 divive wine 417-301

 

 

 

thank you,

joshua

 

 

 

 

 

 

Avon.rip
123.xlsx

Replied: 11/17/2012 5:49:12 AM

See the attached new project.

I've added a new page area template 'Shade area' that it iterates each shade .

Another hand, I set up the Export method = AddRowsInParenetTabe with the 'Shade area' page area template, the setting can be found in Advanced tab > Export data section, therefore, the each row in sub-table will be combined into its parent table (main table).

Avon.rip