Convert xml to csv in rails

Question

Which plugins or gems are available to convert xml to csv file ?

Answer 1

Using Nokogiri in Rails.

 xml_file = "datafile.xml"
 doc = Nokogiri::XML.parse(xml_file)
 output = "data.csv"

 sv_string = CSV.generate do |csv|
  # header row
     csv << ['header_array']

  # data rows
    @object_array.map do |object|
      csv << [object['NODE_NAME'].text]
    end
  end

 #send response  

   send_data csv_string,
          :type => 'text/csv; charset=iso-8859-1; header=present',
          :disposition => "attachment; filename=users.csv" 

Answer 2

Since the two formats generally have nothing to do with each other, I would suggest parsing the XML with Nokogiri and then building up your CSV with FasterCSV. You need to provide the logic in between to decide which parts go where in your CSV file.