gistfile1.rb

class Database::Report
  def self.to_s
    puts
    resort_count = Resort.count
    puts "Resorts : #{resort_count}"
    advert_count = Advert.count
    puts "Adverts : #{advert_count}"
    user_count = User.count
    puts "Users   : #{user_count}"
    users = User.find(:all)
    admin_count = 0
    users.each do |user|
      if user.admin
        count += 1
      end
    end
    # couldn't you use raw sql here?
    # admin_count = User.count(:conditions => ["admin = ?", true])

    puts "Admins  : #{admin_count}"
  end
end

require 'fastercsv'

class Resort
  def self.import_from_csv(filename)
    count=0
    
    # wrap in transaction in the event one of the resort's fails
    # validation and raises an exception
    Resort.transaction do
      # I see you were removing the newline characters with tr, I
      # changed your row_sep to "\r\n" thinking that might help.
      # However if that does not work I would load the string up in
      # ruby and perform the transformation with a regexp, then pass
      # it off the the appropriate FasterCSV method for a string.
      FasterCSV.foreach(filename, :row_sep => "\r\n") do |row|
        # name,serial_no,region = row
        # use ! (bang) version of create to throw exception if
        # validation fails, helpful with transactions
        Resort.create!(:name => row[0],
                       :serial_number => row[1],
                       :country => row[7],
                       :resort_height => row[16],
                       :overview_review => row[141],
                       :region => row[6],
                       :continent => row[8],
                       :coordinates_east => row[10],
                       :coordinates_north => row[11],
                       :travel_to_review => row[146])
        count += 1
        puts count.to_s + "#{count} Resort name: #{row[0]}"
        puts "Resort created : " + row[0]
      end
    end
    puts "-------------------------"
    puts "Resorts created     : #{count}"
    puts "-------------------------"
  end
end

namespace :peaklocation do

  desc "Count the resorts in the database"
  task :database_report => :environment do
    puts Database::Report
  end

  namespace :resorts do

    desc "Load up all the resorts from resorts1.csv into #{Rails.env} database"
    task :load => :environment do
      filename = ENV['FILENAME'] || "#{RAILS_ROOT}/db/resorts1.csv"
      Resort.import_from_csv(filename)
      Rake::Task["peaklocation:database_report"].invoke
    end

    desc "Delete all the resorts from the #{Rails.env} database"
    task :unload => :environment do
      Resort.delete_all
      Rake::Task["peaklocation:database_report"].invoke
    end

    desc "List all the resorts from the database"
    task :list => :environment do
      Resort.find(:all).each do |resort|
        puts "#{resort.id} #{resort.name}"
      end

      Rake::Task["peaklocation:database_report"].invoke
    end
  end

  namespace :adverts do
    desc "Load up all the advert_types into #{Rails.env} database"
    task :load_advert_types => :environment do
      adverts = [["Accomodation", "Accom"],
                 ["Food", "Food"],
                 ["Ski Hire", "Ski Hire"],
                ].each do |name, description|
        AdvertType.create!(:name => name, :description => description)
      end
    end
  end

  namespace :users do
    desc "Make a user admin in #{Rails.env} database"
    task :make_admin => :environment do
      username = ENV['USERNAME'] || ENV['username']
      raise "Must specify USERNAME=" unless username
      user = User.find_by_username(username)
      if user
        puts "#{user.username} found"
        u.admin = 1
        puts "#{user.username} set to admin"
        u.save
        puts "#{user.username} saved"
      else
        puts "#{username} not found"
      end
    end
  end
end