fieldnames for csvde command

S

Steve March

I am trying to load in new users using the csvde command. In my test lab I
was able to load them in except for a few fields.


The following errors appear:
Connecting to "(null)"
Logging in as current user using SSPI
Importing directory from file "testimportAD.csv"
Loading entries
2: CN=Betty Page,OU=testUsers,DC=testdomain,DC=tst
Add error on line 2: No Such Attribute
The server side error is "The parameter is incorrect."
0 entries modified successfully.
An error has occurred in the program

If I remove the fax, office, and pager fields it works.

Can someone tell me that the Active Directory field names are for the
following fields?

fax number - tried fax and faxNumber
pager number - tried pager and pagerNumber
office - tried office
Country - tried country and also countryCode with a value of '0' for the USA

Can some also give me a complete list of all the fields that can be used and
any other resources on how to use the csvde command?

I did an export and was able to get the following fields:
N,objectClass,cn,description,distinguishedName,instanceType,whenCreated,when
Changed,uSNCreated,
uSNChanged,name,userAccountControl,codePage,countryCode,adminCount,accountEx
pires,sAMAccountName,
objectCategory,primaryGroupID,dSCorePropagationData,displayName,userCertific
ate,localPolicyFlags,
operatingSystem,operatingSystemVersion,dNSHostName,rIDSetReferences,serviceP
rincipalName,
showInAdvancedViewOnly,operatingSystemServicePack,sn,l,st,title,postalCode,p
hysicalDeliveryOfficeName,
telephoneNumber,givenName,co,department,company,homeMTA,proxyAddresses,homeM
DB,streetAddress,
mDBUseDefaults,mAPIRecipient,mailNickname,replicatedObjectVersion,showInAddr
essBook,legacyExchangeDN,
userPrincipalName,textEncodedORAddress,mail,msExchHomeServerName,replication
Signature,
msExchALObjectVersion,msExchADCGlobalNames,msExchMailboxSecurityDescriptor,m
sExchUserAccountControl,
msExchMailboxGuid,dLMemDefault,msExchPoliciesIncluded,deliveryMechanism,syst
emFlags,
msExchHideFromAddressLists,msExchMasterAccountSid,initials,userParameters,ms
NPAllowDialin

Thanks,
Steve March, MCSE
 
J

Jerold Schulman

I am trying to load in new users using the csvde command. In my test lab I
was able to load them in except for a few fields.


The following errors appear:
Connecting to "(null)"
Logging in as current user using SSPI
Importing directory from file "testimportAD.csv"
Loading entries
2: CN=Betty Page,OU=testUsers,DC=testdomain,DC=tst
Add error on line 2: No Such Attribute
The server side error is "The parameter is incorrect."
0 entries modified successfully.
An error has occurred in the program

If I remove the fax, office, and pager fields it works.

Can someone tell me that the Active Directory field names are for the
following fields?

fax number - tried fax and faxNumber
pager number - tried pager and pagerNumber
office - tried office
Country - tried country and also countryCode with a value of '0' for the USA

Can some also give me a complete list of all the fields that can be used and
any other resources on how to use the csvde command?

I did an export and was able to get the following fields:
N,objectClass,cn,description,distinguishedName,instanceType,whenCreated,when
Changed,uSNCreated,
uSNChanged,name,userAccountControl,codePage,countryCode,adminCount,accountEx
pires,sAMAccountName,
objectCategory,primaryGroupID,dSCorePropagationData,displayName,userCertific
ate,localPolicyFlags,
operatingSystem,operatingSystemVersion,dNSHostName,rIDSetReferences,serviceP
rincipalName,
showInAdvancedViewOnly,operatingSystemServicePack,sn,l,st,title,postalCode,p
hysicalDeliveryOfficeName,
telephoneNumber,givenName,co,department,company,homeMTA,proxyAddresses,homeM
DB,streetAddress,
mDBUseDefaults,mAPIRecipient,mailNickname,replicatedObjectVersion,showInAddr
essBook,legacyExchangeDN,
userPrincipalName,textEncodedORAddress,mail,msExchHomeServerName,replication
Signature,
msExchALObjectVersion,msExchADCGlobalNames,msExchMailboxSecurityDescriptor,m
sExchUserAccountControl,
msExchMailboxGuid,dLMemDefault,msExchPoliciesIncluded,deliveryMechanism,syst
emFlags,
msExchHideFromAddressLists,msExchMasterAccountSid,initials,userParameters,ms
NPAllowDialin

Thanks,
Steve March, MCSE
Click to expand...


See if tip 7714 in the 'Tips & Tricks' at http://www.jsiinc.com helps


Jerold Schulman
Windows: General MVP
JSI, Inc.
http://www.jsiinc.com
 
S

Steve March

Thanks! That was helpful. The fields I needed are
'facsimileTelephoneNumber', 'pager', and 'physicalDeliveryOfficeName' for
Windows 2003 AD. But I still haven't been able to enter the country. There
are 3 fields: c, co, and countryCode. Tried all 3 but it didn't show up in
the country field in AD U&C. Anyone know if I could use another command
like dsmod to change the country field for users? I'm using Windows 2003
Active Directory.


 
C

Cary Shultz [A.D. MVP]

Steve,

For the country code you are correct; there are the three attributes that
you listed. Try the following:

c: US
co: United States
countryCode: 840

These work for ldifde so I *hope* that they work with CSVDE.

HTH,

Cary

Steve March said:
Thanks! That was helpful. The fields I needed are
'facsimileTelephoneNumber', 'pager', and 'physicalDeliveryOfficeName' for
Windows 2003 AD. But I still haven't been able to enter the country. There
are 3 fields: c, co, and countryCode. Tried all 3 but it didn't show up in
the country field in AD U&C. Anyone know if I could use another command
like dsmod to change the country field for users? I'm using Windows 2003
Active Directory.
Click to expand...
 
Top