Em Andamento

Demographic Conversion Program

There are two parts to this [url removed, login to view] project:

1. Create a single form import program to translate data files into a SQL Server database table.

The input data file might be XML, excel, text files delimited with tabs or commas, or a fixed length field text file. The files may or may not have a header. The import program must be able to smartly distinguish between these various types of file formats and do a "best guess" as to the proper field mapping. For example, an XML input file might map perfectly with the existing table schema, but a excel file without a header would be difficult. The ability to do manual mapping might ne necessary.

The output will be to a SQL server database table.

The UI will be a simple screen showing a preview of the first 6 or so records to be imported, and give the user the ability to map the input fields to the SQL fields. From this screen, the use could use a requester to choose the file to be imported and the destination SQL Server database. The table in the SQL server database will also be the same, but there will be different databases to import the file into.

A HTML report listing the number of records imported successfully, the number that failed and a listing of the records that failed.

2. Create a .NET class data access layer for this table for inserts, updates, deletions and select. I will include a VB6 equivalent for the same table that would need to be converted to .NET. Access to the table for inserts and updates would use this class.

Special requirements.

Ability to transform dates correctly into mm/dd/yyyy

Handle names properly. First Name, Last Name and Middle Initial could be three separate fields or it could be in one field that would have to be parsed. For example, John J Doe may come in as "Doe, John J" or as two fields, "JOHN J" "DOE" or as three fields, "John" "J" "Doe"

Partial importing of demographic fields is allowed, but there will be a limited list of required fields that would be needed in order to allow on updated record. first name, last name, id, date of birth and sex.

SQL compatibility down to SQL Server 7. (SQL 7 or SQL Server 2005 with compatibility lever set to 7)

Development Environment shall be Visual Studio 2005

I will provide to you the following:

1) SQL Database table with update, insert, delete and select stored procedures.

2) A VB6 data access layer class that can be used to created the .NET equivalent.

Habilidades: .NET, Visual Basic

Ver mais: program demographic data, ui conversion, sql data conversion, sql database program, schema update, schema form, parts database example, parts database access, one tabs, data conversion sql, access parts database, visual studio excel, types report, xml conversion, translate manual, stored procedures, schema, procedures, ne, mm, insert date, file conversion, data file conversion, procedures manual development, excel database visual basic

Acerca do Empregador:
( 20 comentários ) Greensboro, United States

ID do Projeto: #161355

24 freelancers estão ofertando em média $1016 para este trabalho

askfarhan

hi please see pm

$1500 USD in 30 dias
(64 Comentários)
7.2
cssaglobal1

Plz see the PMB. Thanks & Regards, CSSAGlobal

$1500 USD in 45 dias
(5 Comentários)
6.8
octavioc

I can do it, please check PM.

$900 USD in 9 dias
(11 Comentários)
6.3
vip

Hello, can be done with best quality & professionalism. please check PM for quote. Best Regards, Yurii.

$890 USD in 15 dias
(29 Comentários)
6.2
teckit

I will send details in PM

$1500 USD in 30 dias
(13 Comentários)
6.2
lsweb

Hello. Please check your PM. Thanks.

$1500 USD in 45 dias
(14 Comentários)
5.8
wsh2

ETL: Extract, Transform and Load. Hello my name is Bill.. I am a [url removed, login to view], VB6, VBA, SQL and MsOffice programming Expert, Leader and Mentor [screenname:wsh2] at [url removed, login to view] and www.experts-exchange.com. I Mais

$1289 USD in 7 dias
(22 Comentários)
5.3
ramaswamynanda

Hello, I am very fast at picking up and converting stuff. I can assure quality and timely work. Please check my resume for details. Thx, Nanda

$1200 USD in 40 dias
(5 Comentários)
4.3
momleetech

we can do it

$750 USD in 30 dias
(8 Comentários)
3.7
skywang

I can finish this project within 15 days, have strong experience on c# programming.

$500 USD in 15 dias
(3 Comentários)
3.3
kyawsanwin

Hello Sir I want to do this job with 2 programmers ! We got both BCSC(Myanmar) degrees. And one got MCAD certificate and another one pass 70-536 exam ! We believe that we can do the best for you ! Our best platform Mais

$650 USD in 15 dias
(16 Comentários)
3.3
VoltSmith

Dear Sir, I'd like to contribute in your demographic data conversion project. I have considerable experience in similar projects. I can send you a free demo for your reviewing. That would detect txt, csv, xls a Mais

$1500 USD in 21 dias
(1 Comentário)
3.0
phamdinhhuy

Please check my PM.

$700 USD in 20 dias
(3 Comentários)
2.6
oxygenboyz

Hello Sir / Madam We can help you for this project with this technology ! [url removed, login to view] 2.0 MSSQL 2000 or 2005 with 3-Tier Architecture ! So, Please give me some detail information for you project! We believe that you Mais

$800 USD in 20 dias
(1 Comentário)
0.0
matei

send me more details or contact at marius_i77@[url removed, login to view]

$1000 USD in 30 dias
(0 Comentários)
0.0
hmallaham1981

I'm professional in C,C++,.NET, VB, VBA, MS Office Applications , MSSQL Server 2003 & 2005, so please give me some detail information for your project. you conatct me via hmallaham@hotmail.com.

$450 USD in 15 dias
(0 Comentários)
0.0
mohammeddev

Please check your PM

$750 USD in 15 dias
(0 Comentários)
0.0
palpapjobsindia

Dear sir/Mam We have gone through your Project description and we are keen interested ,Palpap have smart experienced developer and testers. we have a strong background in telecom and educational domain for past 10 Mais

$1000 USD in 30 dias
(0 Comentários)
0.0
tirugroup

Hi..We have talented and professional team for creative and development in C,C++, VC++, ASP, Flash, .NET, VB, MS SQL, MS Access, Oracle. Give us a chance to show our Performance and we assure you for quality

$700 USD in 40 dias
(0 Comentários)
0.0
westinghao

Please see PMB, thanks

$1000 USD in 20 dias
(0 Comentários)
0.0