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.
This project was awarded to
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!!
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
Colombo, Sri Lanka
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.
Experienced Java, Python , web based application developer
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.
IKOTA LEKKI AJAH, Nigeria
Taxila Cantt, Pakistan
Web, Bots, Crawlers, and Scrapers Development. I have expertise in automation services and I can automate any manual process.
iOS, C++, Python, Web Development
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.
San Francisco, United States