kiwistag
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
Both on the FSMO server (2008) & secondary controller (2003)
The attached file holds an example..
ee-example.xls
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
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
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..
-k does nothing. It seems to think it's a column heading / attribute name error...
Also ignore duplicate createHomeDirectory attribute..
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=sgh s,DC=lan CN=All Pupils,OU=Pupils,DC=sghs,D C=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@contos o.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\LoginN ameA
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
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=sgh
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@contos
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\LoginN
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
Does it import correctly if you remove the memberof column? I'm going to try and run some test myself.
Thanks
Mike
Thanks
Mike
ASKER
Sorry - no. Even modified the memberOf to one security group with no difference.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
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