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
608 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 

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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Always backup Domain, SYSVOL etc.using processes according to Microsoft Best Practices. This is meant as a disaster recovery process for small environments that did not implement backup processes and did not run a secondary domain controller that ne…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

751 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