Upload of my clients csv/excel to MYSQL Db via my site.
4701
£25/hr(approx. $31/hr)
- Posted:
- Proposals: 3
- Remote
- #75854
- Archived
Description
Experience Level: Expert
Some code here has been started, it just needs the finishing touch from you.
A current member (let's call him Joe) may have customers on his company db that he wants added to his admin area on our site. He wants them linked to him. So he would export his db to CSV or Tab deliminated or excel (or similar) and then would upload this file via our site to our MYSQL db (via the index.php, which along with the other pages will be included when you start the work to save time and money). So here is what is needed:
1. Allow Joe to upload a .csv file (or similar) using index.php (given to you when the job starts).
2. Check file size and allow only certain Mb size file (and include an other safety measures)
3. Insert into our MYSQL db.
4. The code then tries to map csv to our db fields and populate the dropdowns with the Joe's data. On the next page there's the manual mapping using populated dropdowns from the csv file.
5. Check all is OK and redirect to a confirmed page. If there is a problem alert if a problem and a solution of how to resolve.
6. Send automated email to those clients in Joe's db, add 'yes' to emailed field to show that the member has been emailed
That's pretty much it. There may be something else, we'll see. I'll provide a MYSQL data dump and code that has been started.
A current member (let's call him Joe) may have customers on his company db that he wants added to his admin area on our site. He wants them linked to him. So he would export his db to CSV or Tab deliminated or excel (or similar) and then would upload this file via our site to our MYSQL db (via the index.php, which along with the other pages will be included when you start the work to save time and money). So here is what is needed:
1. Allow Joe to upload a .csv file (or similar) using index.php (given to you when the job starts).
2. Check file size and allow only certain Mb size file (and include an other safety measures)
3. Insert into our MYSQL db.
4. The code then tries to map csv to our db fields and populate the dropdowns with the Joe's data. On the next page there's the manual mapping using populated dropdowns from the csv file.
5. Check all is OK and redirect to a confirmed page. If there is a problem alert if a problem and a solution of how to resolve.
6. Send automated email to those clients in Joe's db, add 'yes' to emailed field to show that the member has been emailed
That's pretty much it. There may be something else, we'll see. I'll provide a MYSQL data dump and code that has been started.
P C.
0% (0)Projects Completed
2
Freelancers worked with
2
Projects awarded
29%
Last project
18 May 2012
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