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.