root/platform/redmine/contrib/add_users_from_csv.rb @ 31394

#!/usr/bin/env ruby

# Import user information from CSV.
# Usage: ruby script/runner contrib/add_users_from_csv.rb CSV_FILE
#
# CSV layout (comma separated, in Shift-JIS code)
# 1: account name for logging in
# 2: Password (plain)
# 3: Lastname
# 4: Firstname
# 5: Email
# 6: Is administrator? (1 or 0)
#
# example) oinume,hoge,oi,nume,oinume@cpan.org,1

require 'csv'
require 'kconv'

csv_path = ARGV.shift
unless csv_path
  STDERR.puts "usage: ruby script/runner contrib/add_users_from_csv.rb CSV_FILE"
  exit 1
end

rows = []
reader = CSV.open(csv_path, "r")
reader.shift
reader.each do |row|
  if row.size != 6
    next
  end

  columns = row.collect do |column|
    column.kconv(Kconv::UTF8,  Kconv::SJIS)
  end

  user = User.find_by_login(columns[0])
  unless user
    user = User.new(:status => 1, :mail_notification => 0, :language => 'ja')
    user.login = columns[0]
    user.password = columns[1]
    user.password_confirmation = columns[1]
    user.lastname = columns[2]
    user.firstname = columns[3]
    user.mail = columns[4]
    user.admin = columns[5]
  end

#  p user
  user.save_without_validation!
end