In Progress

Import XML file into Mysql Database with php or python

Provide a modular command line PHP or python tool (script/s) that parses an XML file (example of structure attached) containing a list of approximately 4500 products with details from one of our vendors and update a Mysql database based on the following rules.

a) if the product does not exist in the database then insert the full record

b) if the product exists and there are no changes then ignore the record

c) if the product exists and one or more of the details have changed, then update the changed fields only. Do not update the entire record.

d) If the product is in the database but not in the XML file delete the record

The item to field mappings will be provided prior to the start of the work.

Deliverables:

1) Tool to import / update / delete records in mysql database from XML based upon above rules.

2) Tool can be written in either PHP or Python.

3) Provide source code for all components that go together to create import tool

4) if tool is made of multiple components all scripts to be contained within a logical directory structure

Happy to answer any questions about the project prior to start.

Skills: MySQL, PHP, Python, XML

See more: python import xml mysql, python logical and, d python, database scripts with php and mysql, python 3, one line php, import XML, php xml delete, together mysql, import xml file mysql database php, script update database mysql, mysql database import, mysql insert multiple records, insert multiple records, mysql multiple insert, php insert xml, update mysql xml, project 4500, xml import mysql php, import tool, php list file directory, mysql xml update, php mysql import script, python create xml file, python create file

About the Employer:
( 22 reviews ) Balmain, Singapore

Project ID: #5290929

Awarded to:

robinsjp

Hi, I work as a project manager in an online retail firm, and I've written several PHP scripts of this nature. I know how optimise insert/update statements for speed (if you process the data line by kind of blindly More

$155 SGD in 0 days
(2 Reviews)
2.0

38 freelancers are bidding on average $215 for this job

toinnisfree

I have read your project details, and I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work. Milestone is required to begin; to be released when the job has been satisfactor More

$500 SGD in 7 days
(596 Reviews)
8.0
SigmaVisual

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of our experience: Amazon/Ebay Bots: [url removed, login to view] More

$144 SGD in 3 days
(251 Reviews)
7.9
rajeshsonisl

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 !!)... you can never go wrong choosing me :) I look forward to your reply. More

$927 SGD in 2 days
(480 Reviews)
7.4
tlchung

skilled php developer here, have done over 500+ php project for my clients, i can do the import script for you, let start now.

$126 SGD in 2 days
(156 Reviews)
7.3
gopalvora

Hi ready to start i had more than 5 year experience in the php ,mysql , jquery etc.. so let me know your view Thanks

$144 SGD in 6 days
(241 Reviews)
7.2
eperfections

Dear Sir, I am TOP RANKED programmer with 600+ reviews on this site. I can write this tool to import xml with rules in PHP. Please award me this project.

$144 SGD in 3 days
(202 Reviews)
6.9
michale21

A proposal has not yet been provided

$154 SGD in 3 days
(119 Reviews)
6.8
seekdeveloper

Hi, I have read your post and understood your requirement. I have good experience in handling XML//PHP/Python/Wordpress /Magento/Joomla/Drupal/ HTML5/CSS3Yii framework/Javascript/MySQL/ Kindly go through my More

$515 SGD in 5 days
(40 Reviews)
6.7
CodingExpertz

Hi, I looked your posting and I am very much interested to work with you ...I am an India based software professional providing a range of IT services and solutions that address the technology needs of your company More

$250 SGD in 3 days
(99 Reviews)
6.1
cheapexcell

Hello, I am an expert in PHP & XML with over 10 years of experience. Ready to start. Thanks, Alex

$120 SGD in 3 days
(90 Reviews)
5.9
sunilexpert

I am an expert web developer with 8+ years of developing dynamic web applications and websites. I have experience in PHP, MySQL, Ajax, Javascript etc. You can see feedback against my profile they are always awes More

$250 SGD in 7 days
(66 Reviews)
5.9
sinharavi

I have 5 years industrial experience in Python+Mysql, and interested in taking this project. I will do this project using Python language. I need some clarification in some of the points of this project. I need t More

$130 SGD in 3 days
(56 Reviews)
5.6
pixelbypixelsl

PHP / mySQL expert - I can help build this for you without any problem at all. Let me know if you have any questions at all.

$250 SGD in 3 days
(14 Reviews)
5.5
suriyant

With strong experience in Python. I can do this. Please keep me into your consideration. Look forward to working with you. Thank you.

$147 SGD in 3 days
(41 Reviews)
5.5
trkr

Hi, How will you run this script from command line i mean what kind of modularity do you need? e.g. /bin/bash/php [url removed, login to view] Is mysql table ready? If yes, are there any more fields that needs More

$222 SGD in 3 days
(43 Reviews)
5.3
tanveerjavaid

Hi I am experienced programmer and ready to start work today.. I will do it using php.. so please response. thanks

$155 SGD in 3 days
(30 Reviews)
5.3
mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start thanks

$164 SGD in 5 days
(24 Reviews)
5.0
NTechcorporate

Hi, Hope you are doing well! We have gone through your requirement and we understand that you are looking for highly skilled, qualified, and experience Python development team for your project. Our developer More

$309 SGD in 4 days
(5 Reviews)
5.0
M5L2764K

Hi, I have about 10 year experience with Python and different databases. I've also done some scripts like this before. I just wonder: if database content must exactly match content of XML file why not start a tra More

$110 SGD in 3 days
(10 Reviews)
4.8
Batista111

Hi, I understand your requirements. Will import the XML into MySQL following all the rules mentioned by you. Please come on chat for further discussion. I can deliver the project within time upto you satisfactio More

$147 SGD in 3 days
(21 Reviews)
4.9