Bulk administration tool download

Put the two files into one zip file. Make a operations guide for user. Publish for Office 32bit and 64bit version. The default download is for 32bit Office. Fix some small bugs. Project Description This is an AD bulk administration tool for AD administrator to administer bulk Active Directory users, you can use it to check bulk users, create bulk users, reset bulk users' passwords, enable or disable bulk users, set bulk users' properties, check bulk groups, add bulk users to group or remove bulk users from group.

System Requirements. After you have configured the initial template information, click Insert to add the template to the BAT utility.

After configuring the initial template settings, you can modify specific line configurations. From the initial template window, choose a line to configure, and a new configuration window appears.

These general configuration settings can apply to multiple IP Phones, such as partitions, calling search spaces, and call waiting settings.

BAT obtains line configurations that are specific to the user from the imported Microsoft Excel spreadsheet. When you are adding a group of phones that have multiple lines, you can create a master phone template that provides multiple lines and the most common values for a specific phone model.

You can use the master template to add phones that have differing numbers of lines, but do not exceed the number of lines in the master phone template. For example, you can create a master phone template for a Cisco IP Phone that has six lines. You can use this single template to add phones that have one line, two lines, or up to six lines because the template provides the base configuration for up to six lines. Make sure that all phones and devices in a CSV data file are the same phone or device model and match the BAT template.

You can use the override feature for special configuration cases. You can add multiple devices and view the records for each device in a spreadsheet format. It allows you to customize the file format within the spreadsheet and provides validation and error checking automatically to help reduce configuration errors.

Figure shows the BAT. You probably do not have Microsoft Excel running on the publisher, so you must copy the file to a local machine using either a floppy disk or a mapped network drive. After you have copied the file, double-click BAT. When prompted, click Enable Macros. The BAT spreadsheet includes tabs along the bottom of the spreadsheet for access to the required data input fields for the various devices and user combinations in BAT.

The values from the BAT phone template are used for these fields; however, if you specify values for Forward Busy Destination or Call Pickup Group, those values override the values for these fields that were set in the BAT phone template. The format for CSV files is. Using a text editor is the other way to create a CSV file.

When using a text editor, follow these steps:. The file format specifies the order in which you enter values in the text file. This allows you to add attributes to the file format that are also in the BAT template, and override the template entry with a specific attribute for a device. For instance, you can choose the route partition attribute for your file format and enter different partitions for each phone in the CSV data file.

Earlier versions of BAT supported only a default file format with a fixed and limited number of attributes and settings for each device and an All Details format that includes all attributes and settings for each device. Create the CSV data file using a basic text editor that follows the file format you defined in Step 1.

You can associate only one file format with a CSV data file. Next, you choose your file format from the File Format Name drop-down menu. The data in the CSV data file must match the custom file format that you have chosen. In the next task in the BAT wizard, you use the Validate option, shown in Figure , to validate the format of the text file you have chosen.

You have these options for how records are validated:. When you choose Validate, the system runs a validation routine to check for errors against the publisher database. These checks ensure the following:. Validation does not check for the existence of a user or for mandatory or optional fields that are BAT-defined, such as the dummy MAC address.

Inserting the device into the Cisco CallManager database is the last step in using BAT to perform bulk configurations, shown in Figure The numeric or alphanumeric identifier assigned to a user, typically based on order of hire or association with an organization.

The initials of part or all of the user name. Use the Windows language code, such as for U. For a list of supported languages and the corresponding language codes, see the "Numeric and Alphabetic Codes for Supported Languages" section in the System Requirements for Cisco Unity Connection The name of the manager or supervisor of the user. For users located in the United States, the zip code where the user is located, or with which the user is associated.

For users located in Canada, Mexico, and other countries, the postal code where the user is located, or with which the user is associated.

The full name of the state or province where the user is located, or with which the user is associated. The time zone with which the user account is associated. The position or function of the user within the organization, for example "Vice President.

The unique text name that is displayed on the user interfaces for the class of service COS with which the user account is associated.

CMCs are typically used to enable the system to track calls for account or billing purposes. Whether the CMC is transmitted depends on the setting for outbound calls. The code length can be from 1 through 40 characters. Applicable only to the Alternate transfer rule.

Determines the way in which Unity Connection transfers calls from the automated attendant or a directory handler to the user phone for the Alternate transfer rule:. Determines the number of times the user extension rings before Unity Connection considers the call unanswered "ring-no-answer" and plays the applicable greeting. This setting is applicable only when the TransferType is configured for a supervised transfer. Determines whether Unity Connection transfers the incoming calls for the user to the user greeting or to the extension specified in TransferExtension:.

