www.28hse.com/en/buy
with Gross Area
residential/property-2607979
without Gross Area
residential/property-2607961
I try to scraping the property within this website to excel
some of the property without Gross Area, some they do have Gross Area
first question:how can i scraping properly ?-I have tried anchor base “find element”-result:error and “find text position”-result: text was not find
second question : I like to updated the excel daily, what can I do only scraping the latest property without scraping the whole website.
Hello @max_chanchan
You can use Data Scrapping method. It will scrape the data and store it in the data table format. you can write the data in an Excel sheet using the Write range actvity.
sorry i cant login back old acc,so i create a new acc
and thanks for the suggestion
but i already read over 10+ web scraping video include your suggestion video
your suggestion video only scrap the 1layer of the website
and I think i dont explained my problem well
my first question is
example
this property with gross area and saleable area
but some of the other properties only have gross or saleable area.
I did my research, not sure if this working
second question is
after i fist time scraping the whole website how can i just scrap the latest propert only
Im think check property URL, see if it duplicatte or not
then stop the loop
not sure how to do that
You can define the table extraction activities to extract all fields that you want, using a listing that contains both Gross Area and Saleable Area. UiPath will automatically leave Gross Area / Saleable Area blank if that attribute is not available for a listing.
As for checking the latest properties only, you should set the Sorting field on the website to “Recent”, then scrape a fixed set of results e.g. first 10 pages. Then from the scraped results you can check which ones have been scraped before by comparing the URL, and exclude them from the final result.
Example table extraction for 28hse.com attached. See Output.xlsx for sample results.
thank you for your afford. I have download the file.your file scraping the directory page only, but my case, I have to get into each property to scraping other information
this is what I did so far, main and sequence1 file, and I cant upload file in the forum so I upload to here: https://file.io/IDu0uTe8XgIR
would you mind take a look see what I do wrong?
