Filter
Top Products
Issue 07 Nortel Networks Call Center Reporting Set Up and Operation Guide
How to Select and Import Nortel Networks Call Center
Reporting Statistical Data into Microsoft Excel
Introduction
The statistical information gathered and recorded by the Nortel Networks Call Center Reporting
application is stored in Microsoft Access databases. This information can be queried and
analysed using Microsoft Excel.
!
It is vitally important that the statistical database files are not edited,
renamed or altered in anyway.
They can be examined using the Microsoft Excel and Access
applications, BUT NO CHANGES SHOULD BE SAVED BACK TO
THE STATISTICAL DATABASE FILES, OTHERWISE THE
CALL CENTER REPORTING REPORTS WILL BE
COMPROMISED.
Location of the Statistical Database Files
If you accepted the defaults during the installation of the Call Center Reporting the statistical
database files will be located at c:\Program Files\Nortel Networks\Call Center
Reporting\stats, on the Master PC. That is, the PC which is running the Master client, and on
which the RDBServer is operating. If you only have one PC running Call Center Reporting, that
PC is the Master PC.
Within the stats folder there will be folders named (for example) 2000, 2001 and so on. Within
these folders will be folders for each of the months in those years, in which the Call Center
Reporting application was operating. These monthly folders are called 01, 02, 03 … 12. Also in
this folder are the weekly statistical database files.
Within the monthly folders are the daily, hourly and monthly statistical database files.
Statistical Database File Naming Conventions
All statistical database files have the .MDB extension.
The file names are made up out of digits representing Monthly, Daily, Weekly and Hourly
values.
File names all start with a letter: either M, H, D or W indicating that the file contains either
M
onthly, Daily, Hourly or Weekly data.