Quick CSV import with visual mapping

development, php, php classes Add comments

Several years ago I created PHP class Quick_CSV_Import to import CSV files to a database table very quickly (LOAD DATA INFILE statement). I found that the class became quite popular in India due to feedback received :]

Now I want to share a little application on the basis of that class.

Quick CSV Import with Mapping” is a PHP example application that imports CSV file to a database table with visual mapping of CSV columns to table columns.

CSV Mapping Master - click to download

Of course, you can get a copy of the application source – just go to the SVN repository.

Don’t forget to send me your feedback and donations ;]

P.S. If you are having problems with going to step 2 while using the app, try the following:

  1. Open Quick_CSV_import.class and find “LOAD DATA INFILE
  2. change it to “LOAD DATA LOCAL INFILE

It’s connected with permissions at your Linux server. Thanks to Noel for the solution.

156 Responses to “Quick CSV import with visual mapping”

  1. Rahul Says:

    I need To Know Is There Any Way To Set value for Field Name by default
    for an example i have a field in my table that is “list_id”
    i want to do that on index page there should be a text field where we can input a value and then after loading csv file of 100 records then it should also insert this record with list_id value which we have earlier set on index page so in this way for that 100 records my field => list_id value = should be the value we written on index page.
    I hope You Understand..If Any one can help me this

Leave a Reply

WP Theme & Icons by N.Design Studio
Entries RSS Comments RSS Log in