Excel upload and sql conversion
This project was awarded to leomedina01 for $40 USD.Get free quotes for a project like this
Project Budget$30 - $250 USD
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online