Closed

CSV Importer Needs Built

This project was awarded to siddhu1986 for $50 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30-$250 USD
Total Bids
26
Project Description

We need a PHP file the lets up upload a comma delimited CSV file and import specific fields of data into a different tables in a MySQL database and create the unique ids between the Business table and the deal table.

The following are the fields and what they import into.
CSV_FIELD => TABLE => FIELD

NAME => DEAL => NAME
START_DATE => DEAL => START_DATE
END_DATE => DEAL => END_DATE
IMAGE_URL => DEAL => IMAGE_URL
PRICE => DEAL => PRICE
VALUE => DEAL => VALUE
DISCOUNT => DEAL => DISCOUNT
VOUCHER_EXPIRATION_DATE => DEAL => EXPIRE
DEATAILS_TEXT => DEAL => DESCRIPTION
FINE_PRINT_TEXT => DEAL => FINE_PRINT

The following needs to be checked if its in the table and added if not on each import:
MERCHANT_NAME => COMPANY => NAME

The following needs to be added to database if the above is added:
Table => Field => Value
COMPANY => EMAIL => (MERCHANT_NAME)@[url removed, login to view]
COMPANY => PASSWORD => password1
COMPANY => COUNTRY => UNITED STATES
COMPANY => STATE => Missouri
COMPANY => CITY => National

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