Create Wizard to Convert Delimited file to SQL

Cerrado Publicado Feb 7, 2007 Pagado a la entrega
Cerrado Pagado a la entrega

This is the first stage to an ongoing project. My main objective is to test your skills as a coder/project planner.

This will be ongoing, future jobs can be sent as bonuses or private jobs.

I need a project that does the following:

I have a table that contains a number of fields. (Firstname, lastname, phonenumber, etc)

What I need is for a Web Based wizard to do the following

1- Upload the file

2- Attempt to determine the schema of the file (Explained future later)

3- If no match it will display uploaded data and have you select which fields match to the fields in the SQL table

4- Program should ask for a name to save the schema

5- Program will ask the SOURCE of the file (An updatable Drop Down box)

6- System will show records that are missing a phone1 field and warn that they will NOT be inserted

7- System will show ALL records to be inserted

8- Program will insert data into SQL table (Except for the skipped fields)

Things to be aware of:

1- Files will be of different formats, may be comma delimited, tab, etc. Files may also have text qualifiers or not.

2- When file is uploaded. System should attempt to match to a schema, if schema already exists, then it will notify user which schemia its using and preselect the fields in the next screen.

3- Next version will deal with other file formats such as excel, MS Access, etc

Basically this system should be a Web Based version of the IMPORT TEXT feature within MS ACCESS with the addition of the Matching the field names and Appending the data

## 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

ASP or ASPX

.NET Amazon Web Services ASP Ingeniería MySQL PHP Arquitectura de software Verificación de software SQL Web Hosting Gestión de páginas web Verificación de páginas web

Nº del proyecto: #2830922

Sobre el proyecto

15 propuestas Proyecto remoto Activo Feb 28, 2007

15 freelancers están ofertando un promedio de $135 por este trabajo

vladmik

See private message.

$59.5 USD en 3 días
(160 comentarios)
7.3
streamingguy

See private message.

$127.5 USD en 3 días
(294 comentarios)
7.1
denisvvw

See private message.

$255 USD en 3 días
(121 comentarios)
7.0
OpenSourceDev

See private message.

$425 USD en 3 días
(17 comentarios)
6.0
jawadh

See private message.

$42.5 USD en 3 días
(77 comentarios)
5.9
alex13vw

See private message.

$110.5 USD en 3 días
(48 comentarios)
5.2
fawkesvw

See private message.

$85 USD en 3 días
(22 comentarios)
4.9
ysrahmed

See private message.

$123.25 USD en 3 días
(54 comentarios)
4.8
alokeda

See private message.

$170 USD en 3 días
(12 comentarios)
4.9
jerry40

See private message.

$85 USD en 3 días
(18 comentarios)
4.6
projexpertvw

See private message.

$127.5 USD en 3 días
(21 comentarios)
4.8
alirazashaikhvw

See private message.

$85 USD en 3 días
(42 comentarios)
4.0
solankirahul

See private message.

$12.75 USD en 3 días
(8 comentarios)
1.0
shawpnendu

See private message.

$170 USD en 3 días
(2 comentarios)
0.0
nicostock

See private message.

$153 USD en 3 días
(0 comentarios)
0.0