Data Scraping. PLEASE DO NOT CONSIDER THIS JOB if you are trying to do this manually (There are too many records) You will need to write scraping code to do this job.

I would like to get you to do the job but I have found a better way to collect the data – details are below.

The site page to do the searches for the extraction is: https://gtgo.me/reiqbb
To all the data the code needs to search in the following manner:

The office activity field should rotate search for (“Auctioneer, Business Broking, Buyers Agency (Exclusive), Buyers Agent, Commercial, Holiday Letting, Management Rights, Property Management, Resident Letting Agents, Residential Sales, Rural”)
The postcode field should rotate through each postcode in this file – download it here post-codes-only-qld.xls or each of these options above. (There are 436 postcodes to rotate through in this file)
The link for each agency should be clicked and the data for the Agency collected from the next page.

The data of the Agencies should be collected and saved in this manner (Agency, ABN Number [saved into the last field on each row], Address,Phone,Fax,Website,Email,Contact Name [Contact Name need to be split and saved Into into Contact First Name & Contact Last Name fields], Post Code [The Post Code from the address must be duplicated and saved into the Post Code field) Areas of Practice [All Areas of Practice items need to be saved into the Areas of Practice field in this format – each item separated by – e.g. Auctioneer, Property Management, Residential Sales]

All phone numbers need to be formated in international format e.g. A +61 prefix added, the leading zero deleted and spaces stripped from mobile numbers e.g. 046 888 3313 becomes +61468883313 – Landline numbers and fax numbers are changed from e.g. 07 5538 0117 to +61755380117

PLEASE NOTE: In my sample files I have not formatted the phone numbers.
The Data of the Agencies needs to be saved into one spreadsheet. Download a sample file here my-sample-agencies-nu.xls
—————————————————————————————————–

As the same search above is executed the details of the agents (connected to each agency are collected) on THE Agency page a button on the left displays lists the agents of that agency.
The Data of the Agents needs to be saved into a separate spreadsheet. Download a sample file here my-sample-agents-NU.xls
—————————————————————————————————-

If you are selected for the job I will get you to supply 2 sample data files for Agencies and The Agents from the search for Two Postcodes  4217 And 4350 And Office Activity field in the form is: Residential Sales). I will check that data before you run the entire script.

The Code must search for each of the following Office Activities (“Auctioneer, Business Broking, Buyers Agency (Exclusive), Buyers Agent, Commercial, Holiday Letting, Management Rights, Property Management, Resident Letting Agents, Residential Sales, Rural”)
for each of the 436 postcodes so we do not reach the maximum number of records 30. Please supply the data collected de-duplicated in two xls files – one for the Agencies alone and one for the Agents.

What Code will you be using to write the scraper in?

Looking forward to hearing from you.