Import XML file into Mysql Database with php or python

Budget $30 - $250 SGD
Bids 41
Average Bid $207

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.

Post a Project Like This

This project was awarded to

robinsjp

Where do I begin. I was spending 20 hours a week manually invoicing all of my spreadsheet data. He said he could have a script written up in a few hours! He delivered as promised! Now with one click of a button, I have 170 invoices done in 10 seconds! His communication is excellent and was more than considerate answering any questions and adding features to the script. I have more work for this guy coming up. It was such a pleasure and I will hire him for all my programing needs! Now I can enjoy my Sundays instead of sitting in front of a computer for 10 hours straight doing admin work! Highly recommended! USE THIS GUY! Trust me! Worth Every Dollar Spent!!
About the Freelancer
robinsjp Profile Picture

I spent most of my working life as a researcher in physics. I used mainly C++ and Matlab. My current day job involves coding in Perl, PHP and interacting with a MySQL database.

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • mahindaranil Profile Picture

    mahindaranil

    Colombo,  Sri Lanka

    We have experienced software developers who have worked on large projects. Before starting this company we worked for FastSearch and Transfer / Microsoft Sharepoint for more than 4 years. C#, Java, Python were heavily used. Other than that we have experience on web technologies. We are experts on following technologies - PHP, JSP, Servlets, Spring, Hibernate , Ajax, JavaScript. Also have experience on Android and Apple mobile application developments

    PHP, Java, JSP, and Javascript

  • lechu502 Profile Picture

    lechu502

    Poland

    I am looking forward to being hired by you for all your MySQL jobs. I am an experienced MySQL Developer and have a blend of experience in the area of Python and so my service will prove to be useful for your projects. I have a distinguished career as a MySQL Developer and Python Designer. I am ready to be hired by you and start work today.

    Python, Linux, AJAX, and MySQL

  • animeshmishra86 Profile Picture

    animeshmishra86

    Bangalore,  India

    Experienced Java, Python , web based application developer

    Java, JSP, XML, and Python

  • xiddw Profile Picture

    xiddw

    Leon,  Mexico

    I've pursed a Master degree in a top-tier Research Centre at Mexico. During my studies, I have been working in Machine Learning techniques as also Pattern Recognition methods. I'm also interested in Computer Vision/Image processing applications. I'm proficient in C, C++, C#, R, Matlab for doing scientific computing. I've also been working as freelancer developing and designing websites and on-demand software using HTML5, CSS3, PHP, C#, VisualBasic and Java.

    PHP, C Programming, Javascript, and AJAX

  • toinnisfree Profile Picture

    toinnisfree

    IKOTA LEKKI AJAH,  Nigeria

    I am a fulltime freelance programmmer with over 10 years programming experience. An expert in PHP / MYSQL / Javascript / AJAX / XML deployments. I particularly specialize in shopping carts and API integrations: payment, shipping, inventory, autoresponders and the like: Interspire, Zencart, Virtuemart, Cubecart, Amember, OSC, TomatoCart, Woocommerce. You will find my services highly reliable and professional. Let me get right to it and deliver your next project with a professional quality that many of my previous customers can attest to.

    PHP, Perl, C Programming, and Javascript

  • SigmaVisual Profile Picture

    SigmaVisual

    Taxila Cantt,  Pakistan

    Web, Bots, Crawlers, and Scrapers Development. I have expertise in automation services and I can automate any manual process.

    PHP, ASP, C Programming, and Javascript

  • trkr Profile Picture

    trkr

    Mersin,  Turkey

    I've been working more than 15 years as a web developer. ## Area of Expertise - PHP4/PHP5 - MySQL - Javascript/DHTML/AJAX/JQUERY/AngularJS - CSS2/CSS3 - Bootstrap - XML/XHTML/HTML4/HTML5 - Wordpress - Buddypress - bbPress - Mobile App Development - Payment gateways - Search engine optimization (SEO) - Content Management Systems - Project debugging and improvement - Data mining and transfering - Server setup and configuration

    PHP, Javascript, XML, and Script Install

  • bogdanpeschir Profile Picture

    bogdanpeschir

    Brasov,  Romania

    iOS, C++, Python, Web Development

    PHP, Python, Data Processing, and Data Entry

  • M5L2764K Profile Picture

    M5L2764K

    Riga,  Latvia

    C and C++ on many Unix platforms, Python, MQL4, SQL (Oracle), Lua network programming, SOAP (gSOAP, SOAPpy), web scraping (Scrapy framework), Varnish VMODs, bugfixing and performance tuning. Bitcoin and Litecoin experience with many exchanges, market and trading API. I own a profitable Bitcoin/Litecoin arbitrage bot.

    C Programming, XML, Python, and Linux

  • hoprocker Profile Picture

    hoprocker

    San Francisco,  United States

    I am a python-oriented full stack programmer, with experience in cloud hosted, multiple-node systems programming and testing. I have several years experience working as a frontend developer and have helped created several interactive, javascript-rich web applications.

    Python, Linux, CSS, and Software Architecture