In Progress

Excel into MySQL via PHP

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 [url removed, login to view] 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.

Skills: PHP

See more: excel mysql via php, php excel mysql, php mysql xls zip, importar excel para mysql via php, import xls mysql via php, upload excel mysql php, php import xls mysql, excel mysql php class, upload excel mysql, import excel mysql via php, class excel mysql php, php class excel mysql, excel mysql php, xls header, where is community set, what a php programmer should know, return path, programmer mysql, profile php code, php programmer other, need of excel programmer, human rights first, c versus c++, c++ programmer reference, excel import via php

About the Employer:
( 1 review ) ST KILDA SOUTH, Australia

Project ID: #241168

19 freelancers are bidding on average $177 for this job


Please see pmb

$175 USD in 7 days
(162 Reviews)

see pmb. thanks.

$250 USD in 5 days
(18 Reviews)

Please check PM.

$200 USD in 2 days
(142 Reviews)

Hi, I am intrested to do this job.

$250 USD in 3 days
(34 Reviews)

Hi, We would like to introduce ourselves as a company of professionals who are driven by the philosophy of customer satisfaction through QUALITY and INNOVATION. We specialize in web-related technologies and software de More

$175 USD in 6 days
(35 Reviews)

I can help you.

$200 USD in 10 days
(6 Reviews)

Hello, the import class is already done, other things you need isn't a problem

$100 USD in 3 days
(30 Reviews)

I'm interested in helping you on this project. Please check my PM.

$200 USD in 5 days
(10 Reviews)

Plz see pmb:))

$249 USD in 12 days
(2 Reviews)

Ready to start. Regards

$80 USD in 2 days
(4 Reviews)

We have understood your requirements from the project description and contents noted, We can develop your project perfectly as you are expecting. We can complete you project perfectly because 1). We are very well exper More

$150 USD in 5 days
(0 Reviews)

We will offer quality work of designing and full assistance in getting the website running on your server. We are well capable of accomplish it in fine tune. We will keep you updated about the progress of your proj More

$200 USD in 2 days
(0 Reviews)

We can do this very easily. Thanks

$75 USD in 5 days
(0 Reviews)

Yes, We can do it easily...we have already done to download mysql data in to excel format for one of our jobportal site.....we can do it...please contact us... regards, CEO,[url removed, login to view]

$250 USD in 2 days
(0 Reviews)

I can probably due this sooner.

$175 USD in 4 days
(0 Reviews)

We have done same kind of modules for our clients many time.

$150 USD in 5 days
(0 Reviews)

i can do it now so contact me

$30 USD in 1 day
(0 Reviews)

I have done this many times and can do it for you professionally.

$250 USD in 5 days
(0 Reviews)

Please check your PMB. Thanks

$200 USD in 7 days
(0 Reviews)