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.
12 freelancers are bidding on average $250 for this job
If you would accept perl script without web interface (to be run from command line interface) then i could deliver it cheaper ($199) and faster (1 day) then others :) Payment upon complition.