Import csv file into existing DB
$250-750 USD
Paid on delivery
We have an existing system and DB with these tables:
claims
config
config_category
config_manufacture
config_products
config_products_bk_2
rma_clients
We need to manually import a csv or txt file into the DB, across a few tables.
CSV file will be in this format:
recipient-name
ship-address-1
ship-address-2
ship-city
ship-zip
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.
Thanks
Project ID: #1264951
About the project
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.