Tariscope 4.x. Administrator's guide
Chapter 4. Tariscope Maintenance
4.7. Deletion of duplicate records
The duplicate records can appears in the Tariscope database, for example, when incorrect double processing of call information was executed.
To delete such duplicate records, select in the Tariscope menu: Parse → Find duplicate records. The Action parameters window appears as shown in Figure 4.7.1.
Figure 4.7.1
This action can be executed for the entire database of calls or only the data of the current view of calls. It is defined by selection of one from the following check boxes:
- No filter. The search and deletion of the duplicate records are performed for the entire calls database.
- Active view filter. The search and deletion of the duplicate records are performed only for records displayed in the current calls view. This check box is selected by default.
- Other filter. The search and deletion of the duplicate records are performed on the part of the database which is defined by the specified filter.
If necessary, the deletion will be performed only for a particular month, select the Month box and specify the desired month and year.
If you have several telecommunications nodes and you wish that the deletion will be performed only on a particular telecommunications node, select the required node from the Node list.
If you wish to delete calls data of a specified subscriber, click on the "…" button located on the right from the Subscriber box. The Choose subscriber window appears. Select a desired subscriber in the window and, click OK..
Filtering conditions specified in the Month, Node, Subscriber parameters will be applied jointly with the parameters of the current view filter.
Click OK to start the search for duplicate records. If they are present in the database, the window with information about their number appears.
This window also asks about the need to remove duplicate records from the database. If you are sure you need this operation, click Yes. As a result, chosen duplicate records will be removed.
Update data in the call view.