Em Andamento

Import 2 CSV files into MySQL

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.

Habilidades: PHP

Ver mais: 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

Acerca do Empregador:
( 13 comentários ) Johannesburg, South Africa

ID do Projeto: #584664

Premiar a:

DesignSolutionSW

Please check PM.Thanks.

$30 USD em 2 dias
(58 Avaliações)
7.0

26 freelancers estão ofertando em média $74 para este trabalho

soner

Ready to work with you. Please contact.

$160 USD in 0 dias
(120 Comentários)
7.9
toinnisfree

quick pro help. ftp and escrow required.

$200 USD in 4 dias
(535 Comentários)
7.9
phpexp

Please check the PMB. Ready to start right now

$35 USD em 1 dia
(169 Comentários)
7.8
SigmaVisual

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

$200 USD in 3 dias
(226 Comentários)
7.8
Shalena29

will be done

$158 USD in 2 dias
(98 Comentários)
6.8
phil999

please check pm

$60 USD em 1 dia
(5 Comentários)
5.5
festsoft

Please see PM. David Johnson, Durham, England

$45 USD in 2 dias
(16 Comentários)
4.9
JesseLin

Ready to get started.

$30 USD em 1 dia
(13 Comentários)
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 em 1 dia
(8 Comentários)
3.7
kcmakwana

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

$45 USD em 1 dia
(7 Comentários)
3.3
wmbhs

hello , you can see my personal site at : [url removed, login to view], thanks

$70 USD em 1 dia
(1 Comentário)
3.2
venkii1

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

$30 USD in 3 dias
(4 Comentários)
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 Mais

$90 USD in 2 dias
(3 Comentários)
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 em 1 dia
(2 Comentários)
1.9
tomj

Please check PM!

$50 USD in 2 dias
(2 Comentários)
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 em 1 dia
(2 Comentários)
1.0
employteam

Hi We can do this for you. We have similar experience. Give us a chance to prove ourselves. Regards, Nani

$40 USD em 1 dia
(0 Comentários)
0.0
ndeztea

hi, please check PM

$30 USD em 1 dia
(0 Comentários)
2.0
perfaction

i can make sure what you need

$60 USD em 1 dia
(0 Comentários)
0.0
barbarashen

Dear Sir/Madam, ChinaService is formed by Chinese and international enterprises providing BPO / KPO / IPO offshore/outsourcing services to China to lower cost and achieve higher returns. China is rapidly becoming a Mais

$200 USD in 7 dias
(0 Comentários)
0.0