coreymartella/index.html.erb

## index.html.erb
<html>
  <head>
    <style type="text/css">
      table {border: 0; border-collapse: collapse;}
      th, td {text-align: left; padding: 2px;}
      .odd {background: #eee;}
    </style>
  </head>
  <body>
    <table>
      <thead>
        <tr>
          <% @fields.each do |field| %>
            <th><%= field %></th>
          <% end %>
        </tr>
      </thead>
      <tbody>
        <% @rows.each_with_index do |row,i| %>
          <tr class="<%= i % 2 == 1 ? :odd : :even %>">
            <% @fields.each do |field| %>
              <td><%= row[field] %></td>
            <% end %>
          </tr>
        <% end %>
      </tbody>
    </table>
  </body>
</html>

## pages_controller.rb
class PagesController < ApplicationController
  def index
    xml = Hpricot.parse File.read("/Users/cmartella/downloads/cqs.xml")
    @fields = xml.search("//columnname").map(&:inner_text)
    @rows = xml.search("//record").map do |record|
      record.search("/field").reduce({}) do |hash,field|
        hash.merge(field['name'] => field.inner_text)
      end
    end
  end
end
	<html>
	<head>
	<style type="text/css">
	table {border: 0; border-collapse: collapse;}
	th, td {text-align: left; padding: 2px;}
	.odd {background: #eee;}
	</style>
	</head>
	<body>
	<table>
	<thead>
	<tr>
	<% @fields.each do \|field\| %>
	<th><%= field %></th>
	<% end %>
	</tr>
	</thead>
	<tbody>
	<% @rows.each_with_index do \|row,i\| %>
	<tr class="<%= i % 2 == 1 ? :odd : :even %>">
	<% @fields.each do \|field\| %>
	<td><%= row[field] %></td>
	<% end %>
	</tr>
	<% end %>
	</tbody>
	</table>
	</body>
	</html>
	class PagesController < ApplicationController
	def index
	xml = Hpricot.parse File.read("/Users/cmartella/downloads/cqs.xml")
	@fields = xml.search("//columnname").map(&:inner_text)
	@rows = xml.search("//record").map do \|record\|
	record.search("/field").reduce({}) do \|hash,field\|
	hash.merge(field['name'] => field.inner_text)
	end
	end
	end
	end