Käynnissä

Export and import from MySQL to Excel and back

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.

Taidot: PHP

Näytä lisää: import mysql excel, mysql import excel, script php export import database mysql, export data mysql excel, xml data entry form, well regarded, us basic english test, prices for editing, php to excel export, on line data entry test, m format in excel, import csv into mysql php script, format prices, excel data entry form 2007, editing prices, data entry in excel 2007, data entry form without excel, data entry form php mysql, data entry form excel 2003, corrupt excel file, mysql table excel, export sql excel english php script, import mysql 0fees, import excel file mysql export using php, exportar mysql excel desde

About the Employer:
( 0 reviews ) Haarlem, Netherlands

Projektin tunnus: #427762

Myönnetty käyttäjälle:

ambar

Please check my private message.

110 $ USD 10 päivässä
(76 arvostelua)
7.2

24 freelanceria on tarjonnut keskimäärin 145 $ tähän työhön

SigmaVisual

We can help in your project, please check PMB to see our related experience.

200 $ USD 3 päivässä
(219 arvostelua)
7.7
BestWeb4U

I am a expert - professional with an experience of 9 years in making website designs, graphic designs, logo designs, banner, flash,OSCommerce, Joomla + Virtualmart, X-Cart, DotnetNuke, PHP/Mysql, ASP, ASP.Net, Smarty, Lisää

250 $ USD 5 päivässä
(148 arvostelua)
7.4
TechVillage

Please check PM.

225 $ USD 5 päivässä
(86 arvostelua)
6.6
skywalker65535

please see pmb

160 $ USD 2 päivässä
(28 arvostelua)
6.3
consus

Hello Sir Please Check PMB for bid detail. Thanks

150 $ USD 5 päivässä
(18 arvostelua)
6.2
jacekphp

Hello, I'm very experienced web developer with appropriate knowledge needed in that project. I've done similar extension in one of shops I created. I propose you solution based on .xls(excel format) files, instead Lisää

200 $ USD 2 päivässä
(14 arvostelua)
6.2
utpal4job

Hello, I can do this project. Please refer PMB. Regards, Utpal.

180 $ USD 3 päivässä
(64 arvostelua)
5.9
mirod

Hello, please check PMB

250 $ USD 3 päivässä
(34 arvostelua)
5.7
saulwilliams

Hi, I have strong knowledge and extensive experience in [url removed, login to view] check PMB to see my past experience. Regards, Williams

80 $ USD 1 päivässä
(23 arvostelua)
5.0
developersourav

Let us start.

100 $ USD 4 päivässä
(12 arvostelua)
4.8
kimma

Hello. I am ready to start. Thanks

100 $ USD 1 päivässä
(10 arvostelua)
5.3
hanssvane

I can do it during the week end and have it reado by monday, the charset conversion is no problem please let me know so I can begin. Hans

150 $ USD 2 päivässä
(13 arvostelua)
4.3
msgaruba

please read pmb

65 $ USD 1 päivässä
(13 arvostelua)
4.2
NashTrump

Hi, I am an expert VBA, Excel, Database, Mysql, Website scraper, Data extraction and Automation expert.I have over 11 years experience in the above categories and would like very much to have the opportunity to work Lisää

120 $ USD 0 päivässä
(1 arvostelu)
3.2
shabbs

Hi i am Shabbir Hussain, We are a group of Consultants, Software Engineers and Other Expert Freelancers having exp. of more than 6+yrs in IT industry with internet technologies and database systems(Expertiese With CMS) Lisää

100 $ USD 10 päivässä
(0 arvostelua)
0.0
vishaltalwar

Can complete the job in 10 hours @20/HR.

200 $ USD 5 päivässä
(0 arvostelua)
0.0
Pinnaclets

We are a group of developers with a minimum of 5 years experience in .NET and [url removed, login to view] can handle this job very well.

250 $ USD 10 päivässä
(0 arvostelua)
0.0
zimah1503

wanna see my data base? visit [url removed, login to view] username: azimah pass: azimah let me do this job.. thanks, Arisyi

40 $ USD 1 päivässä
(0 arvostelua)
0.0
cressettexh

Hi, I have 3+ year expriance in php/mysql/ajax/jquery. i work this type of job as you [url removed, login to view] you wrote that you can't select any diff. step . there is localisation change only date foemat is diff in excel i can han Lisää

200 $ USD 5 päivässä
(0 arvostelua)
0.0
php85market

Ready to do

90 $ USD 5 päivässä
(0 arvostelua)
0.0