This project is to develop a Windows Service to parse text files and insert data into a SQL Server table.
This is how I envision it working,
There will be a folder on my server. Your service will check for files in that folder every 10 minutes or so.
If a file is found, you will run the routine to parse it and place the data in the table and then move the file to another folder.
The file will be a tab delimited flat file. There will be 2 tables in the database. One table is the main table - each line in the flat file corresponds to one record in the db table. There is a primary ID number, if the ID is not already in the table, insert the record. If the ID is already in the table, compare the date updated fields and you may need to Update the record.
If for some reason, SQL rejects the insert or update, it will most likely be for a data type mismatch. The second table in the db is a temp table with the same fields but every field is varchar(max). Put that record in the second table and in one of the fields put the sql error or field that was rejected.
At the end of the parsing of a text file, send an email to confirm and also note if anything was rejected and placed in the temp file. In that email have a link to the following webpage...
Create a simple webpage usnig asp.net. You can use the standard controls for data grid and edit into the temp table. I will be able to go through and edit the field that was in error, then on save it will try to insert/update that record to the main table and if it is rejected again it will put it back in the temp table with the reason.
## 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
Windows 2003 Server
Sql Server 2005 DB
ASP.NET using C# 2.0
Windows Service using C# 2.0