CSV to MySQL processing

We require a web app that will accept a CSV file containing data, and process that CSV file deleting and adding records to a MySQL database. There is only a single CSV file and only modifying a single table in the database. There is further work that will be required in the future if we are happy with this project. ## Deliverables We use CSV records of employee information which we require to be inserted into a MySQL table so another system can connect to that data. We require the following: - Web interface. Simple design using basic CSS is fine. Will only be used by administrators. - Ability to upload the CSV file OR specify a location of the CSV file - If a location of the CSV is specified, the ability to add a cron job to run this at intervals - CSV file contains records with commas, these are enclosed in "" by excel. These must be removed when added to MySQL table (see [login to view URL] file for example of record with comma enclosed in "") - Before new records added to MySQL table, all records should be dropped so it starts fresh using the CSV file - If table doesn't exist in db, create the table - All rows in the CSV are added as records in the SQL table - Ability to modify the database connection information (in case it changes in the future) eg. location of database server, db name, db user, db password and table name to modify. I have attached files inside zip as described below: [login to view URL] - sample csv file [login to view URL] - model of database table and required fields Contact me for further information.