Read XML, Clean It, store in DB

In the attached files you will find the sql to create a mysql table and an xml file. I need a perl script written that will read in the xml file and store the data into the database. The description field needs to be cleaned up as follows: * Remove all id="...", so for example becomes * Remove all class="..." I will run your script as perl import_xml [login to view URL] So you should use the file name on the command line as the input file. If you find a field in the XML that does not map to a field in the table, you should print out a warning message with the line number and the field name and die (of course this does not apply to the listing or contact tags) Must be written in perl assume the database is on localhost. I don't care what you call the database or the username and password as I will change it anyway. **When you bid - in the [login to view URL] file is some text. Include that text in your bid message.** That way I know you are intelligent enough to follow instructions. Please - no 'I can do it' bids - convince me. Include how long it will take you to finish. Preference given to those that can get right on it and finish soon. **Added this** You will need to run the following after creating the table ALTER TABLE `joblisting` ADD `contactaddress1` VARCHAR( 100 ) NULL AFTER `contactemail` , ADD `contactaddress2` VARCHAR( 100 ) NULL AFTER `contactaddress1` ; If a field does not have a value in the XML, insert it as empty. ## 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). * * * This broadcast message was sent to all bidders on Wednesday Sep 19, 2007 12:34:16 PM: I added some SQl to the bid - be sure and revisit the page. Basically I needed to add the contactaddress1 and contactaddress2 fields. If a field is in the DB and not in the XML - insert it as empty. ## Platform win, mac, linux - I don't care - but I'll be running the script on a linux box - so it better work for me.