We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

csvde import shows unspecified errors

Medium Priority
1,652 Views
Last Modified: 2012-05-06
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
Comment
Watch Question

Author

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
CERTIFIED EXPERT
Top Expert 2013

Commented:
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

Author

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

Author

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


CERTIFIED EXPERT
Top Expert 2013

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

Author

Commented:
Sorry - no. Even modified the memberOf to one security group with no difference.
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

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.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.