Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

$100 - PHP script: CSV files into MySQL
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.


Job awarded.

Nov 29, 2012

Job Description

  |  Change History >>


  • Posted: Wed, Nov 28, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

I. Background:

I have 1200 CSV files in a folder.
Each file has between 1000 to 5000 rows of data.
The first row in each file is the header.

While some of the header items are common across all files, many are not. And even when they are common, they do not necessarily appear in the same order.

II. What I want:

[I will create a MySQL database with one table named 'tbl_csv' in it.]

I want two PHP scripts:

(a) A configuration script, where I should be able to add:
- The database connection string
- Name of the db table
- Path to the directory where the CSV files are stored
- Any other info necessary to run the main script

(b) The main script, which should do the following:

1. Scan through one CSV file at a time
- Create a new column in 'tbl_csv' for each new header item in the CSV files (csv header name = db column name)

2. Scan through the CSV files again, one file at a time
- Insert the data under each header into the appropriate column in the database


Sign in or Register to see more

Desired Skills
MySQL Administration, PHP
Job ID: 35589253
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Spain  |  
I have been developing software and webs since 12 years now. I am a enthusiatic and reliable programmer.
 0.0   |  Private   |  0 Jobs
Bid ID: 35652792  |  Submitted: Nov 30, 2012 17:59 ET 
Proposal SEALED

 Egypt  |  
6+ years of PHP programming , MySQL databases creation and maintaining , Web Scraping and Data Minning ,HTML design, CSS and Javascript. Skills: -...
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 35591966  |  Submitted: Nov 28, 2012 17:44 ET 
Proposal SEALED

 United States  |  
I have been programming for over 20 years.
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 35591566  |  Submitted: Nov 28, 2012 17:25 ET 
Proposal SEALED

 Austria  |  
Expertise in programming languages and frameworks (C# NET, VB.NET, C/C++, Java, PHP, Python, HTML/Javascript, ...), eCommerce (Amazon, eBay,...
 5.0   |  Private   |  8 Jobs
Bid ID: 35589607  |  Submitted: Nov 28, 2012 15:59 ET 
Proposal SEALED

 Pakistan  |  
Always committed/responsible with our work because we always provide the fast and reliable solution to our clients.we are small experienced...
 4.8   |  $2,382 Earnings   |  37 Jobs
Bid ID: 35589581  |  Submitted: Nov 28, 2012 15:58 ET 
Proposal SEALED

One or more team members at  are verified.  Learn More
 Ukraine  |  
We're a young company from Ukraine providing professional web programming outsourcing services. Our main approach is customer's satisfaction of...
 5.0   |  Private   |  14 Jobs   |  1 verified credential(s)
Bid ID: 35589489  |  Submitted: Nov 28, 2012 15:55 ET 
Within 1 week
Elance is now an Upwork company.
Upwork is the choice of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »