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

Tietoa työnantajasta:
( 0 arvostelua ) 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 %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% 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 [login to view URL] 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 [login to view URL] can handle this job very well.

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

wanna see my data base? visit [login to view URL] 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 [login to view URL] 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