CSV Field Mapping GUI

Possible implementations of what you ask for include

Quick CSV import with visual mapping

This a full implementation with a visual mapping, though it isn't themed like your picture. An example of usage is avaliable here
jQuery csv2table

This is a partial implementation it converts csv to a html table data. The remaining part would be to convert the generated table to SQL with a visual mapping

The following items are PHP partial implementations that map csv to sql without providing a visual mapping to the user.

Sometimes reinventing the wheel is good, you get what you need, and what you need only

This seems easy, first you need a csv kinda parser, but that's just too easy you can do something like:

Your task may be break down in:

1.- Import the csv : (Build an upload form, handle file extension validation.

2.- Store the csv somewhere temporarily (Store file, probably with hash instead of name so no conflicts exist

3.- Parse the csv. (http://php.net/manual/en/function.fgetcsv.php will be your friend)

4.- Two input fields, one for the parsed files and one for your map, use some sessions/javascript fancyness for adding the right columns on the fly

5.- Then store the mapped columns to real csv values.

Related