Options

Import User Objects Using CSVDE

dfjamadfjama Banned Posts: 63 ■■□□□□□□□□
In preparation of my 290 exam using Microsft Press Book I am now in chapter 3 User Accounts, reading and practicing all the exercises throughout the book, I coulnd get right the following exercise:

Exercise 3: Import User Objects Using CSVDE
1. Open Notepad.
2. Type the following information carefully, creating 3 lines of text:
DN,objectClass,sAMAccountName,sn,givenName,userPrincipalName
"CN=Danielle Tiedt,OU=Employees,
DC=contoso,DC=com",user,dtiedt,Tiedt,Danielle,danielle.tiedt@contoso.com
"CN=Lorrin Smith-Bates,OU=Employees, DC=contoso,DC=com",user,lsmithbates,Smith-
Bates,Lorrin,lorrin.smithbates@contoso.com
3. Save the file as “C:\USERS.CSV” being certain to surround the filename with quote
marks. Without quote marks, the file will be saved as C:\USERS.CSV.TXT.
4. Open the command prompt and type the following command: csvde –i -f c:\users.csv
5. If the command output confirms that the command completed successfully, open Active
Directory Users and Computers to confirm that the objects were created. If the
command output suggests that there were errors, open the USERS.CSV file in Notepad
and correct the errors.
6. You will log on as these users later in this chapter. Because the users were imported
without passwords, you must reset their passwords. Once the passwords have been
configured, enable the accounts. Both the Reset Password and Enable Account
commands
can be found on either the Action or Objects shortcut menu.
7. If you have access to an application that can open comma-delimited text files, such as
Microsoft Excel, open C:\USERS.CSV. You will be able to interpret its structure more
easily in a columnar display than in Notepad’s one-line, comma-delimited text file display.

How to save the three line text being certain to surround the filename with quote marks, before running the following command:
csvde –i -f c:\users.csv

Your Feedback will be appreciated.

Comments

  • Options
    dynamikdynamik Banned Posts: 12,312 ■■■■■■■■■□
    What error are you getting? I usually see people have problems when they have a different domain name or the OU is different or doesn't exist.
  • Options
    ClaymooreClaymoore Member Posts: 1,637
    You don't need the quotes in line 3 if you use the Save As function.
    Open Notepad
    File -- Save As
    Change Save As Type to All Files
    Name the file Users.csv

    Notepad wants to append the .txt extension when you let it save in the default format.
Sign In or Register to comment.