Import XML file into Mysql Database with php or python
This project was successfully completed by robinsjp for $155 SGD in a day.Get free quotes for a project like this
Project Budget$30 - $250 SGD
Completed In1 day
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.
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.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online