Cisco Cisco Unified MeetingPlace Audio Server Maintenance Manual
Cisco MeetingServer 5.1 System Manager’s Guide
127
Cisco Systems
March 2003
[02/04/99 03:36 PM]
Outbound Dialing Report Page 1
For the Period from 02/04/99 to 02/05/99
User: JoLynn Johnson
------------------------------------------------------------------------------
Meeting ID: 2375
Meeting Name: Johnson
Time/Date: 02/04/99 11:22
Billing Code:
Destination: 3725502
Length 1 minutes
------------------------------------------------------------------------------
Total Number of outdial calls for User: 1
Total Minutes spent on outdial calls: 1 minutes
------------------------------------------------------------------------------
Total Number of outdial calls for System 44
Total Minutes spent on outdial calls: 78 minutes
Outbound Dialing Report Page 1
For the Period from 02/04/99 to 02/05/99
User: JoLynn Johnson
------------------------------------------------------------------------------
Meeting ID: 2375
Meeting Name: Johnson
Time/Date: 02/04/99 11:22
Billing Code:
Destination: 3725502
Length 1 minutes
------------------------------------------------------------------------------
Total Number of outdial calls for User: 1
Total Minutes spent on outdial calls: 1 minutes
------------------------------------------------------------------------------
Total Number of outdial calls for System 44
Total Minutes spent on outdial calls: 78 minutes
Figure 0-21 Outbound Dialing Report
Raw Data Reports
Information stored in the MeetingPlace database is also available in the form
of raw data reports. These reports allow you to use the Report tab to export
raw data to a spreadsheet or database program for further processing and
formatting. Because the data contained in these reports is initially
unformatted, raw data reports allow you a wide range of options for
formatting information.
of raw data reports. These reports allow you to use the Report tab to export
raw data to a spreadsheet or database program for further processing and
formatting. Because the data contained in these reports is initially
unformatted, raw data reports allow you a wide range of options for
formatting information.
Setting Up the Database
When setting up the target spreadsheet or database, start by defining the
fields in terms of the field names given in this section. When you are ready
to export raw data from MeetingPlace, be sure to name the raw data file
using a file name extension, such as .CSV, recognized by the target program.
You may also find that macros are useful for managing tables and reading
raw data as it is exported to your target file. You may also include the field
names as the first record in your export file.
fields in terms of the field names given in this section. When you are ready
to export raw data from MeetingPlace, be sure to name the raw data file
using a file name extension, such as .CSV, recognized by the target program.
You may also find that macros are useful for managing tables and reading
raw data as it is exported to your target file. You may also include the field
names as the first record in your export file.
Because the data in raw data reports is related, the order in which data is
exported to the target file can be important. One suitable sequence is the
following: group information, user profiles, meeting participants, meeting
outdial, system outdial.
exported to the target file can be important. One suitable sequence is the
following: group information, user profiles, meeting participants, meeting
outdial, system outdial.
Exporting Raw Data Reports into Microsoft Excel
If Excel is your target spreadsheet program, follow the instructions below to
open a raw data file in Excel:
open a raw data file in Excel:
1.
Generate a Raw Data Report.
2.
When the Report Viewer appears, click the Save To File button and save
the file as a .csv.
the file as a .csv.