select
- concat('cn=',c.categorycode,',ou=groups') as dn,
+ concat('cn=',c.categorycode,',ou=',c.categorycode) as dn,
'group' as objectClass,
'groups' as ou,
c.categorycode as cn,
surname as displayName,
rfid_sid as pager,
email as mail,
--- categorycode as memberOf,
- categorycode as department,
+ categorycode as memberOf,
+ categorycode as ou,
concat('/home/',borrowernumber) as homeDirectory
from borrowers
select
- 'ou=groups' as dn,
+ concat('ou=',c.categorycode,'dc=ffzg,dc=hr') as dn,
'organizationalunit' as objectClass,
- 'groups' as ou,
- 'Groups from Koha' as description
+ c.categorycode as ou,
+ c.description as description
+from categories c