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

Posted on 2009-04-10
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.
Question by:Kyle Weingardt
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

Accepted Solution

zrobinson earned 125 total points
ID: 24116151
Esther Freeman ,Freeman,

Any chance that space has anything to do with it?

Expert Comment

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

Expert Comment

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.

Expert Comment

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

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!

Featured Post

Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

Question has a verified solution.

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

Suggested Solutions

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
A hard and fast method for reducing Active Directory Administrators members.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

752 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