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.
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 Daha Fazla
Bu iş için 38 freelancer ortalamada $215 teklif veriyor
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.
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