Import XML file into Mysql Database with php or python

IN PROGRESS
Bids
41
Avg Bid (SGD)
$207
Project Budget (SGD)
$30 - $250

Project Description:
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 required:
MySQL, PHP, Python, XML
Additional Files: stockdata.xml
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 500
in 7 days
$ 144
in 3 days
Hire rajeshsonisl
$ 927
in 2 days
$ 126
in 2 days
$ 144
in 6 days
$ 144
in 3 days
$ 154
in 3 days
$ 515
in 5 days
$ 250
in 3 days
$ 120
in 3 days