convertcsvtoldif-groups.php

<?php

$row = 1;
$limit = 120000;
 $userTypeGroups = [];
    $departMent = [];

if (($handle = fopen("/home/tran/mock.csv", "r")) !== FALSE) {
    $members = "";
   

    while ((($data = fgetcsv($handle, 1000, ",")) !== FALSE) && ($row <= $limit)){
        $num = count($data);
        if (!isset($userTypeGroups[$data[4]]) && $data[4] != "")  $userTypeGroups[$data[4]] = $data[4];
        if (!isset($departMent[$data[5]]) && $data[5] != "")  $departMent[$data[5]] = $data[5];
        $row++;
    }

// Create groups:
    foreach($userTypeGroups as $groupName){
        /*
        dn: cn=staff,ou=pluriel,ou=groups,dc=example,dc=org
            changetype: add
            objectClass: groupOfNames
            objectClass: top
            cn: staff
         */
        echo "dn: cn=".$groupName.",ou=groups,dc=example,dc=org\n";
        echo "changetype: add\n";
        echo "objectClass: groupOfNames\n";
        echo "objectClass: top\n";
        echo "member: uid=billy,dc=example,dc=org";
        echo "cn: ".$groupName."\n";
        echo "\n"; 
    }
    
// Create ou:
    foreach($departMent as $dept){
        /*
            dn: ou=abc,ou=staff,ou=people,dc=example,dc=org
            changetype: add
            objectClass: organizationalUnit
            objectClass: top
            ou: abc
        */
        echo "dn: ou=".$dept.",ou=people,dc=example,dc=org\n";
        echo "changetype: add\n";
        echo "objectClass: organizationalUnit\n";
        echo "objectClass: top\n";
        echo "ou: ".$dept."\n";
        echo "\n"; 
    }        
    fclose($handle); 
}
    ///////////////////////////////
    if (($handle = fopen("/home/tran/mock.csv", "r")) !== FALSE) {
        $members = "";
 
    $row = 1;
    while ((($data = fgetcsv($handle, 1000, ",")) !== FALSE) && ($row <= $limit)){
        $num = count($data);
        echo "# New entry \n";
        $userDn = "";
        if ( isset($departMent[$data[5]]))
        {
            $userDn = "uid=".$data[2].",ou=".$departMent[$data[5]].",ou=people,dc=example,dc=org\n";
        }else{
            $userDn = "uid=".$data[2].",ou=staff,ou=people,dc=example,dc=org\n";
        }
        echo "dn: ".$userDn;
        echo "changetype: add\n";
        echo "gidNumber: 0\n";
        echo "objectClass: inetOrgPerson\n";
        echo "objectClass: organizationalPerson\n";
        echo "objectClass: person\n";
        echo "objectClass: top\n";
        echo "objectClass: posixAccount\n";
        echo "uidNumber: $row\n";
        echo "uid: ".$data[2]."\n";
        echo "homeDirectory: /home/".$data[2]."\n";
        echo "sn: ".$data[3]."\n";
        echo "cn: ".$data[3]."\n";
        echo "mail: ".$data[1]."\n";
        echo "employeeType: ".$data[4]."\n";        
        echo "displayName: Name ".$data[3]."\n";
        if ( isset($userTypeGroups[$data[4]]) )
        {
            echo "memberOf: cn=".$userTypeGroups[$data[4]].",ou=groups,dc=example,dc=org\n";
        }
        echo "userPassword:: UEBzc3cwcmQ=\n";
        echo "\n";

        if ( isset($userTypeGroups[$data[4]]) )
        {
            echo "dn: cn=".$userTypeGroups[$data[4]].",ou=groups,dc=example,dc=org\n";
            echo "changetype: modify\n";
            echo "add: member\n";
            echo "member: ".$userDn;            
            echo "\n";
        }
        
        $row++;
    }

    fclose($handle); 
}