Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

Posted on 2009-04-10
Medium Priority
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
  • 3

Accepted Solution

zrobinson earned 500 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

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Among the most obnoxious of Exchange errors is error 1216 – Attached Database Mismatch error of the Jet Database Engine. When faced with this error, users may have to suffer from mailbox inaccessibility and in worst situations, permanent data loss.
Microsoft Jet database engine errors can crop up out of nowhere to disrupt the working of the Exchange server. Decoding why a particular error occurs goes a long way in determining the right solution for it.
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…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Suggested Courses

580 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