Closed

Excel upload and sql conversion

This project was awarded to leomedina01 for $40 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project 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.

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