Bulk insert users and passwords to LDAP
How to add a large number of users to Ubisecure SSO from a file containing the user id, name, and passwords:
Step-by-step guide
Create an .ldif file from the list of users and passwords. For every user, there should be the following lines. Example shown as newusers.ldif:
example.ldifdn: cn=[NAME],ou=[SITE],[LDAP_BASE_DN] changetype: add objectClass: top objectClass: person objectClass: ubiloginUser cn: [NAME] ubiloginMemberOf: [GROUP_DN] sn: [FULLNAME_2ND] uid: [USERNAME] ubiloginEnabled: TRUE givenName: [FULLNAME_1ST] dn: cn=[PASSWORD_METHOD_CN],cn=[NAME],ou=[SITE],[LDAP_BASE_DN] changetype: add objectClass: top objectClass: ubiloginAuthMethod cn: [PASSWORD_METHOD_CN] ubiloginEnabled: TRUE ubiloginConfString: [PASSWORD]
Example
newusers.ldifdn: cn=John Smith,ou=PaperManufacturing,ou=GlobalCompany,cn=Ubilogin,dc=example,dc=org changetype: add objectClass: top objectClass: person objectClass: ubiloginUser cn: John Smith ubiloginMemberOf: cn=USAWorkers,ou=PaperManufacturing,ou=GlobalCompany,cn=Ubilogin,dc=example,dc=org sn: Smith uid: johns ubiloginEnabled: TRUE givenName: John dn: cn=password.1,cn=John Smith,ou=PaperManufacturing,ou=GlobalCompany,cn=Ubilogin,dc=example,dc=org changetype: add objectClass: top objectClass: ubiloginAuthMethod cn: password.1 ubiloginEnabled: TRUE ubiloginConfString: password123
Use the import.cmd file to import the file into the ADAM directory (or any other directory being used):
ImportC:\ubisecure\ldap>adam\import.cmd newusers.ldif Connecting to "localhost:389" Logging in as current user using SSPI Importing directory from file "newusers.ldif" Loading entries... 2 entries modified successfully. The command has completed successfully
Another way is to import users using the LDAP Administrator tool (File -> Import Data). The essential fields are shown in the example above. Refer to the LDAP Administrator tool for instructions on importing from other file formats.
Mail merge tools such as Microsoft Word can be used to quickly generate LDIF import files from Excel spreadsheets.
Related articles