csv = CSV.parse(open('users.csv'))
users = []
csv.each do |user|
  users << user.first.split('|').collect{|x| x.strip}
end

users.each do |user|
  new_profile = Profile.new
  name = user.last.split(' ')
  new_profile.firstname = name.shift
  new_profile.surname = name.join(' ')
  new_profile.email = user.second
  new_profile.save!

  new_user = User.new
  new_user.email = user.second
  new_user.username = user.first
  new_user.profile = new_profile
  new_user.password = SecureRandom.hex
  new_user.save!
end