Multiple text not showing in CSV

[mfaubert]

Hi all,

I'm a new user to webscrapper. sorry if this is a basic question, but I can't solve it.
I'm trying to scrape multiple

items using a text selector
when I look at the data preview everything looks good (see screen shot)

when I check the csv file, only 1 item is recorded (see second screen shot ), I get only 1 randow

item out of the list I want. I need all the

let em know what I'm doing wrong

start Url: https://www.racycles.com/road/
example of the datapage I want to extract
Url: https://www.racycles.com/road/3t/3t-strada-team-daytona-race-bike-15498

Sitemap:
{"_id":"rna-cycles","startUrl":["https://www.racycles.com/road"],"selectors":[{"id":"brands","type":"SelectorLink","parentSelectors":["_root"],"selector":"div.col-sm-12 div.col-sm-6 a","multiple":true,"delay":0},{"id":"model","type":"SelectorLink","parentSelectors":["brands"],"selector":"a.ng-binding","multiple":true,"delay":0},{"id":"brand","type":"SelectorText","parentSelectors":["model"],"selector":"ul.breadcrumb li:nth-of-type(3) a","multiple":false,"regex":"","delay":0},{"id":"price","type":"SelectorText","parentSelectors":["model"],"selector":"ul.prodPagePrices:nth-of-type(1) li.currPrice","multiple":false,"regex":"","delay":0},{"id":"discount","type":"SelectorText","parentSelectors":["model"],"selector":"li.priceDiff","multiple":false,"regex":"","delay":0},{"id":"old price","type":"SelectorText","parentSelectors":["model"],"selector":"li.oldPrice","multiple":false,"regex":"","delay":0},{"id":"Specifications","type":"SelectorElement","parentSelectors":["model"],"selector":"ul.specificationInfo","multiple":false,"delay":0},{"id":"specs-items","type":"SelectorText","parentSelectors":["Specifications"],"selector":"li.ng-binding.ng-scope","multiple":true,"regex":"","delay":0}]}

[ramonhak]

Hi,

Not sure what the problem is? When I download your csv, based on your sitemap,

it looks good to me?

[mfaubert]

Hi @ramonhak,

thanks for taking the time to reply
see the attached images with comments, it will be easier to explain

Is it clear

[ramonhak]

Ahh...I see what you mean now. And the behavior from the scraper is correct. It is not possible to convert multiple data entries (every single line from the specs is considered as one entry) to one line in a csv. So the scraper will only use one.
Even in SQL you need to do special tricks for that (I vaguely remember something like [CONCAT] or something like that)

So maybe there would be another trick that I don't know of, which is easily possible, but I wouldn't know how.

All the best,
Ramon

[mfaubert]

thanks for your answer...
after your reply, I end up extracting the whole ul and exploding it in excel...
dirty way.. but at least I got what I needed