Bulk insert users and passwords to LDAP

Owned by Former user (Deleted)
Last updated: 2019-06-18 by Former user (Deleted)


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

  1. 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.ldif
    dn: 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.ldif
    dn: 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

  2. Use the import.cmd file to import the file into the ADAM directory (or any other directory being used):

    Import
    C:\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.




Ubisecure Privacy Policy & Cookie Statement