Em Andamento

Demographic Conversion Program

There are two parts to this VB.NET 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

Veja mais: program demographic data, ui conversion, sql data conversion, sql database program, simple program for vb.net, schema update, schema form, parts database example, parts database access, one tabs, data conversion sql, access parts database, visual studio excel, ui-date, types of report, xml conversion, translate manual, stored procedures, schema, Procedures, parsed, ne, mm, insert date, file conversion

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

ID do Projeto: #161355

22 freelancers estão ofertando em média $1020 para esse trabalho


Plz see the PMB. Thanks & Regards, CSSAGlobal

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

I can do it, please check PM.

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

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

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

I will send details in PM

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

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)

we can do it

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

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

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

Please check my PM.

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

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)

Please check your PM

$750 USD in 15 dias
(2 Comentários)

Please prove detailed info...

$1500 USD in 20 dias
(0 Comentários)

Please see PMB, thanks

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

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)

send me more details or contact at marius_i77@[login to view URL]

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

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)

Hello Sir / Madam We can help you for this project with this technology ! VB.net 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)

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)

Chinasourcing Website ([login to view URL]) is the portal website for China's outsourcing industry. The website is dedicated to establishing the industry chains of information release, transaction platform, industry ex Mais

$1500 USD in 20 dias
(0 Comentários)

I have understood the project .I can do this with highest quality and accuracy.

$1100 USD in 20 dias
(0 Comentários)

see PM please.

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