Parse xml into sql database

CLOSED
Bids
58
Avg Bid (USD)
$4157
Project Budget (USD)
$500 - $5000

Project Description:
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.

## Deliverables

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).

## Platform

MS SQL Server, Windows Server, Windows XP,

Skills required:
.NET, Amazon Web Services, ASP, C# Programming, Engineering, MySQL, PHP, Software Architecture, Software Testing, SQL, Testing / QA, Usability Testing, Website Testing, XML, XSLT
Additional Files: zRAC_DOC_NameCryptedToProtectYourPrivacy_X200511112513158771555681207773868063475788106070416552246573562325106.zip
Hire amino2000
Project posted by:
amino2000 United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire asselsolutionsvw
$ 5950
in 35 days
Hire monkeymanvw
$ 4250
in 35 days
$ 4675
in 35 days
$ 4250
in 35 days
Hire pdarko
$ 13600
in 35 days
Hire rengifojoel
$ 4845
in 35 days
Hire chronoman7
$ 4250
in 35 days
Hire icem4n
$ 6800
in 35 days
Hire harisraheem
$ 4250
in 35 days
Hire chandelz
$ 5291.25
in 35 days