In Progress

Import data 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: free data enter, excel form enter data, db, data upload excel, data tables, php upload file csv, csv product import, php import project, excel random number, php random file name, excel required csv, excel file order form, txt file import excel, import excel data form, excel import txt, import data form excel, order form file upload, excel order system, system data file, random data, file name excel, excel data table, excel need bank, format file, excel input required

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

Project ID: #1265063

Awarded to:

chandlerbing

hi, I am sure I can give you a perfect functioning work.

$50 USD in 2 days
(72 Reviews)
6.0

18 freelancers are bidding on average $104 for this job

sikandermandal

Please see PMB.

$150 USD in 5 days
(22 Reviews)
6.0
chriskerpini

Please check PMB.

$170 USD in 6 days
(39 Reviews)
5.3
yehia111111

Hi Kindly check your PMB

$70 USD in 1 day
(4 Reviews)
3.8
kci

Hello, I've done this kind of project before, look no further, I'm your guy. I will send you more details.

$90 USD in 2 days
(2 Reviews)
3.5
Lauris79

Offer was sent in PM.

$120 USD in 2 days
(4 Reviews)
3.5
nelsonrocha

Ready to start. I have 12 years of experience in web development. Thank you.

$100 USD in 1 day
(2 Reviews)
2.8
fchakkara

Please check pm for details.

$30 USD in 2 days
(1 Review)
2.0
ViSoft

More than 10 year experienced programmer here...

$150 USD in 3 days
(0 Reviews)
0.0
SPcits2013

We have understood your requirements and we believe that we can accomplish the task. Please check your PM for more details.

$200 USD in 4 days
(0 Reviews)
0.0
Duminhtam

I developed an system can read txt, csv with easy GUI for admin to read,insert data and cron job. Contact me !

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

Please see pmb.

$100 USD in 5 days
(0 Reviews)
0.0
dombiistvan

It can be good first experience on this site, i want to create this. :)

$100 USD in 7 days
(0 Reviews)
0.0
iSTE

I think I can do this.

$50 USD in 5 days
(0 Reviews)
0.0
manh1028

I will make fastest for you

$50 USD in 2 days
(0 Reviews)
0.0
Emalek

see message

$50 USD in 1 day
(0 Reviews)
0.0
smbakhtiar

I am interested.

$40 USD in 2 days
(0 Reviews)
0.0
jelenat

please check PMB.

$100 USD in 1 day
(0 Reviews)
0.0