Add NetIDs to CSV for production center accounts

add_netid_to_prod_center_accounts

#!/usr/bin/env ruby

script_name = File.basename(__FILE__)
file_path = ARGV[0]

abort "No input CSV file provided. Example: #{script_name} ./prod_center_accounts.csv" if file_path.nil?
abort 'File must have a .csv extension' unless file_path =~ /\.csv\Z/

new_file_path = file_path.gsub(/\.csv\Z/, '_with_netids.csv')

require 'csv'
require 'biola_web_services'

BiolaWebServices.configure do |config|
  [:url, :cert_path, :key_path, :key_password, :verify_ssl, :ssl_version].each do |key|
    env_value = ENV["BIOLA_WS_#{key.upcase}"]
    config.send(:"#{key}=", env_value)
  end
end


CSV.open(new_file_path, 'w') do |csv|
  CSV.foreach(file_path, headers: true) do |row|
    abort %{Could not find column "ID" in #{row.headers.join(', ')}} if row.field? 'ID'

    netid = BiolaWebServices.dirsvc.get_user!(id: row['ID'].to_i)['netid']

    csv << (row.fields + [netid])
  end
end