We have an existing system and DB with these tables:
We need to manually import a csv or txt file into the DB, across a few tables.
CSV file will be in this format:
Also needs to input random date within last 6 months, weekdays only and also has to exclude bank holidays (Can supply these dates in another table if required)
Needs to select a random product from the config_products table
Needs to select a random quantity, 90% of the time it is 1, 9% of the time it is 2, 1% of the time it is 3.
Need to input random number into Order ID field, 8 characters.
We need a form to upload the file and a confirmation of the number of records which have been inserted successfully.
If you are able to complete this project please feel free to enter a bid.