To import objects
using the csvde
utility, you
must
first create a CSV file containing the objects to
add. The first line of the file should contain a comma-separated list
of attributes you want to set, with DN
being the
first attribute. Here is an example:
DN,objectClass,cn,sn,userAccountControl,sAMAccountName,userPrincipalName
The rest of the lines should contain entries to add. If you want to leave one of the attributes unset, then leave the value blank (followed by a comma). Here is a sample CSV file that would add two user objects:
DN,objectClass,sn,userAccountControl,sAMAccountName,userPrincipalName "cn=jim,cn=users,dc=rallencorp,dc=com",user,Smith,512,jim,jim@rallencorp.com "cn=john,cn=users,dc=rallencorp,dc=com",user,,512,john,john@rallencorp.com
Once you’ve created the CSV file, you just need to
run cvsde
command to import the new objects.
> csvde -i -f input.csv
Note that each line of the CSV import file, except the header, should
contain entries to add objects. You cannot modify attributes of an
object or delete objects using csvde
. If you have
a spreadsheet containing objects you want to import, first save it as
a CSV file and use csvde
to import it.
Recipe 4.26 for exporting objects in CSV format, and MS KB 327620 (HOW TO: Use Csvde to Import Contacts and User Objects into Active Directory)
Get Active Directory Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.