• Skip to primary navigation
  • Skip to content
  • Skip to footer
Dovestones Software Logo

Dovestones Software

Active Directory Software and Services

  • Products
    • AD Toolset Bundle
      • AD Bulk Users
      • AD Bulk Contacts
      • AD Reporting
      • AD Bulk Export
      • AD Photos
      • AD Find and Replace
      • True Last Logon
    • Active Directory Self Service
      • AD Self Password Reset
      • AD Phonebook
      • AD Self Update
  • Solutions
    • Active Directory Self Service
    • Import users into Active Directory
    • Import Active Directory photos into SharePoint
    • Update users that already exist in Active Directory
    • Report on Active Directory Users
    • Allow users to reset their own passwords.
    • Allow employees to update their own details Active Directory
  • Testimonials
  • Downloads
  • Purchase
    • Pricing & Purchase Online
      • Resellers
    • Purchase Orders
      • Quote Request
  • Support
    • Frequently Asked Questions (FAQs)
    • Documentation
    • Support Request Form
    • Uninstall Products
    • Find my license key
    • Blog
    • Videos
  • About Us
    • Enquiry Form
    • End User License Agreement
    • Privacy Policy

AD Bulk Contacts Features

Import and Modify Active Directory Contacts in bulk

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:

mailEnabled,mailNickname,proxyAddresses,targetAddress Example:

mailEnabled,mailNickname,targetAddress,proxyAddresses True,jsmith,SMTP:[email protected],SMTP:[email protected];smtp:[email protected]

Wildcards

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

%firstname% (reads the value found in the givenName column)
%lastname% (reads the value found in the sn column)
%givenName% (reads the value found in the givenName column)
%sn% (reads the value found in the sn column)
%initials% (reads the value found in the initials column)
%email% (reads the value found in the mail column)
%firstNamefirst% (reads the first letter of the value found in the givenName column)
%firstNamelast% (reads the last letter of the value found in the givenName column)
%lastNamefirst% (reads the first letter of the value found in the sn column)
%lastNamelast% (reads the last letter of the value found in the sn column)

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:

/username Username of a user with permissions to create users.
/password Password for above user.
/server Domain Controller used to create users.
/path The LDAP path to where the contacts should be imported.
/file Path to the import file.
/import Starts the import process.
/modify Modifies the contacts found in the CSV file or DB table.
/leaveOpen Leaves the GUI open after a command line import.
/log Saves the log to the specified file.
/addContactsToGroups Adds Contacts to the group specified in the memberOf column (default).
/removeContactsFromGroups Removes Contacts from the group specified in the memberOf column.
/sqlServer The SQL server where the database lives.
/dbUsername Username used to connect to the SQL server.
/dbPassword Password used to connect to the SQL server.
/database The database containing the contacts table.
/table The table that contains the contacts to be imported/updated.

Supported Attributes List


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

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 [email protected]
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 mailEnabled TRUE or FALSE
Exchange Alias mailNickname Jsmith
Exchange Email proxyAddresses SMTP:[email protected] (Internal E-Mail Address)
Email Addresses targetAddress SMTP:[email protected] (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
Automatically update e-mail addresses based on recipient policy AutoUpdateOnRecipientPolicy TRUE or FALSE
  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

Footer

Dovestones Software

Copyright 2005 – 2023 © Infoopia Inc.
All rights reserved.

Registered office:

Infoopia Inc.
PO Box 93383
Newmarket Ontario
L3X 1A3
Canada

Phone (voice mail):
Toll-Free 1.877.335.8909
Outside of US/Canada +1.647.478.8078

Our Newsletter

Subscribe to our newsletter to receive the latest updates. You can review our privacy policy here.