Create Wizard to Convert Delimited file to SQL

Closed Posted Feb 7, 2007 Paid on delivery
Closed Paid on delivery

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 Engineering MySQL PHP Software Architecture Software Testing SQL Web Hosting Website Management Website Testing

Project ID: #2830922

About the project

15 proposals Remote project Active Feb 28, 2007

15 freelancers are bidding on average $135 for this job

vladmik

See private message.

$59.5 USD in 3 days
(160 Reviews)
7.3
streamingguy

See private message.

$127.5 USD in 3 days
(294 Reviews)
7.1
denisvvw

See private message.

$255 USD in 3 days
(121 Reviews)
7.0
OpenSourceDev

See private message.

$425 USD in 3 days
(17 Reviews)
6.0
jawadh

See private message.

$42.5 USD in 3 days
(77 Reviews)
5.9
alex13vw

See private message.

$110.5 USD in 3 days
(48 Reviews)
5.2
fawkesvw

See private message.

$85 USD in 3 days
(22 Reviews)
4.9
ysrahmed

See private message.

$123.25 USD in 3 days
(54 Reviews)
4.8
alokeda

See private message.

$170 USD in 3 days
(12 Reviews)
4.9
jerry40

See private message.

$85 USD in 3 days
(18 Reviews)
4.6
projexpertvw

See private message.

$127.5 USD in 3 days
(21 Reviews)
4.8
alirazashaikhvw

See private message.

$85 USD in 3 days
(42 Reviews)
4.0
solankirahul

See private message.

$12.75 USD in 3 days
(8 Reviews)
1.0
shawpnendu

See private message.

$170 USD in 3 days
(2 Reviews)
0.0
nicostock

See private message.

$153 USD in 3 days
(0 Reviews)
0.0