Cancelled

Import csv file into existing DB

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

Skills: Excel, MySQL, PHP, Software Architecture, SQL

See more: order form format in excel, import excel, import csv, db, csv, csv php, csv import, csv file, c# import excel, c import excel, php upload file csv, csv product import, php import project, excel random number, csv form, php random file name, php table csv, php excel csv, excel required csv, excel file order form, txt file import excel, excel import txt, order form file upload, excel order system, table csv

About the Employer:
( 83 reviews ) Eghm, United Kingdom

Project ID: #1264951

12 freelancers are bidding on average $250 for this job

netxpertindia

NetXpertIndia is a customer-specific service oriented company has got a Professional and creative team. We are the Professional Web Development Company having rich experience in Web design and development. Our team can More

$250 USD in 2 days
(88 Reviews)
6.8
gangabass

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

$250 USD in 1 day
(165 Reviews)
6.1
eXternalDesign

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

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

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

$250 USD in 5 days
(23 Reviews)
6.0
MustafaSR

Hello Sir, Please check the PMB

$250 USD in 3 days
(79 Reviews)
5.8
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
PauloSam

Hello, i'm ready to start work.

$250 USD in 5 days
(44 Reviews)
5.4
mdkass

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

$250 USD in 7 days
(53 Reviews)
5.3
DamithaKD

Read pm sir :)

$250 USD in 5 days
(13 Reviews)
4.3
shahmit27

Hi, I am interested to do this job, let to start. Thanks

$250 USD in 2 days
(8 Reviews)
4.3
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