Completed

Import 2 CSV files into MySQL

This project was successfully completed by DesignSolutionSW for $30 USD in 2 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$30 - $250 USD
Completed In
2 days
Total Bids
26
Project Description

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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online