Configuration and Maintenance Guide for Cisco Unified MeetingPlace Express Release 1.2
Importing Data into Cisco Unified MeetingPlace Express
Downloads: This chapterpdf (PDF - 296.0KB) The complete bookPDF (PDF - 5.53MB) | Feedback

Importing Data into Cisco Unified MeetingPlace Express

Table Of Contents

Importing Data into Cisco Unified MeetingPlace Express

Restrictions for Importing Data

Restrictions for Importing User Groups

Restrictions for Importing User Profiles

Restrictions for Importing Meetings

Requirements for Import Files

How To Import Data

Setting Up an Import File

Importing User Groups

Deleting User Groups by Import

Importing User Profiles

Deleting User Profiles by Import

Importing Meetings

Canceling Meetings by Import

Importing Cisco Conference Connection Meetings

Examples of Import Files


Importing Data into Cisco Unified MeetingPlace Express


Revised: October 18, 2006, OL-11374-01

You can import existing user profile or user group information to Cisco Unified MeetingPlace Express from another database, such as Cisco Unified CallManager, an e-mail directory, or a human resources database. You can also import meeting information from Cisco Conference Connection or another Cisco Unified MeetingPlace Express server.

Although creating a process for importing the initial database and keeping it current requires planning, doing so saves you time overall. Rather than worrying about accepting impromptu requests, you can manage the process by anticipating any circumstances that may occur.

Topics in this section include:

Restrictions for Importing Data

Requirements for Import Files

How To Import Data

Examples of Import Files

The content in this chapter applies only to the Cisco Unified MeetingPlace Express system and not to the Cisco Unified MeetingPlace Express VT system.

Restrictions for Importing Data

Topics in this section include:

Restrictions for Importing User Groups

Restrictions for Importing User Profiles

Restrictions for Importing Meetings

Restrictions for Importing User Groups

If the import file contains the tzcode header field, then all user groups in the import file must have a valid entry for the field. For any invalid or blank tzcode values, the associated user group is not imported, and an error is logged.

Restrictions for Importing User Profiles

If the import file contains the tzcode header field, then all user profiles in the import file must have a valid entry for the field. For any invalid or blank tzcode values, the associated user profile is not imported, and an error is logged.

If the import file contains the grpnme, grpnum, or both header fields, then all user profiles in the import file must have a valid entry for each included field. Specifically:

Import user groups before you import user profiles.

If any grpnme and grpnum fields are left blank in the import file, then the associated user profiles are not imported, and an error is logged.

If any user groups that are specified in the grpnme and grpnum fields do not already exist in the Cisco Unified MeetingPlace Express database, then the associated user profiles are not imported, and an error is logged.

If the import file does not contain the grpnme or grpnum header fields, then the imported user profiles are automatically assigned to the preconfigured "system" group.

Related Topics

Importing User Groups

Importing User Profiles

Exporting Information about User Profiles, page 10-5

Restrictions for Importing Meetings

An imported meeting cannot be scheduled if any of the following conditions are true:

The SchedulerUid field in the import file is blank, and a substitute username is not configured in the Scheduler user ID field on the Import Meetings page.

There are not enough voice or web ports available for the imported meeting.

If the username in the SchedulerUid field does not correspond to an existing user profile, then the import process replaces the SchedulerUid entry with the value entered in the Scheduler user ID field on the Import Meetings page.

Continuous and recurring meetings are scheduled from the current time; meeting information from the past is not imported.

When recurring meetings are imported to Cisco Unified MeetingPlace Express, each occurrence in the import file is scheduled as an individual meeting with no recurrence pattern.

Related Topics

Importing Meetings

Exporting Information about Meetings, page 10-7

Requirements for Import Files

The following requirements apply to all types of import files:

Import files must use the comma-separated value (CSV) format.

The first line of the import file contains header fields that specify the order in which data appears in all subsequent lines. The header fields may be in any order.

All subsequent lines of the import file contain the actual data. The data must appear in the order specified in the first line of the import file.

Each import file must contain the required headers, which are specified in Table 9-1.

Table 9-1 Required Headers in Import Files

Type of Import File
Purpose
Required Header Fields

User Groups

Adding or deleting

grpnum

Name

User Profiles

Adding

EncryptedProfilePWD or prfpwd

EncryptedUserPWD or upwd

prfnum

uid

Deleting

prfnum

uid

Meetings

