I gang

Window form extension to load data to SQL Server DB

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.

Færdigheder: C# Programmering, SQL

Se mere: xml programming needed, test data creation, sql database program, small improvements, server load test, schema form, programming logic design, programming logic, programming sql, programming errors, programming data base, objective audit, final specification, design imports, data programming, database programming sql, sharp test, sharp map, sharp base, bonus codes, audit program, audit file, audit details, advanced background check, load data sql server

Om arbejdsgiveren:
( 49 bedømmelser ) Powder Springs, United States

Projekt-ID: #957103

Tildelt til:

iPPS

Hi! Please see PM for details.

$500 USD in 20 dage
(18 bedømmelser)
5.4

13 freelancere byder i gennemsnit $486 for dette job

qtorixsystems

Hello Please read PM Regards Umer

$500 USD in 5 dage
(17 bedømmelser)
5.7
freelancer1977

Please check PM

$450 USD in 5 dage
(9 bedømmelser)
5.1
aptecpymefree

I can work in your Window form extension program. I have 13 Years of experience in Software development Windows and Web. Expert in Sql Server and .NET. Microsoft Certified as MCP, MCTS, MCPD, MCT.

$500 USD in 10 dage
(3 bedømmelser)
5.2
saamorim

Hello. Please see private messages. Thank you

$550 USD in 5 dage
(10 bedømmelser)
4.8
Ahmedn1

Please Check PM

$300 USD in 14 dage
(4 bedømmelser)
4.4
sm2mafaz

Hello There, Please have a look to the PMB for further details. Kind Regards, Mafaz

$550 USD in 30 dage
(9 bedømmelser)
4.1
madworks

Hi, I can do this work for you.. I have experience in this domain

$590 USD in 7 dage
(0 bedømmelser)
0.0
Mikhail19

Hi. Please, see PMB for details.

$550 USD in 15 dage
(0 bedømmelser)
0.0
mrbig81

Plz check your pmb.

$300 USD in 7 dage
(0 bedømmelser)
0.0
KhurramSiddique

give me chance so that i can prove my self

$477 USD in 20 dage
(0 bedømmelser)
0.0
indiansoftw

Please see PM

$600 USD in 7 dage
(0 bedømmelser)
5.5
wasginc

hello how are you iam ready to do the job for you .

$450 USD in 10 dage
(0 bedømmelser)
0.0