Script to insert XML into MySql

Overview of Project: The Northwest Multiple Listing Service (NWMLS) provides real estate brokerage firms with a database of properties and businesses available for sale in Western Washington State. The NWMLS provides these listings in XML format. There are (9) categories of listings each with their own unique XML data structure. Real Estate brokerages wishing to display properties for sale from this database must do the following: 1) Access the NWMLS data feed at least once daily to download all new/updated data for properties and corresponding images 2) Convert that data from XML format and insert into their database of choice--in our case we'll be inserting this data into a MySQL database, with (9) tables -- one for each property category 3) Images for the property listings are stored separately. At any given time the NWMLS system may have 500,000 photos for the roughly 35,000 active & inactive property listings they track 4) Each day we need to check to see if (a) new images have been added for a property and if so download from the NWMLS server and re-upload to our server; (b) if old images have been removed from a listing, delete those from our server Operating Environment: Database: MySQL Lanquage: ColdFusion System: Linux Hosting Source: MediaTemple Deliverables: What I need is this- 1) Since this is a brand new database/website set up I need the (9) XML files parsed and inserted into the database to initiate the process 2) Thereafter, I'm assuming I need a PERL script (or recommended equivalent) that will call out to the NWMLS data server 1 to 3 times per day to check for updated data and download/insert that new or changed data to our MySQL database. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables): a)? 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. b) 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). ## Platform Linux