title: Convert CSV to LDIF for import into ldap?
body: <p>I have a MSSQL database with 13k users in a table with headers like username, password, fname, lname, etc.  I would love to be able to turn this data into a proper ldap server.</p>
  
  <p>Currently I've done the following:  Create a job on the mssql server to export that table hourly in a csv.  The query pulls username, password, fname, lastname,and memberid. ftp this data hourly to my linux ldap server.</p>
  
  <p>Can someone recommend a method on how to turn this csv into ldif so I can run ldapmodify and put in  all these entries into my ldap server? I'm assuming I can write a parser, but would love to know if there's already a product that can do csv to ldif conversion in this manner and if this plan makes any sense or if there's a better way to do this? Thanks.</p>