Import csv file into existing DB

Cancelled Posted Oct 26, 2011 Paid on delivery
Cancelled 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

Excel MySQL PHP Software Architecture SQL

Project ID: #1264951

About the project

12 proposals Remote project Active Oct 26, 2011

12 freelancers are bidding on average $250 for this job

gangabass

I can do this for you. See PM for details.

$250 USD in 1 day
(418 Reviews)
7.2
DamithaKD

Read pm sir :)

$250 USD in 5 days
(19 Reviews)
6.3
mdkass

Hello, I have good experience with csv Import/export operations. Regards.

$250 USD in 7 days
(86 Reviews)
6.0
stdhtelkom

Hi, I am interested. Please check pmb. Thanks, Steve

$250 USD in 5 days
(33 Reviews)
6.1
GuruDeveloper

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.

$250 USD in 1 day
(21 Reviews)
5.6
MustafaSR

Hello Sir, Please check the PMB

$250 USD in 3 days
(90 Reviews)
5.8
PauloSam

Hello, i'm ready to start work.

$250 USD in 5 days
(43 Reviews)
5.4
eXternalDesign

Hi, I'm interested and able to start right away. Kind Regards, Jay

$250 USD in 5 days
(45 Reviews)
6.2
dilelluca

I've worked many years in sql and php. I work daily as consultant in a software enterprise so i'm used to delivery my works on time. My code is written following the standard code convention and is fully commented. More

$250 USD in 3 days
(0 Reviews)
0.0
jelenat

Please check PMB.

$250 USD in 1 day
(0 Reviews)
0.0
ViSoft

We have done something like this before...

$250 USD in 3 days
(0 Reviews)
0.0