Screen scrape web site to create 2 lists

Task 1

Screen scrape http://www.rya.org.uk/wheresmynearest/Pages/Directory.aspx#list/t-2 to obtain a list of 1,479 (ot thereabouts) training centres.

It will be necessary to drill down 2 levels so that, for each training centre we create multiple Excel rows comprising:

1st Level:

Training Centre Name
Address
Tel
Mobile
Web-Site
Email
Contact for course enquiries
Address (for enquiries)

Note that some fields might be null.

2nd Level

List of Courses. See sample Spreadsheet1 attached.

Task 2

Screen scrape http://www.rya.org.uk/wheresmynearest/Pages/Directory.aspx#list/t-2 to obtain a list of 1,127 (or thereabouts) clubs.

It will be necessary to drill down 2 levels so that for each club we create multiple Excel rows comprising:

1st Level:

Name
Club Address
Tel
Tel2
Office
Fax
Website
Email
Contact Address
Tel
Tel2
Office
Fax
Website
Email

Note that some fields might be null.

2nd Level

List of Activities. See sample Spreadsheet2 attached.