RSS 2.0 feed integration to existing site MySQL backend

We have a small project where we need to integrate with an external RSS feed and transform the contents of the RSS feed into our exisitng database. The winning bidder will be provided with the RSS and associated DB schema to integrate with however as a guide to its size (and its quite small) the RSS feed has only 19 items / nodes. We have examples of other similar systems already developed for non-RSS feeds which we cna provide to the winning developer. This should be an easy and quick project for experienced coders. Below is an example of how the solution would extract data from the RSS feed: 1. Develop a RSS reader in PHP to hit the RSS feeder each hour (dont worry about the time thing - we'd implement this via cron), ensuring we pass in assigned client ID code into the stp parameter, e.g.: [login to view URL] 2. A list of items will be returned. Using an XML parsing object iterate through the data. We should then use the following logic: • Compare the unique for the item with the items already in our system. If the item already exists, update the information instead of creating another item • Create/update items in our own database based on the XML data in the feed. Note that the locations, item types and categories can be configured to use our own terminology ??"There are existing mappign tables to perform translations between items that are called different things on our site vs other sites. For example, Carrots maybe in the RSS feed but we may call them CARROTS and the translation needs to be done at load time. • item that have closed will no longer appear in the RSS feed. Compare the most recent item list with the last import performed. If item have been removed from the feed, remove the item from your site. ## Deliverables 1a) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 1b) All software will be developed under a 60 day warranty such that if any bugs are found with the dropped / released software component and bugs/issues are found within 45 days, the seller/coder agrees to provide an urgent fix at no cost to the buyer 1c) all code must be properly structured and come with detailed comments. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): 2a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. 2b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). 4) an FER must accompany all software drops to be deemed accepted and software will not be accepted if it is not properly tested by developer/coder 5) coder must ensure proper testing of each module before releasing software and FER to staging environment - seller/coder is responsible for testing ALL functionality of the component dropped - that is, coder/seller must not only test the enhancement or the fix made on the software module (php source file), but must also test all other scenarios also for that module (eg: if fix made to [login to view URL] for keywords, coder/seller must not only test the keyword search functionality, but also location search, category serach, etc). ## Platform Linux based OS, MySQL 4.1 SQL database, solution must be written in PHP (<5) and must be well documented (in code), follows industry standards and conventions for code convention and quality, and must be well tested.