svp.rake

gistfile1.rb

task :synchronize_site_names => :environment do
  require "csv"

  first_line_skipped = false

  CSV.foreach("doc/sgpd_svp.csv") do |line|
    first_line_skipped = true and next unless first_line_skipped

    svp_site_id, svp_site_name, oas_site_name = line

    unless oas_site_name.blank?
      OasSite[oas_site_name] = svp_site_id
      puts "#{oas_site_name}: #{svp_site_id}"
    end
  end
end