CSVDE

G

Guest

I am trying to import about 14,000 users into AD an keep getting an error. It
reads:
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

I have verified (an re-verified) that the DN on my csv is correct but it
will still not go! Any ideas?
 
H

Herb Martin

Patrick said:
I am trying to import about 14,000 users into AD an keep getting an error. It
reads:
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

I have verified (an re-verified) that the DN on my csv is correct but it
will still not go! Any ideas?

Maybe divide it into chunks and see if the error
is prevalent or isolated.

Get it down to only one or two records that give
the error and then try to attack the problem
specifically or show the listing here?

This may not be what you wish to hear but in
general LDIFDE has more features and flexibility.

You might have to reformat the list with a Perl
script or some such.
 
A

Ace Fekay [MVP]

In Patrick <[email protected]> made a post then I commented
below
:: I am trying to import about 14,000 users into AD an keep getting an
:: error. It reads:
:: 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
::
:: I have verified (an re-verified) that the DN on my csv is correct
:: but it will still not go! Any ideas?

If I read your post correctly, you are trying to modify existing records
with CSVDE or import new objects?

If trying to modify eisting objects, I just want to point out CSVDE is not
for modifying objects, just to create or import new objects or export
objects. LDIFDE can be used to import, export or modify objects.

If you are importing new records, as Dean and Herb requested, maybe you can
post one of the records you are trying to import.


--
Regards,
Ace

G O E A G L E S !!!
Please direct all replies ONLY to the Microsoft public newsgroups
so all can benefit.

This posting is provided "AS-IS" with no warranties or guarantees
and confers no rights.

Ace Fekay, MCSE 2003 & 2000, MCSA 2003 & 2000, MCSE+I, MCT, MVP
Microsoft Windows MVP - Windows Server - Directory Services

Security Is Like An Onion, It Has Layers
HAM AND EGGS: A day's work for a chicken;
A lifetime commitment for a pig.
 
G

Guest

Yep. I am not modifying exsisting records by the way. These are all new
accounts.
A portion of the header:
DN,objectClass,cn,description,distinguishedName
and the dat
CN=brandon,OU=Brokers,DC=testcompany,DC=com,user,brandon,CN=brandon,OU=Brokers,DC=testcompany,DC=com



Dean Wells said:
Can you post a snippet of the file that caused the error?

--
Dean Wells [MVP / Directory Services]
MSEtechnology
[[ Please respond to the Newsgroup only regarding posts ]]
R e m o v e t h e m a s k t o s e n d e m a i l
I am trying to import about 14,000 users into AD an keep getting an
error. It reads:
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

I have verified (an re-verified) that the DN on my csv is correct but
it will still not go! Any ideas?
 
G

Guest

Okay, I did some more research and when I use the User's name, I get an
import. Could it be that the DN and saMAccountName cannot be the same? I'm
using the saMAccountName attribute because it is far more unique in my import
file. I'm also wondering, is there a min/max character setting for the user
account name?
-Patrick
 
G

Guest

Ace/Dean,
Amazing what happens when you take a systematic approach! I had two
different values for my CN. I figured it out. Sorry to waste your time!
-Patrick
 
D

Dean Wells [MVP]

Enclosed is a workable file -

DN,objectClass,cn,description,samaccountname

"CN=brandon,DC=ourcompany,DC=com",user,brandon,here is the
description,brandon

NOTE the use of quotation marks around the DN and that this will create
a disabled account.

--
Dean Wells [MVP / Directory Services]
MSEtechnology
[[ Please respond to the Newsgroup only regarding posts ]]
R e m o v e t h e m a s k t o s e n d e m a i l
Yep. I am not modifying exsisting records by the way. These are all
new accounts.
A portion of the header:
DN,objectClass,cn,description,distinguishedName
and the data
CN=brandon,OU=Brokers,DC=testcompany,DC=com,user,brandon,CN=brandon,OU=Brokers,DC=testcompany,DC=com



Dean Wells said:
Can you post a snippet of the file that caused the error?

--
Dean Wells [MVP / Directory Services]
MSEtechnology
[[ Please respond to the Newsgroup only regarding posts ]]
R e m o v e t h e m a s k t o s e n d e m a i l
I am trying to import about 14,000 users into AD an keep getting an
error. It reads:
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

I have verified (an re-verified) that the DN on my csv is correct
but it will still not go! Any ideas?
 
A

Ace Fekay [MVP]

In Patrick <[email protected]> made a post then I commented
below
:: Ace/Dean,
:: Amazing what happens when you take a systematic approach! I had two
:: different values for my CN. I figured it out. Sorry to waste your
:: time! -Patrick

No problem, Patrick. That's what we're here for.

Happy New Year!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top