How to import the users from LDAP directory?
2 years ago
Originally Published: 2001-08-08
Article Number
000056344
Applies To
Lightweight Directory Access Protocol (LDAP)
RSA ACE/Server 5.0 (no longer supported as of 8-15-2004)
Issue
How to import the users from LDAP directory?
Error: "Invalid version header in the CSV file."
Cause
The CSV file has incorrect format.
Resolution
RSA Security supports three LDAP servers namely, Netscape, Active Directory from Windows 2000, and Novell.

NOTES:
a. The standalone utility sdaceldap can be used to connect to LDAP server and create a CSV file. Running sdaceldap  tool and the CSV file generation is restricted to primary server and cannot be done on the Remote Administration machine.
b. Users can be imported from the Remote Administration machine with a CSV file. The CSV file is human editable.
c. The default file format on import utility is CSV format. However, the users can be imported from .txt file as well.

1. Import the users into a .csv file on primary server using sdaceldap.

2. Importing the users into ACE/Server:

 a. On the NT ACE/Server:

  Start --->Programs --> ACE/Server --> Database Administration -Host mode -->
  User ---->Manage LDAP Users  -->Click on Input File --->Select appropriate .csv file
  Select the user name. Click on the Add button. User will be added to the database.

 b. On the UNIX ACE/Server:

  #cd ace/prog>
  #./sdadmin ---> User -----> Manage LDAP Users ------> Click on Input File -----> Provide the path for appropriate .csv file.

3. Copy the below given sample file on a text editor like Notepad. Save the file as sample.txt.

Sample file:
VERSION="1",DIRECTION="import",LDAPPREFIX="ldap://nw501/"
chDefaultLogin="uid",
chLastName="sn",
chFirstName="givenname",
chLDAPSource="dn"
"jsmith","Smith","John","uid=jsmith,ou=customer support,o=rsa security,c=us"
"pnorth","North","Peter","uid=pnorth,ou=customer support,o=rsa security,c=us"

4. Import the users as described in step 2 and 3 using the file sample.txt

Contact RSA Security Technical Support for additional sample files if necessary.