## What I Need Done:
I need a PHP script that can loop through a text file, parse the fields and insert the data fields into MySql. This will be used to grab a text file from a website and merge the data into a database every month via a cron job. I currently don't have time to do this, as I'm working on another project. All I need is to build an array from the txt file.
## What Will Be Provided:
Attached to this project is the text file needed to parse. The file is very structured, but will require some creative regex.
## Data Fields Required:
The required fields to capture will be: DEALER#, Dealer_Name, Phone, Address, City, State, Zip, County, Owners, Reg, Exp, Big-Plts, Sml-Plts, Total-Plts, Units Sold 2007, 2007_New, 2007_Used, Units Sold 2006, 2006_New, 2006_Used, Units Sold 2005, 2005_New, 2005_Used.
## Specific Expertise:
Regular expressions, PHP, etc.
## Timeframe for Delivery:
Within 10 days or so. I'm flexible but want your commitment to the job.
## 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).
* * *This broadcast message was sent to all bidders on Friday Oct 12, 2007 8:33:07 PM:
Thank you for bidding. I am reviewing all bids and will make a decision within the next 24 hours. I appreciate your time. I have another regex project that I will post in a few days, involving text files. I hope to have your bid in the future. Thank you again. Regards Terry
## Platform
Linux or Windows. Apache server, PHP 4+