I need data from the following site:? ? <[login to view URL]>
Specifically, I need:
- As of date
- Name of game
- Position #
- Console type (Wii, X360, etc).? Even though this is an image and not text, I believe it can be picked up by the way the image is named in the HTML source for each results page.
- Publisher
- Week #
- Weekly total
- Total to date
For the top 50 games each week going back to April 22, 1989.
The script needs to be in PHP or Perl.? ? There are 2 parts to the? script:
- 1st part is to? fetch the data from April 22, 1989 to June? 6, 2009.
- 2nd part is to fetch only the most recent data, i.e.? I intend to run the script? on a weekly basis so I want? to? fetch? data that was not? previously retrieved.? For example, if I? run this script next week, it will? fetch the data only for? week of June 13, 2009.? Additionally, if I miss running the script for a couple? of weeks and I run? the script, it should? be? intelligent? enough to know that it needs to? fetch all the data for the missing weeks.
I intend to store the data in a? database (MySQL or SQL Server).? So? the script could make use? of the "as of"? field in the database to figure out? how many weeks of updating needs to take place.?
Requirements:
- The PHP or Perl script
- A CSV file for the output from April 22,1989 to June 6, 2009
- An interface to the database
## Deliverables
Please see attached zip file.? It contains an Excel spreadsheet showing how I want the CSV file to be displayed w/in Excel.