Need some work done? Post a Project Today
We need a PHP written data migration tool which will transfer the contents of a CSV file / excel spreadsheet to a mysql database.
It will be required to allow for CSV column to MYSQL Table / Field mapping and where a table has no match be able to write it to a custom fields directory.
The structure of the MYSQL Database is already determined including the CUSTOM_FIELDS table.
What will be random is the CSV files column structure, which is why we require the opportunity to map the columns to the MYSQL Fields before the Import takes place.
The Data Mapping will assume it is writing the CSV file to a single table however the table will need to be selectable from the Database.
The interface will need somewhere to fill in the MYSQL DB's Host address, Username, Password and DB Name.
If you're interested could you please reply with a mock up of how you would put the interface together.
I will not share your design with others it is just how I'll evaluate your understanding of the requirement.
Please let me know if you have any further questions.
Many Thanks in advance. I appreciate your response.