Table Of Contents
Upgrading from Cisco Conference Connection to Cisco Unified MeetingPlace Express
About Cisco Conference Connection
Getting Ready to Import Data from Cisco Conference Connection
Using the CCC Export Utility
Installing the CCC Export Utility
Configuring the CCC Export Utility
Running the CCC Export Utility
Using the CCC Export Utility in Console Mode
Using the CCC Export Utility in GUI Mode
Upgrading from Cisco Conference Connection to Cisco Unified MeetingPlace Express
•
About Cisco Conference Connection
•Getting Ready to Import Data from Cisco Conference Connection
•Using the CCC Export Utility
About Cisco Conference Connection
To upgrade from Cisco Conference Connection to Cisco Unified MeetingPlace Express, you must install Cisco Unified MeetingPlace Express on a new server and then import your meetings from Cisco Conference Connection.
Cisco Conference Connection only has two types of meetings that need to be exported to Cisco Unified MeetingPlace Express:
•Scheduled meetings (one-time meetings that take place in the future and that are not currently active at the time of the import)
•Repeated meetings (meetings that occur on a recurring basis, such as once a week. Also called recurring meetings)
Note Cisco Conference Connection does not support continuous meetings.
The data for each type of meeting is stored in tables in Cisco Conference Connection. The data for scheduled meetings is in the table called ScheduledConferenceTable and the data for repeated meetings is in the table called RepeatedConferenceTable.
Follow these steps:
1. Complete the steps in the "Getting Ready to Import Data from Cisco Conference Connection" section.
2. Install Cisco Unified MeetingPlace Express. See Chapter 2, "Installing Cisco Unified MeetingPlace Express."
3. Get the meeting data from Cisco Conference Connection. See the "Using the CCC Export Utility" section for complete information.
Note You can only import meetings from Cisco Conference Connection version 1.2.1 and later. If you have an earlier version of Cisco Conference Connection, you must first upgrade to Cisco Conference Connection version 1.2.1.
4. Transfer the CSV files with the exported meeting data to the Cisco Unified MeetingPlace Express server using secure file transfer.
5. Import the meeting data that you just saved into Cisco Unified MeetingPlace Express. See the Configuration and Maintenance Guide for Cisco Unified MeetingPlace Express Release 2.0 for instructions.
6. Cisco Conference Connection licenses do not work with Cisco Unified MeetingPlace Express so you must install a license file for Cisco Unified MeetingPlace Express. See the Configuration and Maintenance Guide for Cisco Unified MeetingPlace Express Release 2.0 for instructions.
Getting Ready to Import Data from Cisco Conference Connection
You must complete the steps in this section before you can import data from Cisco Conference Connection into Cisco Unified MeetingPlace Express, otherwise, the data import fails.
Before You Begin
•You must have the Microsoft SQL Server Enterprise application. You need this to access the Cisco Conference Connection database.
Note We do not provide the Microsoft SQL Server Enterprise application with Cisco Unified MeetingPlace Express. However, it is provided with Cisco Unified Communications Manager (formerly called Cisco Unified CallManager), which you must have if you use Cisco Conference Connection.
Procedure
Step 1 Gather the following information:
•Name of the Cisco Unified Communications Manager server and its IP address. This is used to access the Microsoft SQL Server console.
•Name of the Cisco Conference Connection server and its IP address.
•Password for the Cisco Conference Connection database superuser, called sa, which was determined when Cisco Conference Connection was originally installed. This is used to access the Cisco Conference Connection database.
Step 2 Confirm that the password for the Cisco Conference Connection database superuser called sa is correct by doing the following:
a. On the server on which Cisco Conference Connection is installed, open the command line by selecting Start > Run and entering cmd.
b. In the command line, switch to the following directory:
C:\Program Files\Microsoft SQLServer\MSSQL\Binn
c. On the Cisco Conference Connection server command line, enter:
osql -U sa
The following prompt appears:
Password:
d. Enter the sa password.
If the 1> prompt appears, the password is correct.
Step 3 Ensure that the Cisco Conference Connection data files that you are going to import are in the correct location by doing the following:
a. On the Cisco Unified Communications Manager Microsoft SQL Server console, navigate to the following location:
SQL Server Group\CCC - IP address\Database\DCMS\Tables
b. Verify that the RepeatedConferenceTable and the ScheduledConferenceTable files are there.
c. Verify that these files contain records for all the meetings that you are going to import.
Using the CCC Export Utility
The CCC Export Utility exports information about conferences stored on the Cisco Conference Connection database. The information to be exported is stored in files in CSV (comma-separated value) format that can be easily imported to other databases. The CCC Export Utility can be used in console mode or from the GUI.
•Installing the CCC Export Utility
•Configuring the CCC Export Utility
•Running the CCC Export Utility
Note Contact Cisco TAC for the CCC Export Utility file, called CCCExportSetup.exe.
Installing the CCC Export Utility
Before You Begin
•Complete all the steps in the "Getting Ready to Import Data from Cisco Conference Connection" section.
•Install the Cisco Unified MeetingPlace Express on your system.
Procedure
Step 1 Download the CCC Export Utility file, called CCCExportSetup.exe to your hard drive.
Step 2 Run the CCCExportSetup.exe file.
Step 3 In the CCC Export Utility Setup dialog box, click Next to start the installation.
Step 4 Specify the location where the installer will install the CCC Export Utility. Click Next.
Step 5 Specify the location where the installer will install the CCC Export Utility program's shortcuts. Click Next.
Step 6 Click Install.
Step 7 Click Finish.
When the installation is complete, the Start > Programs menu displays a new item called Cisco that contains the CCC Export Utility.
Configuring the CCC Export Utility
Before You Begin
•Set the following values:
–Host address: Address of the Cisco Conference Connection server
–Cisco Conference Connection DB Name: Database name (usually "DCMS")
–Cisco Conference Connection DB User: Database user name (usually "sa")
–Cisco Conference Connection DB Password: Password for the database user specified above
–Output folder: Location for the exported files
Note If you leave the Output folder field blank, the CCC Export Utility puts the exported files in the current directory.
Procedure
Step 1 Go to Start > Programs > Cisco > CCC Export Utility > CCC Export Utility. The CCC Export Utility automatically opens in both console mode and GUI mode.
Step 2 In GUI mode, set the configuration file values by doing one of these:
•If you already have a populated configuration file, click Load. Navigate to your configuration file, highlight it, and click Open.
•If you do not have a configuration file, enter values in the fields in the main dialog box.
Step 3 Click Save to save this configuration file for later use.
Note The system automatically uses the most recently used configuration the next time the CCC Export Utility is invoked.
The following is an example of a configuration file:
<host>172.19.250.45</host>
<password>Gbhiam</password>
<outfolder>C:\</outfolder>
To generate a configuration file, copy and paste this example into a text file and save it. Enter the file name in Step 2 above.
Running the CCC Export Utility
There are two ways you can use the CCC Export Utility: through the console or as a GUI application. The mode in which the application starts depends whether there are any arguments passed to it on the command line.
Follow the procedure in either of the following sections:
•Using the CCC Export Utility in Console Mode
•Using the CCC Export Utility in GUI Mode
Using the CCC Export Utility in Console Mode
Procedure
Step 1 Open a console window.
Step 2 Navigate to the directory where you installed the CCC Export Utility.
Step 3 Enter the following command:
<location of utility>\ccexport.exe "<name of export utility config file>"
This command specifies the location of the configuration file for the CCC Export Utility. This file contains information necessary for the CCC Export Utility to automatically connect to the remote Cisco Conference Connection database, read data, and store it to a local CSV file.
For example, if you installed the CCC Export Utility in the default location on your C drive and have a configuration file available on your D drive, you can run the CCC Export Utility by entering this:
C:\Program Files\Cisco\CCC Export Utility\cccexport.exe "D:\exportcfg.xml"
The CCC Export Utility reads the configuration file, connects to the Cisco Conference Connection database, and exports data to the directory specified in the configuration file.
Step 4 If the system finds a file in the target directory with the same name as a file it is trying to create, the system asks if you want to overwrite the existing file.
Using the CCC Export Utility in GUI Mode
If you start the CCC Export Utility from the Start menu or if you run the command from the console with no arguments, it runs in the GUI mode.
The CCC Export Utility supports foreign languages. To change to another language, click Language from the menu. The system displays all languages available for the CCC Export Utility. If you select a new language, you must restart the CCC Export Utility before the new settings take effect. You can also click Help for help about the CCC Export Utility.
Procedure
Step 1 Click Export!.
Step 2 If the system finds a file in the target directory with the same name as a file it is trying to create, the system asks if you want to overwrite the existing file.
Step 3 When the export process is complete, the system opens a new window that reports the status of the export procedure. Click Open output folder to open the output directory in Windows Explorer or click Close to exit the CCC Export Utility.
Feedback