Chapter 3 The Tariscope program
3.8 Processing a CDR file
CDR is an abbreviation of 'Call Detail Record'. Vendors of some PBXs use the other abbreviations for such data, for example, SMDR and so on.
If you have a CDR log with information about made calls generated by the Tariscope system or in any other way, then you can run processing this data to place them into the Tariscope database.
It is assumed that all the necessary settings for processing such information has already been made. How to configure the system, see the following document: "Tariscope 4.x. Administrator's Guide".
In the menu of the Tariscope program, select Parse → Transfer. The Parse calls view opens in the program and at the same time the Equipment selection window opens, examples of which are shown in Figure 3.8.1.
Figure 3.8.1
In the Equipment selection window, select a telephone system, the data from which will be processed, and click OK. A name of the selected telephone system will be displayed in the Equipment box of the Parse calls view. If the telephone system was selected by mistake, click the "..." button to the right of the Equipment box and select a desired PBX.
Select the CDR files that you wish to process. To do this, click the Add button. The Open window appears. Select one or more CDR files. The selected files will be added to the Call detail recording files list.
If you need to delete some of the files from this list, select them and click on the Exclude button.
To start the processing files, click the Start button. For some PBXs, which have no information about the year in the CDR data, the Choose year window appears where you should select the year to which the data are related. The processing is started. Depending on the file size, the computer's performance and workload the processing may take some time. Details of the processing, such as the number of the processed records, the execution time, the projected time of processing are displayed in the view. An example of this view during processing is shown in Figure 3.8.2.
Figure 3.8.2
After completion of the processing, the Show parsed calls link is appeared. Click this link to open a new view, in which a filter is applied to display only the processed records.
Keep in the mind, if you process the same CDR file twice, records for calls from the file will be doubled. Select Parse → Find duplicate records, to eliminate the duplicated records.