Guest

Cisco Unity Connection

Unable to Enable SMTP Notification for Users Using BAT

Cisco - Unable to Enable SMTP Notification for Users Using BAT

Document ID: 112031

Updated: Jan 23, 2012

   Print

Introduction

Cisco Unity Connection can notify a user of new messages by calling a phone or pager. Additionally, you can set up Connection to send message notifications in the form of text messages to text pagers and text-compatible cell phones by using SMTP. This document describes the problem and solution related to enabling the SMTP message notification for users through Cisco Unity Connection Bulk Administration Tool (BAT).

Prerequisites

Requirements

To enable Connection to send text message notifications by using SMTP, your Connection server must be configured to relay messages through a smart host. If Connection is configured to deliver text message notifications but has not been configured to relay messages to a smart host, the notification attempt fails and a nondelivery receipt (NDR) is sent to the Connection Messaging System and then routed, by default, to the Undeliverable Messages distribution list.

Components Used

The information in this document is based on the Cisco Unity Connection 7.x.

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.

Conventions

Refer to Cisco Technical Tips Conventions for more information on document conventions.

Unable to enable the SMTP message notification through BAT

Cisco Unity Connection can notify a user of new messages by calling a phone or pager. Additionally, you can set up Connection to send message notifications in the form of text messages to text pagers and text-compatible cell phones by using SMTP.

The following section describes the solution to enable the SMTP message notification for users through Cisco Unity Connection Bulk Administration Tool (BAT).

Solution

BAT allows you to create, update, and delete multiple user accounts or system contacts by importing information contained in a comma separated value (CSV) file. In addition, it allows you to export information about users or system contacts from Cisco Unity Connection to a CSV file. It also allows you to update Cisco Unity Connection user accounts (with or without voice mailboxes) with information from a CSV file.

These steps describe how to enable SMTP message notification for users with a mailbox in Unity Connection using BAT:

  1. Export all user information to a CSV file.
  2. Edit the CSV file.
  3. Update user accounts after making the changes in the CSV file.

Bulk Edit does not have the option to bulk update the "Message Text" field under SMTP Notification Devices. However, in order to send a message in the "Message Text" field to all the users, you can issue the run cuc dbquery unitydirdb update tbl_notificationdevicesmtp set statictext = 'message text you need' command over a Secure Shell (SSH) connection to the Unity Connection server, and this will update the field for all the current users.

Export User Information to a CSV File

BAT allows you to export information about all users (with or without voice mailboxes) from Cisco Unity Connection to a CSV file. Perform these steps to accomplish the task:

  1. In Cisco Unity Connection Administration, expand Tools, then click Bulk Administration Tool.

  2. In the Select Operation section, choose Export.

  3. In the Select Object Type section, click the option Users With Mailbox to update accounts with mailboxes.:

  4. In the Select File section, in the CSV File field, enter the full path of the applicable file.

  5. Click Submit.

    Note: The Summary page displays the results when the operation has completed. To view the export CSV file, click View Export Objects File.

  6. Save the file.

    Note: It may appear with a different file format. If so, manually change it to .csv format. Now the file with all the User information is ready.

Edit the CSV File

Perform these steps to enable the SMTP notification device:

  1. Open the CSV file, which is saved with user information.

  2. Navigate to the column named Active_TextPager1 and change the value from 0 to 1 for each user for whom you want to enable the notification device.

  3. Navigate to the column named SmtpAddress_TextPager1 and add the email address you want each user to have.

  4. Once you updated the .csv file with the information you want, save it, and then perform the steps in the section to update the user accounts with the new entries doing the following steps mentioned below.

Update User Accounts after Making Changes in the CSV File

BAT allows you to update Cisco Unity Connection user accounts (with or without voice mailboxes) with information from a CSV file.

Perform these steps to accomplish the task:

  1. In Cisco Unity Connection Administration, expand Tools, then click Bulk Administration Tool.

  2. In the Select Operation section, click Update.

  3. In the Select Object Type section, click the option Users With Mailbox to update accounts with mailboxes.

  4. In the Select File section, in the CSV File field, enter the full path of the CSV input file you just modified.

  5. In the Failed Objects Filename field, enter the full path to the failed objects report file. This creates a file that receives errors if any failures occur during the update.

  6. Click Submit.

    Note: BAT updates user accounts and displays the summary page when the operation has completed. If the operation results in any failures, you can immediately inspect the failed objects report file when you click Download the Failed Objects File.

Unable to Add Bulk (BAT) User in Cisco Unity Connection

An issue occurs while creating a user with BAT.

Solution - Construct the Input CSV Files in Cisco Unity Connection 8.x

BAT supports only UTF-8 and UTF-16 character set encoding for the text in the CSV file.

In order to quickly construct an input CSV file, you can use BAT to export the applicable type of user, contact, system distribution list, system distribution list members, or unified messaging accounts, and use the resulting output CSV file as a template.

The example below shows a CSV file for creating voicemail users. These steps were performed in order to construct the file:

  1. Voicemail users were exported to a CSV file.

  2. Unwanted columns and data were removed from the file.

  3. The TemplateAlias column and the applicable data were added

Note: The data for DisplayName - an optional field - is missing for several users.

Example of CSV Input File for Creating Voicemail Users:

Alias,DisplayName,FirstName,LastName,TemplateAlias,Extension,ListInDirectory
iwinkler,"Winkler, Ian",Ian,Winkler,VoiceMailUserTemplate,5321,1
jsmith,,John,Smith,VoiceMailUserTemplate,5126,1
cjones,"Jones, Cris",Cris,Jones,VoiceMailUserTemplate,5249,1
dalbert,,Dan,Albert,VoiceMailUserTemplate,5299,1
jlee,"Lee, Jane",Jane,Lee,VoiceMailUserTemplate,5324,1
jthompson,"Thompson, Jim",Jim,Thompson,VoiceMailUserTemplate,5029,1
swong,"Wong, Sara",Sara,Wong,VoiceMailUserTemplate,5260,1
rhunter,"Hunter, Russ",Russ,Hunter,VoiceMailUserTemplate,5229,1
cashmore,,Carol,Ashmore,VoiceMailUserTemplate,5403,1
lcarson,"Carson, Lauren",Lauren,Carson,VoiceMailUserTemplate,5999,1

Related Information

Updated: Jan 23, 2012
Document ID: 112031