Newbie CSV Export Issue/Probably Don't Know How to Crawl Correctly

How to?
#1

I am trying to scrape this site. When I try to extract name, date, and review to CSV they're all messed up and not on the same line together. I am brand new so I know I am messing this up. If anyone can help me, I would appreciate it.

Url: https://localreviewdirectory.com/acupuncture/tn/franklin/dr-gil-center-for-back-neck-and-chronic-pain/

Sitemap:
{"_id":"dr-gil-reviews","startUrl":["https://localreviewdirectory.com/acupuncture/tn/franklin/dr-gil-center-for-back-neck-and-chronic-pain/"],"selectors":[{"id":"wrapper","type":"SelectorElement","parentSelectors":["_root"],"selector":"div.content-area-left","multiple":true,"delay":0},{"id":"name","type":"SelectorText","parentSelectors":["wrapper"],"selector":"h3","multiple":true,"regex":"","delay":0},{"id":"date","type":"SelectorText","parentSelectors":["wrapper"],"selector":"span.content-date","multiple":true,"regex":"","delay":0},{"id":"description","type":"SelectorText","parentSelectors":["wrapper"],"selector":"p","multiple":true,"regex":"","delay":0}]}

#2

You need to wrap each review into an element to make sure your data from different reviews do not mix. When you have done that, you need to make sure that all of the Text selectors does not have 'Multiple' checkbox checked. The 'Multiple' option cases the gaps in the data.

Here is the sitemap:

{"_id":"dr-gil-reviews-fx","startUrl":["https://localreviewdirectory.com/acupuncture/tn/franklin/dr-gil-center-for-back-neck-and-chronic-pain/"],"selectors":[{"id":"wrapper","type":"SelectorElement","parentSelectors":["_root"],"selector":"li[itemprop='review']","multiple":true,"delay":"0"},{"id":"name","type":"SelectorText","parentSelectors":["wrapper"],"selector":"h3","multiple":false,"regex":"","delay":0},{"id":"date","type":"SelectorText","parentSelectors":["wrapper"],"selector":"span.content-date","multiple":false,"regex":"","delay":0},{"id":"description","type":"SelectorText","parentSelectors":["wrapper"],"selector":"p","multiple":false,"regex":"","delay":0}]}

#3

Thank you so much! Totally worked!

#4

I am now trying to get it to scrape via pagination. However, when you visit each link, the scraper stops working. I can data preview and scrape page 1 (landing page) but when I try to data preview and scrape the 2nd, 3rd, 4th, etc. it doesn't work. I'm using the sitemap you gave me above. What am I doing wrong?

#5

The selector has changed for the reviews and you need to use the Click Selector to paginate through the pages.

{"_id":"dr-gil-reviews-fx","startUrl":["https://localreviewdirectory.com/acupuncture/tn/franklin/dr-gil-center-for-back-neck-and-chronic-pain/"],"selectors":[{"id":"wrapper","type":"SelectorElementClick","parentSelectors":["_root"],"selector":"ul#reviews li:has(h3)","multiple":true,"delay":"2000","clickElementSelector":"li.pager:nth-of-type(n+2)","clickType":"clickOnce","discardInitialElements":"do-not-discard","clickElementUniquenessType":"uniqueCSSSelector"},{"id":"name","type":"SelectorText","parentSelectors":["wrapper"],"selector":"h3","multiple":false,"regex":"","delay":0},{"id":"date","type":"SelectorText","parentSelectors":["wrapper"],"selector":"span.content-date","multiple":false,"regex":"","delay":0},{"id":"description","type":"SelectorText","parentSelectors":["wrapper"],"selector":"p","multiple":false,"regex":"","delay":0}]}