asked on

Unable to import user objects using CSVDE

I was doing one of the lab exercises found in the 70-290 MS press book on page 3-29 and received an error message after typing the information word for word. I had already created OU for employees.

DN,objectClass,sAMAccountName,sn,givenName,userPrincipalName
"CN=Danielle Tiedt,OU=Employees,DC=contoso,DC=com",
user,dtiedt,Tiedt,Danielle,danielle.tiedt@contoso.com
"CN=Smith-Bates,OU=Employees,DC=constoso,DC=com",
user,lsmithbates,Smith-Bates,Lorrin,lorrin.smithbates@contoso.com

I type this in at the command prompt: csvde -i -f c:\users.csv

This is the error message in command:
C:\Documents and Settings\Administrator>csvde -i -f c:\users.csv
Connecting to "(null)"
Logging in as current user using SSPI
Importing directory from file "c:\users.csv"
Loading entries.
Add error on line 2: Object Class Violation
The server side error is "The object class attribute must be specified."
0 entries modified successfully.
An error has occurred in the program
No log files were written. In order to generate a log file, please
specify the log file path via the -j option.

ASKER CERTIFIED SOLUTION

Farhan Kazi

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

fjal79

ASKER

Thanks, but only one entry was entered, not the other person (Lorrin Smith-Bates).
DN,objectClass,sAMAccountName,sn,givenName,userPrincipalName
(I entered one line)
"CN=Smith-Bates,OU=Employees,DC=constoso,DC=com",user,lsmithbates,Smith-Bates,Lorrin,lorrin.smithbates@contoso.com

This is the error message:
C:\Documents and Settings\Administrator>csvde -i -f c:\users.csv
Connecting to "(null)"
Logging in as current user using SSPI
Importing directory from file "c:\users.csv"
Loading entries.
Add error on line 2: Referral
The server side error is "A referral was returned from the server."
0 entries modified successfully.
An error has occurred in the program
No log files were written. In order to generate a log file, please
specify the log file path via the -j option.

Farhan Kazi

Make sure you are providing correct user DN... Like I see different domains in both lines like:
"CN=Danielle Tiedt,OU=Employees,DC=contoso,DC=com"
"CN=Smith-Bates,OU=Employees,DC=constoso,DC=com"
is it contoso or constoso!!

brent_caskey

farhankazi is correct.
I have been trying to reproduce the error in my test domain and there wasnt an issue. It was because I changed the domain names and avoided the typo...

fjal79

ASKER

Thanks it was a typo. Tested good now.