Convert a G Suite CSV to LDIF

gsuite-csv-to-ldif.rb

require "csv"

csv = CSV.new(File.open("User_Download_08052019_142707.csv"), headers: :first_row)

File.open("./gsuite.ldif", "w+") do |file|
  csv.each_with_index do |row, index|
    file.write("dn: cn=#{row["First Name [Required]"]} #{row["Last Name [Required]"]},id=#{201 + index}\r\n")
    file.write("cn: #{row["First Name [Required]"]} #{row["Last Name [Required]"]}\r\n")
    file.write("givenname: -----\r\n")
    file.write("mail: #{row["Email Address [Required]"]}\r\n")
    file.write("objectclass: top\r\n")
    file.write("objectclass: person\r\n")
    file.write("\r\n")
  end
end