Import 2 CSV files into MySQL

Closed

There are 2 files (with different layouts) that must be imported into a MySQL Database.

1. PHP5 Must be used.

2. The coding must be procedural and easy to understand/read

The functionality will be as follows:

1. Let user browse for file on his local hard drive

2. Check that the file is in the correct format.

3. Import the file into MySQL checking that the record being imported doesn't already exist in MySQL.

Other information:

The Structure of the MySQL Table (BANK) is attached. ([url removed, login to view])

Samples of the 2 files to be imported are attached:

[url removed, login to view] - Rules for Import:

Field Content to be filled with:

----- --------------------------

bank CC

date To be extracted from the Settlement Date field

description To me made up of "Reference"+"Email Address"+"Name"

amount To be taken from "ZAR"

balance Leave Blank

account Leave Blank

id Leave - AutoIncrement

Record only to be imported if the Settlement Date is given - if this field is blank, the record must not be imported.

[url removed, login to view] - Rules for Import:

Field Content to be filled with:

----- --------------------------

bank CL

date To be extracted from "Date"

description To be extracted from "Description"

amount To be extracted from "Amount"

balance To be extracted from "Balance"

account Leave Blank

id Leave - AutoIncrement

I use Skype to communicate.

This is a very small and simple project, we expect to accept the lowest bid.

Skills: PHP

See more: gif to txt, correct email address, correct email format, attached files, zar, simple csv, import mysql, import database, import csv, files email, csv, csv php, csv import, correct csv, mysql read files, mysql database import, php import project, mysql structure, mysql content, read structure file, php table csv, coding mysql, quot email address quot, php read txt, skype mysql php

Project ID: #584664

Awarded to:

DesignSolutionSW

Please check PM.Thanks.

$30 USD in 2 days
(58 Reviews)
7.0

26 freelancers are bidding on average $74 for this job

soner

Ready to work with you. Please contact.

$160 USD in 0 days
(120 Reviews)
7.9
toinnisfree

quick pro help. ftp and escrow required.

$200 USD in 4 days
(535 Reviews)
7.9
phpexp

Please check the PMB. Ready to start right now

$35 USD in 1 day
(169 Reviews)
7.8
SigmaVisual

We can help in your project, please check PMB to see our related experience.

$200 USD in 3 days
(226 Reviews)
7.8
Shalena29

will be done

$158 USD in 2 days
(98 Reviews)
6.8
phil999

please check pm

$60 USD in 1 day
(5 Reviews)
5.5
festsoft

Please see PM. David Johnson, Durham, England

$45 USD in 2 days
(16 Reviews)
4.9
JesseLin

Ready to get started.

$30 USD in 1 day
(13 Reviews)
4.0
mmysoft

Hi you, Let do it effectively I have read your requirements carefully, so that I would like to join into this project. Based on my experience, I believe that we will reach the best results. Thanks you so much

$40 USD in 1 day
(8 Reviews)
3.7
kcmakwana

we can do this in less than one day,see inboX pls

$45 USD in 1 day
(7 Reviews)
3.3
wmbhs

hello , you can see my personal site at : www.wassimbhs.123.fr, thanks

$70 USD in 1 day
(1 Review)
3.2
venkii1

Hi, I can work on this project. Thanks. Venky

$30 USD in 3 days
(4 Reviews)
3.1
samarthinfotech

Hello Sir, I would like to work for you. We have created such sites. We have good number of teams including designers and developers. Please give us chance to explore ourselves. Please check our portfolio on our More

$90 USD in 2 days
(3 Reviews)
2.7
libdanz

Hi I have seen your requirements. Its a 30 minutes job. Look at the projects I have won...they all have to do with importing CSV into MySQL Database. I hope to hear from you soon.

$40 USD in 1 day
(2 Reviews)
1.9
tomj

Please check PM!

$50 USD in 2 days
(2 Reviews)
1.9
atifmajid

I have already done a similar task and can do this one easily. Select me to get it done within next 24 hours.

$50 USD in 1 day
(2 Reviews)
1.0
ndeztea

hi, please check PM

$30 USD in 1 day
(0 Reviews)
2.0
monalizz

As the work is very small i would take only 1 day to complete.

$30 USD in 1 day
(0 Reviews)
0.0
perfaction

i can make sure what you need

$60 USD in 1 day
(0 Reviews)
0.0
vbsoft66

All done see demo at http://activation.webnika.com/demo/import.php

$50 USD in 1 day
(0 Reviews)
0.0