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.
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
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
Feedback
