Parse XML sports data into SQL database and have it accessible via a web application. There are about 400 different xml files (~340 dtds) to be parsed. I may require only a portion 100 - 200 to be parsed for this project depending on the details of the bid I accept. In your bid include how many/what percentage of the files you will be able to parse in the given time frame. Specific games, players and teams have cross referenceable id numbers. I do not want one table per file. As much as possible I want information to be cross referenced. During development (or bidding if you wish) I can forward the current feed to a web service, web form, etc. if you give me the address and details. You will be responsible for analysing the xml files and designing/creating the database (tables, stored procedures, etc.), I will take care of all of the database hosting issues. That database will be the backend for several sites that total 1 - 2 thousand hits a day. You will write a program that will receive an xml file as a string and will then input it into the MS SQL 2000 database. My preference is for the program to be written in C# 2.0. This is flexible. Your bid should include your preferred language(s) and to what extent this program will be parsing the file and to what extent that work will be done in SQL. The more work being done in SQL the more flexible I am with the language used. While you can assume all of the xml samples I've uploaded are correct (unless otherwise noted), your parsing method should be able to handle slight variations. Be able to log the variation/error and continue to run. You will also create a web front end. I would prefer ASP.Net 2.0 but the main purpose of this is to have a tool to check on the database and on the feed, so just let me know what you want to use. Your web app should not send raw Select statements but should use stored procedures for retrieving data from the database. All of your code needs to be well comented.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
MS SQL Server, Windows Server, Windows XP,