Scheduling or canceling

DialableConfID

ReqLengthOfConf

StartDateTimeOfConf


For all optional header fields that are not included in the import file, the system uses the default value for the import data. For descriptions and values of available import fields, see the following sections:

Output Fields of the Group Information Page—Used for Importing User Groups, page C-71

Output Fields of the Profile Information Page—Used for Importing User Profiles, page C-121

Output Fields of the Meeting Information Page—Used for Importing Meetings, page C-103

The following notes apply to the import file:

Any spaces placed at the beginning or end of a value are deleted during the import process unless the value and the leading or ending spaces are enclosed in double quotation marks (" "). Spaces within a value, for example in Tech Support for a billing code, are imported without being deleted.

Any commas used in a value must be enclosed in double quotation marks, such as using "Smith, John" for a user ID.

All text is case insensitive.

Related Topics

Examples of Import Files

Setting Up an Import File

Importing Data into Cisco Unified MeetingPlace Express

How To Import Data

Topics in this section include:

Setting Up an Import File

Importing User Groups

Deleting User Groups by Import

Importing User Profiles

Deleting User Profiles by Import

Importing Meetings

Canceling Meetings by Import

Importing Cisco Conference Connection Meetings

Setting Up an Import File

Follow these steps to set up an import file before you import information into the Cisco Unified MeetingPlace Express system.

Before You Begin

Read the "Requirements for Import Files" section.

Procedure


Step 1 Export a similar file by following the steps in one of the following sections:

Exporting Information about User Groups, page 10-6

Exporting Information about User Profiles, page 10-5

Exporting Information about Meetings, page 10-7

For example, if you plan to import user groups, then first export existing user groups from Cisco Unified MeetingPlace Express. Use the export file as a template for the import file.


Note In the "Include field header names" field, be sure to select Yes.


Step 2 When prompted, save the exported file by clicking Export to File. Save the file with a .csv extension.

Step 3 On your PC, open a spreadsheet application such as Excel.

Step 4 Open the file that you saved in Step 2.

Step 5 In the spreadsheet application, the required headings are listed in the first row, and the data is listed in all subsequent rows. Do one of the following:

If you are modifying existing entries, then delete the rows that you do not want to modify. Do not delete the header row.

If you are adding entirely new entries, then delete all rows except for the header row.

Step 6 For each group (or user or meeting) that you are importing, enter or modify the information in the appropriate fields.

If you are unsure about what to enter in any field, then we recommend that you delete that entire column (unless it is a required field). If you leave the field blank, then the system uses the default value, which may not be what you want. For descriptions and values of each field, see these sections:

Output Fields of the Profile Information Page—Used for Importing User Profiles, page C-121

Output Fields of the Group Information Page—Used for Importing User Groups, page C-71

Output Fields of the Meeting Information Page—Used for Importing Meetings, page C-103

Step 7 Save and close the file.

Step 8 Proceed to one of the following tasks:

Importing User Groups

Deleting User Groups by Import

Importing User Profiles

Deleting User Profiles by Import

Importing Meetings

Canceling Meetings by Import


Related Topics

Examples of Import Files

Importing User Groups

This topic describes how to use the import process to add multiple user groups to Cisco Unified MeetingPlace Express.


Note If you instead want to add user groups one at a time, then see the "Adding User Groups Manually" section on page 8-25.


Before You Begin

Create the import file. See the following sections:

Requirements for Import Files

Setting Up an Import File

Sample Import File for User Groups

Restrictions

See the "Restrictions for Importing User Groups" section.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Maintenance.

b. Click Import Information.

c. Click Group Profiles.

Step 4 Enter values in the fields, which are described in the "Fields on the Import Group Profiles Page" section on page C-79.

Step 5 Click Execute.

Step 6 Click OK to confirm your request to import records.

Step 7 The system displays the import status and provides a link to the import log:

Click the link to view the import log, which you may print.

Click the OK button to close the page.

After you click OK, the import log can no longer be viewed or retrieved.


Related Topics

Deleting User Groups by Import

About This Page: Import Group Profiles, page C-79

About This Page: Group Information, page C-70

Importing Data into Cisco Unified MeetingPlace Express

Deleting User Groups by Import

This topic describes how to use the import process to delete multiple user groups from Cisco Unified MeetingPlace Express.


Note If you instead want to delete user groups one at a time, then see the "Deleting User Groups" section on page 8-27.


