Solved

Hi!  I need help fixing a DN syntax error in a csv I am using to import a number of users into AD.

Posted on 2009-05-12
6
601 Views
Last Modified: 2012-05-07
When I run the CSVDE command to import users into AD, I get this error:
Connecting to "smtest.smtestdom"
Logging in as current user using SSPI
Importing directory from file "1usertest.csv"
Loading entries
2: CN=Lonely Test,OU=Test Users,dc=smtestdom
Attribute 0) objectClass: user
Attribute 1) sAMAccountName: Ltest
Attribute 2) initials: F
Attribute 3) givenName: Lonely
Attribute 4) sn: Test
Attribute 5) cn: CN=Lonely Test
Attribute 6) ou: Test Users
Attribute 7) dc: smtestdom
Attribute 8) securityMediatorSSN: 123-45-6789
Attribute 9) securityMediatorClassifications: Apples
Attribute 10) securityMediatorCodewords: Seeds

Add error on line 2: Invalid DN Syntax
The server side error is "Multiple values were specified for an attribute that can have only one value."
0 entries modified successfully.
An error has occurred in the program
HELP!   Thank you!
0
Comment
Question by:hdk001
  • 3
  • 2
6 Comments
 
LVL 57

Expert Comment

by:Mike Kline
ID: 24366574
Try putting quotes around "CN=Lonely Test"
See if that helps you
Thanks
Mike
0
 

Author Comment

by:hdk001
ID: 24366814
Thanks Mike but that did not work.  I'm still getting a syntax error with the DN.  I checked for spaces, comma placement, everything.  I am at my wits end!  What could be the problem???
0
 
LVL 57

Assisted Solution

by:Mike Kline
Mike Kline earned 20 total points
ID: 24366880
Did you also try quotes around OU=test users,  not sure.  I'll try to test if I have time
Thanks
MIke
0
Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 

Author Comment

by:hdk001
ID: 24367693
We have tried the double quotes around the cn and also around the ou. When we use quotes the error is actually different and states "invalid parameter", which I believe is just due to the quotes.  Eventually this will be to import 4600+ users, but we're trying to test with just a dummy account for now to get the formatting correct.  We have used the other solutions on here to work through some other issues, but this one is holding us up. Thanks for your assistance.
0
 
LVL 2

Accepted Solution

by:
Aaron_Denton earned 480 total points
ID: 24367845
I've found this page to be a good reference.  Especially the sample import file.
http://www.computerperformance.co.uk/Logon/Logon_CSVDE_Bulk.htm
Also, http://www.computerperformance.co.uk/Logon/Logon_CSVDE_Errors.htm
I would do as it suggets and start with just the minimal set of 3 values to get the import working and then add more info if you need to one field at a time to determine which one is tripping you up.
0
 

Author Closing Comment

by:hdk001
ID: 31581911
The minimal set of 3 was the catalyst that helped me figure out the rest. The tool was erroring out because some of the LDAP fields were seen as dupilcates.  After getting rid of the other fields it still didn't work.  So I arranged the colums in the exact order that the example used( from the article) and it worked!  Thanks!
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
AD backup 6 58
How to check if user has full access mailbox permission in Active Directory? 5 43
Run Secure WMI query from CentOS 5 33
VBA name newly created sheet 4 24
Resolve DNS query failed errors for Exchange
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question