Preparing the Subscriber Manager user data for import to User Management

Last Updated : Dec 14, 2023 |

You must perform this procedure on System Manager Release 6.1.

Before you begin

  • Ensure that you install the latest CS 1000 Service Pack on all the CS 1000 network elements.

  • Ensure that you update all Subscriber Manager user profiles for completeness that includes First Name, Last Name, and Preferred Name / CPND Name.

  • Ensure that you synchronize Subscriber Manager and the CS 1000 network elements and that you upload Corporate Directory and Numbering Groups to the CS 1000 network elements.

  • Ensure that the firewall is stopped on System Manager Release 6.1. Perform the following to verify that the firewall is stopped:

    1. Using the command line interface, log in to System Manager Release 6.1 as root.

    2. Enter service iptables status.

      The system must indicate that the firewall service has stopped.

    3. If firewall is enabled, enter service iptables stop.

      The system stops the firewall service.

Procedure

  1. Log on to the Web console of System Manager Release 6.1.
  2. On the Avaya Unified Communications Management page, click Network > Subscriber Manager.
  3. In the left navigation pane, click CSV Export.
  4. Click Generate on the upper-right of the page to create a new CSV file with the latest subscriber data.
  5. Click Download on the upper-right of the page to download the subscriber data to your computer.

    Note the location of the subscribers.csv file.

  6. Open the subscribers.csv file using Microsoft Excel and perform the following steps:
    1. Copy the data from the UUID column to the postOfficeBox column, without the column header information. This is to ensure that the Subscriber Manager datastore UUID is mapped to a column that the UPM LDAP datastore synchronization supports. For example:

      entryUUID

      postOfficeBox

      c0bbc2d2-3096-4ce8-8fca-2670ea681be3

      c0bbc2d2-3096-4ce8-8fca-2670ea681be3

      86d11715-3b36-4238-be37-5284ca7a7a68

      86d11715-3b36-4238-be37-5284ca7a7a68
    2. Copy the data from the ucDomain to the User ID (uid) column. For example:

      ucDomain

      uid

      ca.avaya.com

      user1@ca.avaya.com

      ca.avaya.com

      user2@ca.avaya.com
    3. Save the modified subscribers.csv file in a csv format.
  7. To synchronize the Subscriber Manager data with the modified subscribers.csv file, import the modified Subscriber Manager data in the subscribers.csv file back to Subscriber Manager and perform the following steps:
    1. In the left navigation panel, on the Subscriber Manager, click CSV Synchronization.
    2. Browse to the location where you saved the modified subscribers.csv file.
    3. Click Synchronize.
    4. Click View Results to verify that the synchronization is successful.

      If error occurs, the page displays the location of the error logs on the System Manager server. For example, /opt/nortel/cnd/log/LDAP_Sync.

    5. Click Subscribers, leave the Name field blank, and click Search.
    6. Select one of the user and verify that the system updated the Unified Communication Username field correctly.

      The system does not display the postOfficeBox field.

  8. If Numbering Groups are used, perform the following:
    1. Click UCM Services > Numbering Groups.
    2. Click Generate.
    3. Click Export to export the data to a location on your computer to ensure that the data is captured.