Excel upload and sql conversion

  • Status Closed
  • Budget $30 - $250 USD
  • Total Bids 8

Project Description

Before reading: I have no idea of how much this could cost, but this project will be realized only if cheap. It's not very important for me.

I need a php page that:

1) Has a form with:

--- a. "Name:" text field;

--- b. button to choose a xls or xlsx files from user device;

--- c. button to choose a zip file containing images.

2) Checks the xls or xlsx file to have some specified columns (i.e: "IdColumn", "ColumnTwo", "ColumnThree", "ColumnFour");

3) Convert and insert the excel to SQL database, in a table calles like "Name" (see point 1.a);

4) Creates a folder called "Name" in with the images are unzipped;

5) Images will be called like the value from "IdColumn" + .jpg from excel file. Their absolute address has be saved into a new SQL column ("ColumnFive");

6) I can get a json of this sql table somewhere;

7) after a specified amount of time (for example three hours) everything is deleted.

Get free quotes for a project like this
Awarded to:

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