Home|Customer Comments|Products|Buy Now |Support|About us

Active Directory Contacts Import

AD Bulk Contacts 3.1                                                                        USD $99 | Buy Now
download Download AD Bulk Contacts

Back to previous page

List of supported Attributes

The Interface

The interface is designed so that you can see each attribute that will be imported for each contact. Using the Previous and Next buttons you can check through your import file making sure each contact will be imported correctly. If you notice a mistake simply amend it using the interface. To the right you'll see a log of how your import is progressing, you can save and print the log should you require.

Import from Excel, CSV file or Microsoft SQL Server

The import file can be formatted using the CSV (comma separated value) format or SKV (semicolon separated value) format allowing easy preparation using a spreadsheet program such as Excel.

You can choose to import from a standard CSV file or from an ODBC source such a SQL server.

You can import any of the contact attributes found below and place them in the import file in any order. As shown in the example below, row 1 contains the column header, this is the attribute name you wish to import such as givenName (first name). The attribute names can be placed in any order, you don't need to use all the attributes names, simply add the attributes you require. The column header (givenName,sn,description) tells the program what to expect in the rows beneath. Using a spreadsheet allows you to construct the file quickly or import your contacts data from elsewhere.

Example import file

Modify Existing Contacts

AD Bulk Contacts can be used to modify existing Active Directory Contacts. This is done by adding the column header 'Modify' to the import file and setting the value to 'TRUE'.

To modify a contacts 'description' attribute, the following would be required in the import file (CSV):

CN,description,Modify
Joe Smith,Accountant,TRUE

The Contacts Common Name (CN) is used to locate the contact in Active Directory, as seen in the example above.

Microsoft Exchange Support

To mail-enable contacts for Microsoft Exchange, the following column headers are required in the import file:

EnableExchangeMail,mailNickname,proxyAddresses,targetAddress

Example:

EnableExchangeMail,mailNickname,targetAddress,proxyAddresses
True,jsmith,SMTP:jsmith@external.com,SMTP:jsmith@external.com;smtp:jsmith@internal.com

Working with Exchange 2007

When mail-enabling contacts for Exchange 2007 your CSV file must also contain a CN column and the primary address (upper case SMTP) in the proxyAddresses column must match the targetAddress.

Example:

targetAddress,proxyAddresses
SMTP:jsmith@external.com,SMTP:jsmith@external.com;smtp:jsmith@internal.com

Wildcards

The following wildcards can be used throughout your CSV file/SQL table:

%firstname% (givenName, First name)
%lastname% (sn, Last name)
%initials% (initials,Initials)
%email% (mail, E-Mail)

Command Line Arguments

Automate your import tasks by using the following command line arguments.
ADBulkContacts /path:OU=,DC=Domain,DC=Com /file:import.csv /import
/log:file.log

Arguments:

/path
The LDAP path to where the contacts should be imported.
/file
Path to the import file.
/import
Starts the import process.
/leaveOpen
Leaves the GUI open after a command line import.
/log
Saves the log to the specified file.

Supported Attributes List

Please note all column headers to be used in the import file are case sensitive.

Printable list of supported attributes
Top

General Tab
Display Name LDAP Attribute Name
(column headers in CSV file)
Example Value
Contact Name CN John Smith
First Name givenName John
Initials initials JS
Last Name sn Smith
Display Name displayName "John, Smith"
Description description Sales Manager
Office physicalDeliveryOfficeName London Office
Telephone Number telephoneNumber 0123 456 789
Telephone Number (Other) otherTelephone 0123 4457 89
Email mail JSmith@domain.com
Web Page wWWHomePage www.johnsmith.com
Web Page (Other) url "www.John.net,www.John.org"
Destination OU destinationOU "OU=Sales,DC=Domain,DC=Com"
Modify contact if already exists Modify TRUE or FALSE
Delete the Contact Delete TRUE or FALSE
Address Tab
Display Name LDAP Attribute Name
(column headers in CSV file)
Example Value
Street streetAddress 10 The Road
PO Box postOfficeBox Po Box 1
City l London
State/Province st New York
Zip/Postal Code postalCode 614415
Country c GB See country code list here
Group Tab
Display Name LDAP Attribute Name
(column headers in CSV file)
Example Value
Group memberOf "OU=Contacts,DC=Domain,DC=Com"
Telephones Tab
Display Name LDAP Attribute Name
(column headers in CSV file)
Example Value
Home homePhone 660 123 122
Home (Other) otherHomePhone 0661 123 122
Pager pager 1234
Pager (Other) otherPager 123
Mobile mobile 120 456 789
Mobile (Other) otherMobile 121 456 789
Fax facsimileTelephoneNumber 122 456 789
Fax (Other) otherFacsimile
TelephoneNumber
0123 456 789
IP Phone ipPhone 01IP
IP Phone (Other) otherIpPhone IP1
Information info Information
Organization Tab
Display Name LDAP Attribute Name
(column headers in CSV file)
Example Value
Title title Manager
Department department Sales
Company company Big Corp
Manager manager "CN=SJobs,OU=Sales,DC=Domain,DC=Com"
Exchange Tab
Display Name LDAP Attribute Name
(column headers in CSV file)
Example Value
Mail enable Contact EnableExchangeMail TRUE or FALSE
Exchange Alias mailNickname Jsmith
Exchange Email proxyAddresses SMTP:JSmith@internal.com
(Internal E-Mail Address)
Email Addresses targetAddress SMTP:JSmith@external.com
(External E-Mail Address)
Simple Display Name displayNamePrintable Jsmith
Hide from address book msExchHideFromAddressLists TRUE or FALSE
Use MAPI rich text mAPIRecipient Needs to be set to FALSE for Contacts
Exchange Attributes
Display Name LDAP Attribute Name
(column headers in CSV file)
Example Value
extensionAttribute1 extensionAttribute1  
extensionAttribute2 extensionAttribute2  
extensionAttribute3 extensionAttribute3  
extensionAttribute4 extensionAttribute4  
extensionAttribute5 extensionAttribute5  
extensionAttribute6 extensionAttribute6  
extensionAttribute7 extensionAttribute7  
extensionAttribute8 extensionAttribute8  
extensionAttribute9 extensionAttribute9  

Top

All products include 12 months support and free updates. Site, Enterprise and Consultant Licenses are available.

Customer Comment:

David Branscome University of California Office of the President

"I think your products are great and you provide exceptional support."

More comments...

OISV - Organization of Independent Software Vendors - Contributing Member

Valid XHTML 1.1