Determines whether Unity Connection transfers the call to the applicable greeting or releases the call to the phone system when a call is unanswered "ring-no-answer" :.

Applicable only to the Standard transfer rule. Determines the way in which Unity Connection transfers calls from the automated attendant or a directory handler to the user phone for the standard default transfer rule:. This setting is applicable only when the StandardTransferType is configured for a supervised transfer.

Determines whether Unity Connection transfers the incoming calls for the user to the user greeting or to the extension specified in StandardTransferExtension:.

Applicable only to the Closed transfer rule. Determines the way in which Unity Connection transfers calls from the automated attendant or a directory handler to the user phone for the Closed transfer rule:.

This setting is applicable only when the ClosedTransferType is configured for a supervised transfer. Determines whether Cisco Unity Connection transfers the incoming calls for the user to the user greeting or to the extension specified in ClosedTransferExtension:.

The phone number extension of the default message waiting indicator MWI to light when callers leave messages for the user. If no value is provided, Unity Connection uses the number of the primary extension. The text name displayed on the system administration interface of the phone system used to turn message waiting indicators on and off for the phone number specified in the MWIExtension column.

The maximum duration in seconds for recording a message from an outside unidentified caller. The length specified can be from 1 through 1, seconds. Indicates whether Unity Connection plays a recording to the callers after a message has been sent:. Indicates whether Unity Connection plays a recording to callers before allowing them to leave a message for the user.

You can also indicate whether all callers hear the recording or only unidentified callers:. The display name of the post-greeting recording that plays after the greeting for this user. The required forced-authorization code FACs to transmit to Cisco Unified Communications Manager, if applicable, when the user makes an outbound call.

Your organization may use FACs to prevent toll fraud. For example, users may have to provide FACs to place long-distance calls. The value is used only if the system is using Cisco Unified CM and its version is 4. The code length can be from 1 to 40 characters. Determines whether the user is included in the phone directory for outside callers:. If you uncheck it, no such SMTP proxy address is automatically created.

The text name displayed on the system administration interface of the phone system used for Telephone Record and Playback TRAP sessions and to turn message waiting indicators on and off.

Whether the user home phone device is enabled:. The text name for the user home phone displayed on the Unity Connection interfaces. Whether the user work phone device is enabled:. The text name for the user work phone displayed on the Unity Connection interfaces. Whether the user mobile phone device is enabled:. The text name for the user mobile phone displayed on the Unity Connection interfaces. Digits to send to the pager.

The text name for the user pager displayed on the Unity Connection interfaces. Any combination of ASCII only alphanumeric characters, hyphens, underscores, periods, at signs " " , commas and hashes , up to a maximum of 40 characters. Whether the user text pager device is enabled:. The text name for the user text pager displayed on the Unity Connection interfaces. The first alternate extension for the user.

The value must be unique in the partition. The text name of the partition to which the first alternate extension belongs. The second alternate extension for the user. The text name of the partition to which the second alternate extension belongs. The third alternate extension for the user. The text name of the partition to which the third alternate extension belongs.

The fourth alternate extension for the user. The text name of the partition to which the fourth alternate extension belongs. The fifth alternate extension for the user. The text name of the partition to which the fifth alternate extension belongs.

The sixth alternate extension for the user. The text name of the partition to which the sixth alternate extension belongs. The seventh alternate extension for the user.

The text name of the partition to which the seventh alternate extension belongs. The eighth alternate extension for the user. The text name of the partition to which the eighth alternate extension belongs. The ninth alternate extension for the user. The text name of the partition to which the ninth alternate extension belongs. Any combination of characters except for non-printing ASCII characters, up to a maximum of characters. The display name of the Exchange external service that corresponds with the Exchange server that contains the Exchange mailbox for this user.

The primary email address that is associated with the Exchange mailbox that you want this user to be able to access. The Windows domain alias for the user in Exchange useful when the setting is different from the user alias.

RelayAddress is in the format of someone somewhere or someone somewhere. The full SMTP proxy addresses for users. For example:. Note that the field is only for directory information purposes. Cisco Unity Connection does not use the phone number to route calls. A descriptive name for the notification device. This field is required if you want to create an HTML notification device.

The phone number that the user use to play and record voice message.