asked on

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

kiwistag

ASKER

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

Mike Kline

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

kiwistag

ASKER

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..

kiwistag

ASKER

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

Mike Kline

Does it import correctly if you remove the memberof column? I'm going to try and run some test myself.
Thanks
Mike

kiwistag

ASKER

Sorry - no. Even modified the memberOf to one security group with no difference.

ASKER CERTIFIED SOLUTION

kiwistag

membership

This solution is only available to members.

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

Start Free Trial

kiwistag

ASKER

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.