CSVDE Utility

[Mike Nolet]

I am trying to do a bulk import of over 300 user accounts
into ADS (on a win2K box) with Exchange 2000. I want to
create both user accounts and exchange mailboxes using
the CSVDE import utility.

Server Information is as follows:

name: vha-svr-01
ADS name space: vhaottawa.ca
Netbios domain name: vha-ottawa

When using the CSVDE import utility I am receiving the
following error.

Connecting to "(null)"
Logging in as current user using SSPI
Importing directory from file "c:\import.csv"
Loading entries.
Add error on line 2: Constraint Violation
The server side error is "A required attribute is
missing."

0 entries modified successfully.
An error has occurred in the program

The log displays the following information:

Connecting to "(null)"
Logging in as current user using SSPI
Importing directory from file "c:\import.csv"
Loading entries
2: CN=Lauren Levesque,CN=Users,DC=vhaottawa,DC=ca
Attribute 0) instanceType: 4
Attribute 1) distinguishedName: CN=Lauren
Levesque,CN=Users,DC=vhaottawa,DC=ca
Attribute 2) objectCategory:
CN=Person,CN=Schema,CN=Configuration,DC=vhaottawa,DC=ca
Attribute 3) objectClass: user
Attribute 4) name: Lauren Levesque
Attribute 5) cn: Lauren Levesque
Attribute 6) displayName: Lauren Levesque
Attribute 7) givenName: Lauren
Attribute 8) userPrincipalName: (e-mail address removed)
Attribute 9) homeMDB: CN=Mailbox Store (VHA-SVR-
01),CN=First Storage Group,CN=InformationStore,CN=VHA-SVR-
01,CN=Servers,CN=First Administrative
Group,CN=Administrative Groups,CN=VHA Health and Home
Care,CN=Microsoft
Exchange,CN=Services,CN=Configuration,DC=vhaottawa,DC=ca
Attribute 10) mail: (e-mail address removed)
Attribute 11) legacyExchangeDN: /o=VHA Health and Home
Care/ou=First Administrative Group/cn=Recipients/cn=
llevesque
Attribute 12) proxyAddresses: SMTP:[email protected]
X400:c=us;a= ;p=VHA Health and
H;o=Exchange;s=Levesque;g=Lauren;
Attribute 13) showInAddressBook: CN=Default Global
Address List,CN=All Global Address Lists,CN=Address Lists
Container,CN=VHA Health and Home Care,CN=Microsoft
Exchange,CN=Services,CN=Configuration,DC=vhaottawa,DC=ca
CN=All Users,CN=All Address Lists,CN=Address Lists
Container,CN=VHA Health and Home Care,CN=Microsoft
Exchange,CN=Services,CN=Configuration,DC=vhaottawa,DC=ca
Attribute 14) textEncodedORAddress: c=us;a= ;p=VHA Health
and H;o=Exchange;s=Levesque;g=Lauren;
Attribute 15) homeMTA: CN=Microsoft MTA,CN=VHA-SVR-
01,CN=Servers,CN=First Administrative
Group,CN=Administrative Groups,CN=VHA Health and Home
Care,CN=Microsoft
Exchange,CN=Services,CN=Configuration,DC=vhaottawa,DC=ca
Attribute 16) msExchHomeServerName: /o=VHA Health and
Home Care/ou=First Administrative
Group/cn=Configuration/cn=Servers/cn=VHA-SVR-01
Attribute 17) mailNickname: llevesque
Attribute 18) mDBUseDefaults: TRUE
Attribute 19) sn: Levesque

Add error on line 2: Constraint Violation
The server side error is "A required attribute is
missing."
0 entries modified successfully.
An error has occurred in the program



Below is the contents of the .csv file I am trying to
import:

DN,instanceType,distinguishedName,objectCategory,objectCla
ss,name,cn,displayName,middleName,givenName,userPrincipalN
ame,homeMDB,mail,legacyExchangeDN,proxyAddresses,showInAdd
ressBook,textEncodedORAddress,homeMTA,msExchHomeServerName
,mailNickname,mDBUseDefaults,sn
"CN=Lauren
Levesque,CN=Users,DC=vhaottawa,DC=ca",4,"CN=Lauren
Levesque,CN=Users,DC=vhaottawa,DC=ca","CN=Person,CN=Schema
,CN=Configuration,DC=vhaottawa,DC=ca",user,Lauren
Levesque,Lauren Levesque,Lauren
Levesque,,Lauren,[email protected],"CN=Mailbox Store
(VHA-SVR-01),CN=First Storage
Group,CN=InformationStore,CN=VHA-SVR-
01,CN=Servers,CN=First Administrative
Group,CN=Administrative Groups,CN=VHA Health and Home
Care,CN=Microsoft
Exchange,CN=Services,CN=Configuration,DC=vhaottawa,DC=ca",
(e-mail address removed),/o=VHA Health and Home
Care/ou=First Administrative Group/cn=Recipients/cn=
llevesque,SMTP:[email protected];X400:c=us\;a=
\;p=VHA Health and
H\;o=Exchange\;s=Levesque\;g=Lauren\;,"CN=Default Global
Address List,CN=All Global Address Lists,CN=Address Lists
Container,CN=VHA Health and Home Care,CN=Microsoft
Exchange,CN=Services,CN=Configuration,DC=vhaottawa,DC=ca;C
N=All Users,CN=All Address Lists,CN=Address Lists
Container,CN=VHA Health and Home Care,CN=Microsoft
Exchange,CN=Services,CN=Configuration,DC=vhaottawa,DC=ca",
c=us\;a= \;p=VHA Health and
H\;o=Exchange\;s=Levesque\;g=Lauren\;,"CN=Microsoft
MTA,CN=VHA-SVR-01,CN=Servers,CN=First Administrative
Group,CN=Administrative Groups,CN=VHA Health and Home
Care,CN=Microsoft
Exchange,CN=Services,CN=Configuration,DC=vhaottawa,DC=ca",
/o=VHA Health and Home Care/ou=First Administrative
Group/cn=Configuration/cn=Servers/cn=VHA-SVR-
01,llevesque,TRUE,Levesque


Any help would be great....Thanks

 

[Al Dunbar [MS-MVP]]

I am trying to do a bulk import of over 300 user accounts
into ADS (on a win2K box) with Exchange 2000. I want to
create both user accounts and exchange mailboxes using
the CSVDE import utility.

Server Information is as follows:

name: vha-svr-01
ADS name space: vhaottawa.ca
Netbios domain name: vha-ottawa

When using the CSVDE import utility I am receiving the
following error.

Connecting to "(null)"
Logging in as current user using SSPI
Importing directory from file "c:\import.csv"
Loading entries.
Add error on line 2: Constraint Violation
The server side error is "A required attribute is
missing."

0 entries modified successfully.
An error has occurred in the program

Seems to me you are missing the sAMAccount name attribute. This is one of
the minimum requirements when creating accounts with script, whereas MMC
generally fills it in for you. Not sure about CSVDE, but...

/Al

 

[Andreas]

You might be interested in AdmWin. http://www.admwin.com. Click the
SetupBatcher script wizard button and select "Active directory with Exchange
200X server: create / delete accounts and mailboxes".

Regards
Andreas