Project Detail
Export and import from MySQL to Excel and back
Export and import from MySQL to Excel and back is project number 427762
posted at Freelancer.com. Click here to post your own project.
Bid Count: 24
Average Bid:
$ 145
05/08/2009 at 9:18 EDT
Project Creator:
MetaMinds
Employer Rating: (No Feedback Yet)
Description
I would like a PHP script to be developed that will be able to export the data from a MySQL table (with product information from a webshop) to an Excel readable file. The data in this file must then be edited in Excel and via the same PHP script be inserted in the database again. Data that has been altered should be UPDATED (this can be done on basis of the unique ID of each entry). New data (= rows without an ID) that have been added to the Excel file should be treated as new products and therefore be INSERTED into the products table.This script is to be used for the users of a webshop, therefore it should be really easy to use and, most importantly, be FOOL-PROOF. The users of this script are to be regarded as novices with a basic knowledge of Excel at the most. This script is aimed at facilitating these users so they don’t have to update or insert their products using the much slower backend of their webshop.
Requirements:
- Im- and exporting of the file should be fool-proof, preferably containing no extra steps besides downloading the file, opening and editing it with Excel and then importing it again. If any extra steps are needed (e.g. ‘Save as… XML data’ to save the data properly from within Excel) than this should be *clearly* mentioned, including how to do it.
- Importing a file that has the wrong file format MUST NOT in any way corrupt the table with products. If the users attempts such a thing, a clear error explaining the problem should be given to the user.
- Excel file should be able to be edited and saved in the correct format using both Excel 2003 and 2007. (And earlier Excel versions if possible, though not mandatory.)
Things to keep in mind:
- The users might work with both US/English versions of Excel as well as other localized versions, where prices are not stored using periods, but with comma’s. Prices are stored as FLOATS in the database however, so keep this in mind when importing.
- Also keep in mind that the description field (called ‘omschrijving’ in the example SQL file) can contain just about any character, including non space characters like tabs and line breaks and also characters like semi colons and HTML code in general. I’m telling you this because this is the main problem I faced myself when trying to build this script myself on the basis of CSV files.
End result should be a PHP file with an accompanying HTML file with a form for exporting (e.g. downloading) and importing the Excel compatible file.
Attached is an export of a products table as an example to work and test with.
Additional files submitted:
producten.sql
|
Job Type |
|
Provider Rating
WHAT IS FREELANCER.COM?
Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!
We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started!
Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.
- Plendo Sweden AB © 2004-2009
- PRIVACY POLICY
- TERMS
- AFFILIATES
- API
- QUOTES
- CONTACT
Freelancer™ is a trademark of Ignition Networks Pty Limited (ACN 134 845 748)
Newly Outsourced Projects fed by 
Follow our Freelance Jobs on Twitter 
Add to your
Google search results
Audio & Music Software * Webmaster Resources * Webmaster Forum