Import 2 CSV files into MySQL
$30-250 USD
Paid on delivery
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.
Project ID: #584664
About the project
Awarded to:
26 freelancers are bidding on average $74 for this job
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
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
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.
I have already done a similar task and can do this one easily. Select me to get it done within next 24 hours.
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 More