I need a script to read tables from web pages do some basic data processing and place the data into a databse.
The website is:
[url removed, login to view]
I need to have all the data for all the locations possible.
For example in:
[url removed, login to view];locationType=0&area=Cornwall&reporttype=3&datetype=1&from1=04%2F2000&from2=06%2F2007
I want to be able to store in the database:
Location, Date, Index, Average Price (£), Monthly Change (%), Annual Change (%), Sales Volume, Detached (£), Semi-Detached (£), Terraced (£), Maisonette/Flat (£), All (£).
... Then the same for next city, then next one, etc..
I want to be able to rerun the sctipt on biweekly basis to capture new data.
I have no preference, on OS and scripting lanuage, nevertheless data should be easily made available to excell and crystal reports.
This data is for my personal use and as far as I am aware does not violate the land registry copyrights.