sudo gem install ticketmaster, sudo gem install ticketmaster-lighthouse. usage: ruby lighthoust-export.rb accoutname username password projectid

export-csv.rb

require 'rubygems'
require 'ticketmaster'
require 'ticketmaster-lighthouse'

Lighthouse.account = ARGV[0]
Lighthouse.authenticate(ARGV[1],ARGV[2])
all_tickets = Lighthouse::Ticket.find(:all, :params => { :project_id => ARGV[3] })

begin
File.delete("export.csv")
rescue
end

export = File.new("export.csv", "w+")

export.puts("'id,'title','description'")

all_tickets.each do |ticket|
  export.puts('#'+ticket.id.to_s+','+ticket.title+',')
  if (ticket.original_body != nil)
    export.puts(ticket.original_body+'')
  end
end