From: Stuart Clarke <stuart.clarke1986@...>
Date: 2010-04-09T03:25:05+09:00
Subject: XML to CSV

I am struggling to see how I would go about extracting data from an XML
file like so:

 <?xml version="1.0" encoding="UTF-8" ?>
- <java version="1.6.0_17" class="java.beans.XMLDecoder">
- <object class="com.########l">
- <void method="###">
- <object class="###########">
- <void property="###########">
  <long>00000</long>
  </void>
- <void property="description">
  <string />
  </void>
- <void property="downloaded">
  <long>100000000</long>
  </void>
- <void method="###">                THIS IS A NEW RECORD
- <object class="###########">
- <void property="###########">
  <long>00000</long>
  </void>
- <void property="description">
  <string />
  </void>
- <void property="downloaded">
  <long>100000000</long>
  </void>

My code thus far is

require 'rexml/document'
xml = REXML::Document.new(File.open("H:\\test.xml"))
csv_file = File.new("H:\\data.csv", "w")
xml.elements.each("//event") do |e|
    csv_file.puts e.attributes['id'] << "|" <<
      e.elements['object class="com.########l"'].text << "|" <<
      e.elements['void property="###########"/long'].text << "|" <<
      e.elements['void property="description"/string'].text << "|" <<
      e.elements['void property="downloaded"/long'].text
end


This is however failing.

Any ideas?

Many thanks
-- 
Posted via http://www.ruby-forum.com/.