I have a specific website full of USA High Schools - 32,988 of them. The URL's to view them are sequential (Example : [url removed, login to view] )
I need you to write some type of script that goes sequentially to each page (URL), grabs 3 fields:
1. Name of School
2. Athletic Directors Name
3. Athletic Directors E-Mail Address.
I would like a CSV (comma deliminated file) as output so I can parse that data into my database. This project is NOT for spamming, I have a database of high schools already on my sports site - just want an easy way to copy the Athletic Director into my site's databases.