c4-import.rake

task :import => :environment do
  Organization.delete_all
  f = FasterCSV.open("#{Rails.root.to_s}/db/initial/data.csv", :headers => true)
  f.each do |row|
    record = Organization.new
    org = row.to_hash
    org.each do |field, val|
      next unless val
      val = val.strip
      if Organization.columns_hash[field].type == :integer
        val = val.gsub(/[,\$]/,"").to_f
      end
      if Organization.columns_hash[field].type == :boolean
        val = val.downcase =~ /(yes|x+)/ ? true : false
      end
      record[field] = val
    end
    p record
    record.save
  end
end