PHP Upload a data file to mysql
- or -
Post a project like this$$
- Posted:
- Proposals: 12
- Remote
- #171477
- Expired
Creative Website Design & Developement specialising in bespoke online solutions
City of London
Web Developer, CMS Specialist, SEO & Performance Optimization, Wordpress & Drupal
Aberdeen
58975140538151981160919172307234361255786266268332814338790345538349619
Description
Experience Level: Intermediate
Requirement outline
Skills needed PHP5/MYSQL/ AJAX
From a browser a user can upload multiple data files from their PC and then merge them to a single database. Data Format csv or xls /xlsx
Step 1 -Upload a data file, Import then map the fields
1. A user can upload multiple files – format csv or xls /xlsx
2. It has a progress bar (ajax)
3. Allow fields to be mapped to pre selected list of fields - Any fields not selected are reported before loading allowing a user to go back and select again if required.
Any fields not selected are always stored in a separate table and is linked by record ID. This is only used if outing the data to XL.
5. Loads the data in a MYSQL database
6. Drops the file into a grid – waiting for another file to be loaded or moving to step 2 Merging the data files together.
Step 2- Merge the files
Check box the files you want to merge – Select Merge. Data is merged on preselected fields and view the data in a grid. Output to XL – With option to include all fields or preselected fields.
Features
The user session is stored in a database so that the user can go back to there uploads at any point.
A user will name the session to identify it for future use.
Multiple uploads at the same time.
Please note - I will create some Power point visuals to show method of operation
Hope that’s enough for you to use
If you have done a project like this please let me know.
Regards
Frank
Via Steve
Skills needed PHP5/MYSQL/ AJAX
From a browser a user can upload multiple data files from their PC and then merge them to a single database. Data Format csv or xls /xlsx
Step 1 -Upload a data file, Import then map the fields
1. A user can upload multiple files – format csv or xls /xlsx
2. It has a progress bar (ajax)
3. Allow fields to be mapped to pre selected list of fields - Any fields not selected are reported before loading allowing a user to go back and select again if required.
Any fields not selected are always stored in a separate table and is linked by record ID. This is only used if outing the data to XL.
5. Loads the data in a MYSQL database
6. Drops the file into a grid – waiting for another file to be loaded or moving to step 2 Merging the data files together.
Step 2- Merge the files
Check box the files you want to merge – Select Merge. Data is merged on preselected fields and view the data in a grid. Output to XL – With option to include all fields or preselected fields.
Features
The user session is stored in a database so that the user can go back to there uploads at any point.
A user will name the session to identify it for future use.
Multiple uploads at the same time.
Please note - I will create some Power point visuals to show method of operation
Hope that’s enough for you to use
If you have done a project like this please let me know.
Regards
Frank
Via Steve
Sharp Cat C.
100% (74)Projects Completed
126
Freelancers worked with
79
Projects awarded
16%
Last project
30 Nov 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies