Tariscope 4.5.x. Administrator's guide
Chapter 4 Tariscope configuration
4.12. Subscribers
4.12.3. Creation of subscriber data from CDR
Another option of the subscriber data creation is the conditional filling of some subscriber data based on detail call information (CDR, SMDR, AMA and others). In this case, the subscriber's name is specified as the conditional name corresponding to the subscriber phone number with the "a" prefix. For example, when Tariscope processes a call that was made from the "7777" extension number, the subscriber name will be created as 'a7777'. When the subscriber names are created like this way, the Numbering Plan is considered in Tariscope, Tariscope creates subscriber groups corresponding to the ranges of Numbering Plan. Conditional names of subscribers can later be replaced by the real names using the manual editing or importing data from an external file.
We recommend filling the subscriber data using this method only for quick and total estimation of call expenses to process previously saved log files with call information (CDR, SMDR, AMA and others). Because Tariscope does not rate the calls if subscriber data are absent in the database.
To use this method, you should have a telephone system in Tariscope. Select this telephone system in Tariscope menu. An example of the choice with the CUCM name is shown in Figure 4.12.3.1.
Figure 4.12.3.1
Turn on the Automatically add missing subscribers switch and select a rate plan for subscribers from the Default rate plan list. Click on the Save button.
Note. If the required rate plan is absent, create it.
In the Tariscope menu, select Views → CDR processing. The CDR processing page appears as shown in Figure 4.12.3.2.
Figure 4.12.3.2
Click on the ‘here’ link. In the Equipment selection window, turn on the switch for the desired telephone system. Click Select. The telephone system name is displayed instead of the ‘not selected’.
Click on the Add button on the toolbar and choose the CDR (SMDR, AMA or another) file or files, which contain the detail call information.
Click Start. Processing of call information begins.
Note. For telephone systems, where a CDR file does not contain information about year, Tariscope requests to type the year of calls before processing CDR.
Note. This is assumed that all the parameters for telephone system should be configured to beginning of processing.
At the end of processing you can check on its results opening or creating the view for this telephone system. An example of the calls view is shown in Figure 4.12.3.3.
Figure 4.12.3.3
As you see, the From subscriber column contains the subscriber names like ‘a.DN’.
If you move to the Subscribers page, you see that subscribers, which calls were processed, were created. Now you can edit the subscriber data.
