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.
fjal79Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Farhan KaziSystems EngineerCommented:
Make sure there is no carriage return (enter) or any other special characters in following line:
"CN=Danielle Tiedt,OU=Employees,DC=contoso,DC=com",user,dtiedt,Tiedt,Danielle,danielle.tiedt@contoso.com

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
fjal79Author Commented:
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.
0
Farhan KaziSystems EngineerCommented:
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!!



0
brent_caskeyCommented:
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...
0
fjal79Author Commented:
Thanks it was a typo. Tested good now.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.