Tariscope 4.x. Administrator's guide
Chapter 3. Tariscope configuration
3.13. Subscribers
3.13.3. Creation of subscriber data from CDR
Another option of the subscriber data creation is the conditional filling of the subscriber database based on information about calls (CDR, SMDR, AMA and others). In this case, the subscriber name (surname) specifies 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 by such a way, the Numbering Plan is considered in Tariscope, and if it exists, Tariscope creates subscribers 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 to create the subscriber database using this methord 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 is absent in the database.
To use this method of the subscriber data creation you should create the telecommunications equipment (telephone system). In the Tariscope configuration tree, select the telecommunications equipment to which subscribers will be added. An example of a choice of the telecommunications equipment with the CUCM name belonging to the SoftPI telecommunications node is shown in Figure 3.13.3.1.
Figure 3.13.3.1
Check the Automatically add missing subscribers box and, select a rate plan for subscribers from the Default plan list. On the toolbar, click on the Save icon.
Note. If the required rate plan is absent, create it.
In the Tariscope program, open a new view using the program menu: Data → New data view. The Filter window opens as shown in Figure 3.13.3.2.
Figure 3.13.3.2
Click on the "..." button located to the right of the Node/Equipment box. In the Equipment selection window shown in Figure 3.13.3.3, select the required telephone system.
Figure 3.13.3.3
Click OK and then, click OK in the Filter window. A new view is opened with the selected filter criteria.
Note. The configuration of the filter data is not required to process the file, especially in the case when you have only single telephone system. If necessary, the filter parameters can be set after processing.
To process the call log file, select the menu: Parse → Transfer. The Equipment selection window appears as shown in Figure 3.13.3.3.
In the window, select the required telephone system and, click OK. The Parse calls view appears in the Tariscope program as shown in Figure 3.13.3.4.
Figure 3.13.3.4
If you ned to change telephone system, click on the "…" button located to the right of the Equipment box.
Click on the Add button and select a file that contains call information (CDR, SMDR, AMA or others). Repeat this action if you want to process some files located in the different folders.
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 files.
At the end of processing, click on the Show parsed call link in the window that is shown in Figure 3.13.3.4. The calls view opens as shown in Figure 3.13.3.5.
Figure 3.13.3.5
As you see all subscribers have names which correspond to their phone numbers. Now if you return to the Subscribers mode you will see that all subscribers were created.
For all subscribers the rate plan is set, which was set in Tariscope as default plan.
Now you can edit the subscriber data.
