We are looking someone who can create a bespoke system for us with the following specification.
Currently we get a CSV file that has client’s data in such as name telephone numbers ect as per the screenshot below.
The column names and order can vary. Sometimes there may be 3 columns for telephone number, and they might appear directly after the client’s name. This CSV file would contain anywhere from 1,000, to 50,000 entries.
Our aim is to have one central location that we can upload these CSV files, have them get parsed and stored so that the next time we get another CSV file, it can be checked against all previous files easily.
The database will contain all previous entries from previous CSV files and will never be removed.
There needs to be 2 user levels, one that allows the employees to login and add new files, then one that allows the admin to login and see everything uploaded, statistics, logs ect ect.
Please see attached document.