Project Detail

Excel into MySQL via PHP  

Excel into MySQL via PHP is project number 241168
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: vladim1

Budget: $30-250

Created: 04/28/2008 at 13:59 UTC

Bid Count: 19

Average Bid:
$ 177

05/03/2008 at 13:59 UTC

Project Creator: bitter
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (1 reviews)

Bid On This Project
 

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

Messages Posted:2 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

175

7 days

03-24-2008 10:35 UTC

Please see pmb

help

 

175

6 days

03-24-2008 10:50 UTC

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 development, 2D and 3D modeling and animation. Why 6STech? " Use of our tried and tested techniques to deliver what you want as per your expectations. " Really quick turnaround time " We are available on AIM, YAHOO messenger , MSN messenger, Skype, GoogleTalk , Phone, Email ... Looking forward for favorable reply. Thank you & Regards, 6STech Team

help

 

250

5 days

03-24-2008 14:00 UTC

see pmb. thanks.

help

 

200

2 days

03-24-2008 11:00 UTC

Please check PM.

help

 

250

3 days

03-24-2008 11:31 UTC

Hi, I am intrested to do this job.

help

 

200

10 days

03-24-2008 09:48 UTC

I can help you.

help

 

200

5 days

03-28-2008 12:28 UTC

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

help

 

249

12 days

03-24-2008 11:45 UTC

Plz see pmb:))

help

 

100

3 days

04-29-2008 09:50 UTC

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

help

 

200

2 days

03-24-2008 10:25 UTC

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 project by hosting it on our web server. Also please let us know if further clarification is due on our part regarding our bid. We will be be more than pleased to hear beck from you We look forward to a great association with you... Best Regards, CEO URMAN SOFT

help

 

200

7 days

04-29-2008 00:28 UTC

Please check your PMB. Thanks

help

 

150

5 days

03-24-2008 11:42 UTC

(No Feedback Yet)

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 experianced software and web applications developers from INDIA using PHP, MYSQL, ASP.NET, VB.NET, C#.NET, MSACCESS, MSSQL, Script languages and web designing tools. 2). We can update the project development everyday. 3). We can communicate you through yahoo, skype and hotmail daily which will enable us to give a best product. 4). If any doubts or details required please contact us through GAF PMB. 5). Expecting you favourable reply. Thanks

help

 

80

2 days

03-24-2008 14:16 UTC

(No Feedback Yet)

Ready to start. Regards

help

 

75

5 days

03-24-2008 14:28 UTC

(No Feedback Yet)

We can do this very easily. Thanks

help

 

250

2 days

03-24-2008 15:23 UTC

(No Feedback Yet)

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,Zeeways.com

help

 

175

4 days

03-24-2008 21:52 UTC

(No Feedback Yet)

I can probably due this sooner.

help

 

150

5 days

03-25-2008 13:25 UTC

(No Feedback Yet)

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

help

 

30

1 day

03-26-2008 19:56 UTC

(No Feedback Yet)

i can do it now so contact me

help

 

250

5 days

04-28-2008 18:19 UTC

(No Feedback Yet)

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

help


    Bid on this Project