Latest Inquiries - Data Extraction Software

List of Australian Pubs

Submitted: 3/9/2013

Hi there. I'm looking for web-scraping of the site www.publocation.com.au/pubs.

This website has listings of Pubs/Hotels throughout Australia which I would like data extracted into Excel Format including:

Name
Address
Website
Email
Phone
Fax

The format of the site is
www.publocation.com.au/pubs/*STATE/TERRITORY*/  which, upon selection of the STATE/TERRITORY a list of SUBURBS is returned. Within each list of SUBURBS is a list of HOTELS and when clicking on any of the HOTELS links opens a page with the HOTEL information.
*Note that not all listing have all data available.

Example:

http://publocation.com.au/pubs/nsw/aberdeen/aberdeen-hotel-top-pub
NSW hotel in ABERDEEN called ABERDEEN HOTEL TOP PUB

http://publocation.com.au/pubs/sa/clare/taminga-hotel
SA hotel in CLARE called TAMINGA HOTEL

The Site shows information available for the following number of Hotels/Pubs:

ACT: 22
NSW: 929
NT: 40
QLD: 645
SA: 384
TAS: 143
VIC: 525
WA: 336

All available hotel information should be extracted into an Excel file.

I hope this makes sense :)

Thanks

Replied: 3/10/2013 4:42:32 AM
Please check the attached demo project.

I don't seem to find any results in first state - ACT, most of pages have been failed to open. so I've start from 2nd state - NSW in this demo project.

To start from 1st state - ACT, you can edit the 'state' link template then go to List tab at right side, then set 'Start index' = 0.
Publocation.rip