Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

CSVDE Import Error: Invalid DN Syntax "Multiple values were specified for an attribute that can have only one value."

Posted on 2009-04-10
5
Medium Priority
?
2,030 Views
Last Modified: 2012-05-06
I am trying to import a csv with a few hundred contacts.  I successfully imported one csv file with about 20 contacts as a test.  However, when trying to import the final csv document I am getting this error.  I've checked the syntax over and over again, and compared it to the record right before it (which was imported successfully) and cannot spot any difference.  

A sample from CSV file (sample.txt) and csv.log are attached.  

Any help is appreciated.  Thanks in advance.
csv.log
sample.txt
0
Comment
Question by:Kyle Weingardt
  • 3
5 Comments
 
LVL 3

Accepted Solution

by:
zrobinson earned 500 total points
ID: 24116151
Esther Freeman ,Freeman,

Any chance that space has anything to do with it?
0
 
LVL 6

Expert Comment

by:mickeyfan
ID: 24116156
Could it be that the value already exists in AD? wouldn't think it would be that simple but who knows.
0
 
LVL 6

Expert Comment

by:mickeyfan
ID: 24116171
Nevermind on the existing value..

The space wouldn't have anything to do with it unless there is no space in the Actual DN in AD. the syntax has to be exact.
0
 
LVL 6

Expert Comment

by:mickeyfan
ID: 24116180
You could try using the actual Account logon name syntax and not the first and last name.
0
 

Author Comment

by:Kyle Weingardt
ID: 24116191
Actually it appears the space has everything to do with it!  The cn field of the csv had a space whereas the DN field did not.  Once I removed the space the record imported successfully.... then failed again on the 7th record.  Once I checked the 7th record it was a space issue again.  I'll have to go through the csv file more carefully.  

Thank you for your help!
0

Featured Post

Problems using Powershell and Active Directory?

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

Question has a verified solution.

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

Want to know how to use Exchange Server Eseutil command? Go through this article as it gives you the know-how.
Are you looking for the options available for exporting EDB files to PST? You may be confused as they are different in different Exchange versions. Here, I will discuss some options available.
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.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the adminiā€¦
Suggested Courses

971 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