Window form extension to load data to SQL Server DB

IN PROGRESS
Bids
13
Avg Bid (USD)
$486
Project Budget (USD)
$250 - $750

Project Description:
This project is for adding some extension to an existing windows form and also entails the creation of a new window form. The existing windows form imports either a TEXT or XML file and allows the user to map columns from the TEXT file to columns in one or more SQL Server Tables. The objective of this project is to add the logic for the LOAD button which will import the data into the SQL Server database tables using the column map defined by the user. Only the TEXT file is map to columns by the user. The XML file is automatically mapped by the program. List below is an overview of the functionality that will needed to be developed for this project. The attached specification document contains more details of this project.

• File Map Window – LOAD button logic will need to be created.
- Read in all rows from a text file or PIES XML file.
- Map imported data columns to either user specified column map, if text file. Otherwise, map PIES XML
attributes to predefined data base columns.
- Perform SCHEMA validation of PIES XML files.
- Perform a full validation of all data during the load process. The validation routine is already developed.
You just need to call it and display the error codes returned.
- Perform a background process to perform the data load for large files. If file is small, display a progress
bar and load in foreground. The process report will be available through the file audit window

• Create a new file audit window that will list all the file names loaded along with some file statistics such as
number of items loaded, number of item errors, status, import date and user id.

• Preview Window Updates
- Perform a pre-validation check of first 500 records by calling an already defined validation function.
Results will need to be displayed. This function is only performed if user optionally selects a preview
button.

I will provide the following for this project:
• A copy the file map window as described below. You just need to complete the LOAD and PREVIEW
buttons and create a new window form to display files.
• A copy of the SQL Database. All the tables are already created.
• Documentation about the PIES XML file including the schema.
and Test Files.

Project Expectations:
1. Must be developed in C# Visual Studio 2005 or 2008. Windows Form.
2. SQL Server 2000 - 2005.
3. Code must be unit tested and delivered when final payment is made. This includes SQL Server table changes and
stored procedures.
4. Most important. Please design and write code for maximum performance. Some of the files imported can be very
large.
5. I will pay bonus for early completion and also for any suggestions to make this better such as process
improvements to process files quickly, changes to the design to make it easier to use and SQL Server
improvements.

Preferred Experience:
• Advanced knowledge of C#, XML and SQL Server.
• Windows form experience

Please see attached detail specification for more details about this project.

Skills required:
C# Programming, SQL
Additional Files: PIESMapWindow-PhaseII.zip
About the employer:
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 qtorixsystems
$ 500
in 5 days
Hire iPPS
$ 500
in 20 days
$ 450
in 5 days
$ 500
in 10 days
$ 550
in 5 days
$ 300
in 14 days
Hire sm2mafaz
$ 550
in 30 days
Hire Mikhail19
$ 550
in 15 days
Hire wasginc
$ 450
in 10 days
Hire mrbig81
$ 300
in 7 days