Duplicated records in CSV

How to?
#1

Hi, please help me. I'm trying to get from this site [NBA 2019/2020 Scores / Results | Livesport.com]
some basic data. Date, home team, away team and home and away points.

The problem is that I get duplicated rows in the CSV file. I guess I don't have the Selector correctly, but I don't know how to set it up.

Can someone please help me on this?

Thank you in advance!

Sitemap:
{"_id": "nba19/20", "startUrl":["NBA 2019/2020 Scores / Results | Livesport.com"], "selectors":[{"id": "loadmore", "type": "SelectorElementClick", "parentSelectors":["_root"], "selector": "div.container__fsbody", "multiple":false, "delay":2000, "clickElementSelector": "a. event__more", "clickType": "clickMore", "discardInitialElements": "do-not-discard", "clickElementUniquenessType": "uniqueText"},{"id": "game", "type": "SelectorElement", "parentSelectors": {"id": "date", "type": "Selector":["game"], "selector": "div:nth-of-type(n+102)", "multiple":true, "delay":0},{"id": "date", "type": "SelectorText", "parentSelectors":["game"], "selector": "div. event__time", "multiple":false, "regex":", "delay":0},{"id": "home", "type": "SelectorText", "parentSelectors":["game"], "selector": "div. event__participant--home", "multiple":false, "regex":"", "delay":0},{"id": "away", "type": "SelectorText", "parentSelectors":["game"], "selector": "div. event__participant--away", "multiple":false, "regex":"", "delay":0},{"id": "HomePoints", "type": "SelectorText", "parentSelectors":["game"], "selector": "div. event__score--home", "multiple":false, "regex":", "delay":0},{"id": "AwayPoints", "type": "SelectorText", "parentSelectors":["game"], "selector": "div.event__score--away", "multiple":false, "regex":", "delay":0}]}

#2

Please repost sitemap in reply like this.

image

#3

{"_id":"nba19/20","startUrl":["https://www.livesport.com/en/nba-2019-2020/results/"],"selectors":[{"id":"loadmore","type":"SelectorElementClick","parentSelectors":["_root"],"selector":"div.container__fsbody","multiple":false,"delay":2000,"clickElementSelector":"a.event__more","clickType":"clickMore","discardInitialElements":"do-not-discard","clickElementUniquenessType":"uniqueText"},{"id":"game","type":"SelectorElement","parentSelectors":["loadmore"],"selector":"div:nth-of-type(n+102)","multiple":true,"delay":0},{"id":"date","type":"SelectorText","parentSelectors":["game"],"selector":"div.event__time","multiple":false,"regex":"","delay":0},{"id":"home","type":"SelectorText","parentSelectors":["game"],"selector":"div.event__participant--home","multiple":false,"regex":"","delay":0},{"id":"away","type":"SelectorText","parentSelectors":["game"],"selector":"div.event__participant--away","multiple":false,"regex":"","delay":0},{"id":"HomePoints","type":"SelectorText","parentSelectors":["game"],"selector":"div.event__score--home","multiple":false,"regex":"","delay":0},{"id":"AwayPoints","type":"SelectorText","parentSelectors":["game"],"selector":"div.event__score--away","multiple":false,"regex":"","delay":0}]}

#4

Hi,
Here is your new sitemap:

{"_id":"nba19/20","startUrl":["https://www.livesport.com/en/nba-2019-2020/results/"],"selectors":[{"id":"loadmore","type":"SelectorElementClick","parentSelectors":["_root"],"selector":"div.container__fsbody","multiple":false,"delay":2000,"clickElementSelector":"a.event__more","clickType":"clickMore","discardInitialElements":"do-not-discard","clickElementUniquenessType":"uniqueText"},{"id":"game","type":"SelectorElement","parentSelectors":["_root"],"selector":"div.event__match:nth-of-type(n+3)","multiple":true,"delay":0},{"id":"date","type":"SelectorText","parentSelectors":["game"],"selector":"div.event__time","multiple":false,"regex":"","delay":0},{"id":"home","type":"SelectorText","parentSelectors":["game"],"selector":"div.event__participant--home","multiple":false,"regex":"","delay":0},{"id":"away","type":"SelectorText","parentSelectors":["game"],"selector":"div.event__participant--away","multiple":false,"regex":"","delay":0},{"id":"HomePoints","type":"SelectorText","parentSelectors":["game"],"selector":"div.event__score--home","multiple":false,"regex":"","delay":0},{"id":"AwayPoints","type":"SelectorText","parentSelectors":["game"],"selector":"div.event__score--away","multiple":false,"regex":"","delay":0}]}

1 Like
#5

Thank you so much for your quick help, this is exactly how I needed it.