csvde import shows unspecified errors

After a lot of hassle I seem to be either missing something or Active Directory doesn't like one of the attribute names or one of the entries.
Both on the FSMO server (2008) & secondary controller (2003)
The attached file holds an example..
ee-example.xls
LVL 6
kiwistagAsked:
Who is Participating?
 
kiwistagAuthor Commented:
New note:
Tried using LDIFDE with only 1 user:

Connecting to "domainserver"
Logging in as current user using SSPI
Importing directory from file "test.ldf"
Loading entries
1: CN=FirstName Surname, OU=NewUsers, DC=contoso, DC=com

Add error on entry starting on line 1: No Such Object
The server side error is: 0x208d Directory object not found.
The extended server error is:
0000208D: NameErr: DSID-031001E4, problem 2001 (NO_OBJECT), data 0, best match of:
        'DC=contoso,DC=com'

0 entries modified successfully.
An error has occurred in the program

0
 
kiwistagAuthor Commented:
csv.err shows:

Add error on line 2: No Such Attribute
The server side error is "The parameter is incorrect."
An error has occurred in the programAdd error on line 2: No Such Attribute
The server side error is "The parameter is incorrect."
An error has occurred in the program
0
 
Mike KlineCommented:
What is the error message you are getting?
I noticed in the givenName column you have two entries for the second user
FirstNameB SurnameB
 Did you try adding the -k switch?   That will ignore errors and continue.
Thanks
Mike
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
kiwistagAuthor Commented:
Oops, yeah. Should only be FirstNameB - this wouldn't affect the error though (as modified data to reflect actual).
-k does nothing. It seems to think it's a column heading / attribute name error...
Also ignore duplicate createHomeDirectory attribute..
0
 
kiwistagAuthor Commented:
Also had to add for paths double the backslashes as they wern't representing properly in the csv log...

Connecting to "server"
Logging in as current user using SSPI
Importing directory from file "musac2ads.csv"
Loading entries
2: CN=FirstName Surname,OU=Employees, DC=contoso,DC=com
Attribute 0) objectClass: user
Attribute 1) description: Pupil 2009 - 08/545
Attribute 2) memberOf: CN=Pupils,OU=Pupils,DC=sghs,DC=lan CN=All Pupils,OU=Pupils,DC=sghs,DC=lan
Attribute 3) sAMAccountName: LoginNameA
Attribute 4) displayName: FirstName Surname
Attribute 5) homeDrive: H:
Attribute 6) homeDirectory: \\server\users\LoginNameA
Attribute 7) scriptPath: pupil.bat
Attribute 8) userPrincipalName: LoginNameA@contoso.com
Attribute 9) mail: FirstNameA.SurnameA@contoso.com
Attribute 10) department: Pupils
Attribute 11) sn: SurnameA
Attribute 12) c: NZ
Attribute 13) givenName: FirstNameA
Attribute 14) co: New Zealand
Attribute 15) expires: 02/02/15
Attribute 16) TSProfilePath: \\server\tsprofiles\LoginNameA
Attribute 17) TSCreateHomeDirectory: TRUE
Attribute 18) createHomeDirectory: TRUE

Add error on line 2: No Such Attribute
The server side error is "The parameter is incorrect."
0 entries modified successfully.
An error has occurred in the program


0
 
Mike KlineCommented:
Does it import correctly if you remove the memberof column?   I'm going to try and run some test myself.
Thanks
Mike
0
 
kiwistagAuthor Commented:
Sorry - no. Even modified the memberOf to one security group with no difference.
0
 
kiwistagAuthor Commented:
Ended up using LDIFDE.
Much more info available for debugging and command switches. Downisde is the generation of the file in comparison to a CSV.

Thanks for your help however.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.