Before You Begin

Create the import file. See the following sections:

Requirements for Import Files

Setting Up an Import File

Sample Import File for User Groups

Make sure that the import file contains only the user groups that you want to delete.

Restrictions

You cannot delete the "system" group.

See the "Restrictions for Importing User Groups" section.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Maintenance.

b. Click Import Information.

c. Click Group Profiles.

Step 4 Enter values in the fields, which are described in the "Fields on the Import Group Profiles Page" section on page C-79.

In the Action to perform field, be sure to select "Delete groups from system."

Ignore the Overwrite duplicate information? field. Its value does not affect the process.

Step 5 Click Execute.

Step 6 Click OK to confirm your request to import records.

Step 7 The system displays the import status and provides a link to the import log:

Click the link to view the import log, which you may print.

Click the OK button to close the page.

After you click OK, the import log can no longer be viewed or retrieved.


Related Topics

Importing User Groups

About This Page: User Group Management, page C-152

About This Page: Import Group Profiles, page C-79

About This Page: Group Information, page C-70

Importing Data into Cisco Unified MeetingPlace Express

Importing User Profiles

This topic describes how to use the import process to add multiple user profiles to Cisco Unified MeetingPlace Express.


Note If you instead want to add user profiles one at a time, then see the "Adding User Profiles Manually" section on page 8-28.


Before You Begin

Create the import file. See the following sections:

Requirements for Import Files

Setting Up an Import File

Sample Import File for User Profiles

Restrictions

See the "Restrictions for Importing User Profiles" section.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Maintenance.

b. Click Import Information.

c. Click User Profiles.

Step 4 Enter values in the fields, which are described in the "Fields on the Import User Profiles Page" section on page C-82.

Step 5 Click Execute.

Step 6 Click OK to confirm your request to import records.

Step 7 The system displays the import status and provides a link to the import log:

Click the link to view the import log, which you may print.

Click the OK button to close the page.

After you click OK, the import log can no longer be viewed or retrieved.


Related Topics

Deleting User Profiles by Import

About This Page: Import User Profiles, page C-82

About This Page: Profile Information, page C-120

Importing Data into Cisco Unified MeetingPlace Express

Deleting User Profiles by Import

This topic describes how to use the import process to delete multiple user profiles from Cisco Unified MeetingPlace Express.


Note If you instead want to delete user profiles one at a time, then see the "Deleting User Profiles" section on page 8-31.


Before You Begin

Create the import file. See the following sections:

Requirements for Import Files

Setting Up an Import File

Sample Import File for User Profiles

Make sure that the import file contains only the user profiles that you want to delete.

Restrictions

You cannot delete the preconfigured Admin and Guest profiles, nor can you delete the user profile with which you are currently logged in.

See the "Restrictions for Importing User Profiles" section.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Maintenance.

b. Click Import Information.

c. Click User Profiles.

Step 4 Enter values in the fields, which are described in the "Fields on the Import User Profiles Page" section on page C-82. In the Action to perform field, be sure to select Delete users from system.

Step 5 Click Execute.

Step 6 Click OK to confirm your request to import records.

Step 7 The system displays the import status and provides a link to the import log:

Click the link to view the import log, which you may print.

Click the OK button to close the page.

After you click OK, the import log can no longer be viewed or retrieved.


Related Topics

Importing User Profiles

About This Page: Import User Profiles, page C-82

About This Page: Profile Information, page C-120

Importing Data into Cisco Unified MeetingPlace Express

Importing Meetings

This topic describes how to schedule meetings by import. Although you can schedule meetings individually from the end-user web interface, you can schedule multiple meetings at one time by following this procedure.

Before You Begin

Create the import file. See the following sections:

Requirements for Import Files

Setting Up an Import File

Sample Import File for Meetings

Restrictions

See the "Restrictions for Importing Meetings" section.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Maintenance.

b. Click Import Information.

c. Click Meetings.

Step 4 Enter values in the fields, which are described in the "Fields on the Import Meetings Page" section on page C-81.

Step 5 Click Execute.

Step 6 Click OK to confirm your request to import the meeting records.

Step 7 The system displays the import status and provides a link to the meeting import log:

Click the link to view the import log, which you may print.

Click the OK button to close the page.

After you click OK, the meeting import log can no longer be viewed or retrieved.


Related Topics

Canceling Meetings by Import

