Specifications

Call Detail Record Reports
ShoreTel 7.5 Administration Guide C – 9
Importing a 2 GB database (500,000 workgroup calls) requires about 100 minutes on a
2-Quad Core Intel Xeon 2.80 GHz CPU, 4 GB memory, 300 GB HD.
The following procedure describes the process of importing CDR data from a Microsoft
Access database into MySQL.
Step 1 1.Set the Retention Period for the database that will receive the records
to a value larger than the oldest record that will be imported.
See “Record Retention Periods” on page C-5 for instructions on setting
the Retention period.
Step 2 Open a command prompt window.
Step 3 Change the command prompt directory to:
C:\Program Files\Shoreline Communications \ ShoreWare Server
Step 4 Run the following command (parameters are optional):
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).
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.
Migrating Custom Reports
Users who wrote custom reports to access MS Access database must modify their
custom report generator to work with MySQL CDR database. The user id
(st_cdrreport) and password (passwordcdrreport) may be used to read the CDR
database.
The CDR reports are located in C:\Program Files\Shoreline
Communications\ShoreWare Director\WebReports\Reports. Shoreware reports can be
viewed using Crystal Reports XI. Any custom report applications should ensure that
they have their process set to either “low” or “below normal” to avoid impacting
negatively the call processing performance.
CDR Schema changes in ShoreTel 7
SIP GUID added to Call table.
SIP GUID added to MediaStream table.
A_Extension and B_Extension added to Media Stream table – Extension value passed
from Tms to TmsCDR. No extension number is available for anonymous calls or for
trunk calls.