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