Convert Google accounts to LDAP with AWK

從CSV建立密碼   (如帳號前加上pass)
vi mkldifpw.awk
-----------
{FS="@"}
{print "slappasswd -s pass" $1 }

-----------

awk -f mkldifpw.awk "UserData-20150312.csv"  | sh > pw.txt

paste UserData-20150312.csv pw.txt > all.txt

vi mkldif.awk
---------
{FS="[@ \t]"}

{print "dn: cn="$1",ou="$4",ou=stu,dc=xxx,dc=tp,dc=edu,dc=tw" }
{print "cn: "$1}
{print "sn: "$4$3 }
{print "mail: "$1"@"$2 }
{print "objectClass: person" }
{print "objectClass: organizationalPerson" }
{print "objectClass: inetOrgPerson" }
{print "objectClass: top" }
{print "userPassword: "$8 }
{print "" }

----------

Only for debug:
{for(i=0;i<=NF;++i)print $i}
{print "" }
-----------

awk -f mkldif.awk all.txt  > final.ldif

匯入資料庫:
service slapd  stop
slapadd -l final.ldif

service slapd start

參考資料:
http://blog.ilc.edu.tw/blog/blog/25793/post/78479/468195
https://techhelplist.com/index.php/tech-tutorials/34-openldap/48-user-management-in-openldap