Fix/make fixed width import into MySQL(repost)
$30-100 USD
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.
Project ID: #3113345