Fix/make fixed width import into MySQL(repost)

Completed Posted Jan 22, 2010 Paid on delivery
Completed Paid on delivery

I have a fixed width file with about 3.1 million rows that I want inserted in MySQL. I have a PHP script that uses INFILE already that I have made. It works ok but not as good as I'd like. What I want is for someone to make the script so that the data gets inserted correctly with one of the columns having an index. Also to download the file from the host site using FTP and unzip it before putting it into the database.

Or make a different PHP script to do the same thing.

I would like the script to do all of the automatically every day at 1:00 AM or thereabouts using cronjobs or some other method.

I have included several files:

An example dat of the format

An information pdf that explains format/widths, etc. (see Appendix 1 in this file)

An SQL file that has the currect table structure

And the script I am currectly using.

Engineering MySQL PHP Project Management Software Architecture Software Testing Web Hosting Website Management Website Testing

Project ID: #3113345

About the project

7 proposals Remote project Active Feb 4, 2010

Awarded to:

rnapen

See private message.

$17 USD in 3 days
(0 Reviews)
0.5

7 freelancers are bidding on average $67 for this job

ubunto

See private message.

$127.5 USD in 3 days
(73 Reviews)
4.9
araja

See private message.

$85 USD in 3 days
(47 Reviews)
4.8
lymasoc

See private message.

$51 USD in 3 days
(17 Reviews)
3.3
kanhashriinc

See private message.

$85 USD in 3 days
(8 Reviews)
2.7
schz

See private message.

$59.5 USD in 3 days
(4 Reviews)
2.6
smdcoder

See private message.

$42.5 USD in 3 days
(0 Reviews)
0.0