Specifications

Reporting
ShoreTel 7.5 Administration Guide 17 – 5
Converting Existing CDR Data to MySQL Format
Releases prior to ShoreTel 7 relied on the Microsoft Joint Engine Technology (JET)
database management system to store Call Detail Records (CDR) and to manipulate the
data within the database. This approach limited the size of the database to 2 gigabytes,
thus potentially limiting the scalability of the ShoreTel system.
ShoreTel 7 replaced the Microsoft JET database management system with the more
scalable MySQL technology. The maximum size for MySQL tables under Windows
tables is 2 terabytes (TB), and the maximum size for the entire database is 64TB.
The Microsoft JET database management system automatically created a new database
at the beginning of each month, and these database files could be viewed by simply
double-clicking on them. In contrast, the MySQL technology does not partition the
CDR data into separate files. Instead, all of the CDR data is stored in one large file,
which can be viewed using a new Web-based Reporting feature via ShoreWare Director.
Upon installing ShoreTel 7, CDR data is stored in the MySQL database rather than the
Microsoft Access database that was previously used by Microsoft JET. However, if a
system is being upgraded to ShoreTel 7 (or higher) from a prior release, the original
database will be retained on that system. New information will go into the MySQL
database, and old information will remain in the old format.
When a system has been upgraded and a CDR report is generated on that system, only
the MySQL database will be tapped to generate the report. Data in the old Microsoft
Access database will be ignored when the report is generated. The old data will not
appear in the report unless it has been converted to the new MySQL format using the
command line utilities shown in the procedure below.
To import CDR data from a Microsoft Access database into MySQL:
Step 1 Open a command prompt window
Step 2 Change the command prompt directory to C:\Program Files\Shoreline
Communications \ ShoreWare Server
Step 3 Run the following command: ImportCDR -s server -d
databasename -f mdb-file
•
server is IP address of the mysql shorewarecdr database.
• databasename is shorewarecdr.
• mdb-file is the name of the mdb file (e.g. CDR.mdb).
The parameters are optional.
Details:
• By default, data is imported into the main CDR database on localhost.
• The main CDR.mdb is imported before any of the Archive mdb.
• Errors are written to error log, MakeCDRMMDDYYY.log. The log will be present
in Shoreline Data\Logs.