About This Page: Import Meetings, page C-80

About This Page: Meeting Information, page C-102

Exporting Information about Meeting Participants, page 10-8

Canceling Meetings by Import

This topic describes how to use the import process to cancel meetings in the Cisco Unified MeetingPlace Express database. Although you can cancel meetings individually from the end-user web interface, you can cancel multiple meetings at one time by following this procedure.

Before You Begin

Create the import file. See the following sections:

Requirements for Import Files

Setting Up an Import File

Sample Import File for Meetings

Make sure that the import file contains only the meetings that you want to cancel.

Restrictions

See the "Restrictions for Importing Meetings" section.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Maintenance.

b. Click Import Information.

c. Click Meetings.

Step 4 Enter values in the fields, which are described in the "Fields on the Import Meetings Page" section on page C-81.

In the Action to perform field, be sure to select "Cancel meetings."

Step 5 Click Execute.

Step 6 The system displays the import status and provides a link to the meeting import log:

Click the link to view the import log, which you may print.

Click the OK button to close the page.

After you click OK, the meeting import log can no longer be viewed or retrieved.


Related Topics

Importing Meetings

About This Page: Import Meetings, page C-80

About This Page: Meeting Information, page C-102

Importing Cisco Conference Connection Meetings

This topic describes how to import recurring and future meetings from a Cisco Conference Connection database.

Before You Begin

Make sure that the number of voice ports available on your Cisco Unified MeetingPlace Express system is equal to or greater than the number of voice ports available in the Cisco Conference Connection system from which you are importing meetings.

If you want the imported meetings to have web-conferencing capabilities, then make sure that the number of web ports available on your Cisco Unified MeetingPlace Express system can accommodate the meetings imported from Cisco Conference Connection.

When meetings are imported from Cisco Conference Connection into Cisco Unified MeetingPlace Express, the user who performs the import process automatically becomes the scheduler for those meetings.

If you do not want the imported meetings to have web-conferencing capabilities, then make sure that the user profile of the person who is importing the meetings has the Host web meetings with field set to "Participant list only (no licenses required)."

Export the meeting information from Cisco Conference Connection. See the "Upgrading Cisco Unified MeetingPlace Express" chapter of the Installation and Upgrade Guide for Cisco Unified MeetingPlace Express.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Maintenance.

b. Click Import Information.

c. Click Cisco Conference Connection.

Step 4 Enter or change the values in the fields, which are described in the "Fields on the Import Cisco Conference Connection Meetings Page" section on page C-77.

Step 5 Click Execute.

Step 6 Click OK to confirm your request to import records.

Step 7 The system displays the import status and provides a link to the import log:

Click the link to view the import log, which you may print.

Click the OK button to close the page.

After you click OK, the import log can no longer be viewed or retrieved.


Related Topics

About Voice Ports for Scheduled and Reservationless Meetings, page 5-7

About Web Ports for Scheduled and Reservationless Meetings, page 5-8

About This Page: Import Cisco Conference Connection Meetings, page C-77

Examples of Import Files

Topics in this section include:

Sample Import File for User Groups

Sample Import File for User Profiles

Sample Import File for Meetings

Sample Import File for User Groups

This example shows a basic import file for user groups.

grpnum,Name,ContactID,CanOutdial
1,group1,username3,Yes
2,group2,username3,No

Note For a list of required and optional header fields, and for descriptions of each field, see the "Output Fields of the Group Information Page—Used for Importing User Groups" section on page C-71.


Sample Import File for User Profiles

This example shows a basic import file for user profiles.

uid,upwd,prfnum,prfpwd,fnm,lnm,phnum,ctctuid,grpnme
username1,password1,206,12345,terry,smith,5551234,username3,system
username2,password2,207,23456,robin,smith,5552345,username3,system

Note For a list of required and optional header fields, and for descriptions of each field, see the "Output Fields of the Profile Information Page—Used for Importing User Profiles" section on page C-121.


Sample Import File for Meetings

This example shows a basic import file for meetings.

StartDateTimeOfConf,DialableConfID,ReqLengthOfConf,allowguestoutdial
04/05/2006 14:00,12321,120,No
04/05/2006 16:00,23432,60,No

Note For a list of required and optional header fields, and for descriptions of each field, see the "Output Fields of the Meeting Information Page—Used for Importing Meetings" section on page C-103.


Related Topics

Requirements for Import Files

How To Import Data