• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2112
  • Last Modified:

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

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.
Kyle Weingardt
Kyle Weingardt
  • 3
1 Solution
Esther Freeman ,Freeman,

Any chance that space has anything to do with it?
Could it be that the value already exists in AD? wouldn't think it would be that simple but who knows.
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.
You could try using the actual Account logon name syntax and not the first and last name.
Kyle WeingardtAuthor Commented:
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!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now