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 Monthly, Daily, Hourly or Weekly data.
Issue 07 | Nortel Networks Call Center Reporting Set Up and Operation Guide |
