This project concerns a small SQL data base, with a variety of Fields Names.
The database has never really been exploited and the project is to look into the data and see what can be made of it.
This project will have several stages:-
1./ take a copy of the DB and look at it, discover all the field names and list these with two data examples each, in a spread sheet.
2./ the client will assess the data and determine what data is worth reporting
3./ build a report maker that runs a query on the DB and presents updated field and data values in spreadsheet form
The DB contains text and html and url data. The client longer term goal is to achieve a report that organises the urls into some sort of heirarchy, much like a set of categories and sub-categories, or much like a site map.
For stage 3./' you will need to write some code (php ?) to automate the report generation on the main production SQL. Output in .XLS and html page format.
The successful bidder will be sent a copy of the DB to work on. The might be 2-4 weeks between activity for stage 1 and activity for stage 3.