Active Directory Contacts Import
AD Bulk Contacts 3.1 USD $99 | Buy Now
Download AD Bulk Contacts
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.
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 |
| 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 | |
