Project Detail

Description

What I need done:
I need a PHP class written to import a fixed format .xls file and store the contents inside a MySQL database (see attached files for phpinfo() and sample data).

Top Level Functionality
These functionality requirements all need to be able to be turned on/off from a config file

1. File Browser
a) Config file option to set path to server-side import folder
b) function that returns array(filename,date(datetime format), filesize (in a human readable format)) of files in server-side import folder (return success/errmsg)
c) function that accepts a filename variable (from (b) array) and deletes that file from the filesystem (return success/errmsg)
d) function to accept HTTP upload file into server-side directory for import (return success/errmsg)
e) example HTML form to submit d) successfully
f) uploaded file maybe a .xls or a .xls inside a .zip, if .zip, decompress and use .xls, discard .zip after import.

2. Database Import
a) Validate and encapsulate data in xls file to avoid import errors
b) Skip a few header rows of the xls file that are not consistent with the dataset
c) Import the xls file into the MySQL database
d) Remove all duplicate records
e) return an array with a summary of information (see note)

3. Database Import Tagging
a) Ability to set a variable in config file (4 chars integer)
b) Have a field in the Database where this constant is inserted in each row (it is being used as an account reference number in the larger project)
d) this should be called automatically during Database Import


** The "summary record set array" I would like
Basically a summary of what occurred during the import, something like
array() number of [imported records] [number of duplicates] [first record date] [last record date] [errors] etc.


What I already have versus what the provider will build:
I already have my CSS and larger function that wraps around this, so I require:
a) a PHP class that uses functions well (comments throughout code please)
b) an example HTML file for HTTP Upload
c) it to be compatible with the environment described in the attached php.ini file


Other context/requirements that providers will need to know:
See attached files for phpinfo() and example data.
At the conclusion, after payment is made, I will own the code and all rights pertaining to it.


Specific expertise that I am seeking:
An experienced PHP programmer that has this in their toolkit already and has an established profile within this community.


Timeframe for delivery:
Soon would be nice.


Additional files submitted:
phpinfo.pdf.zip
example_files.zip