Tariscope 4.6. User's guide
Chapter 2. Tariscope application
2.2. Working with views for calls
2.2.4 Working with Call View
An example of the opened view for calls is shown in Figure 2.2.4.1.
Figure 2.2.4.1
A view has a toolbar and table with calls information.
If you set a restriction for displaying view rows when creating a view (Figure 2.2.4.1) and now need to remove this restriction, then click on the here link in the last row of the view that contains the phrase "Total rows ...".
In this case, all entries that match the view’s filtration conditions will be displayed.
Keep in mind that if there are a large number of records in the Tariscope database that correspond to view parameters, displaying all records may take some time, depending on your computer settings, network settings if you are using a SQL server on another computer, and the parameters of such SQL server.
The toolbar contains the following icons:
- Menu. When you click on the icon, the menu is opened that contains items corresponded to icons of the toolbar.
- Save changes. It allows you to save setting changes of the view.
- Save as. The icon allows you to save the view with another name.
- Rename. It allows to rename the view.
- Copy cell. The icon allows you to copy the selected cell.
- Copy row. The icon allows you to copy the selected row.
- Recharge selected rows. The icon is active only when you have selected one or group of rows. To select a group of rows, use the Shift key on the keyboard. A choice of the icon allows you to rerate the selected rows.
- Recharge with tracing. The icon allows you to rerate the selected row with obtaining information about the rating process and possible problems.
- Recharge all rows. A choice of the icon allows you to rerate all rows of the view.
- Set category for selected rows. It allows you to assign a call category for a row or group of rows.
- Set category for all rows. It allows you to assign a call category for all rows of thew view.
- Record details. A choice of the icon opens the Call details view that can contain all CDR fields received from PBX. The feature is applied only to some PBXs such as: CUCM, CME (Cisco), SI3000 (Iskratel), CS1000 / Meridian 1 (Avaya, Nortel). To get all CDR data for these PBXs you should specify this in the CDR settings. The icon is active when at least one row was selected. You can get the call details in the current tab of browser or in a new tab.
- Details of all records. A choice of the icon opens the Call details view that can contains all CDR fields received from PBX for all records of current view. The feature is applied only to some PBXs such as: CUCM, CME (Cisco), SI3000 (Iskratel), CS1000 / Meridian 1 (Avaya, Nortel). You can get the call details in the current tab of browser or in a new tab.
- Filter by selection. The choice of the icon allows you to filter the data on the selected value of any cell in the call table. For example, only international calls should be selected. To do this, in the Call type column, select International and click on this icon.
- Exclude by selection. The choice of the icon eliminates all rows that contain the selected value from the table.
- Show related records. Related records in Tariscope are records that contain information about the different steps of performing the same call. For example, when transferring a call from one subscriber to another, two records will be formed. They will be linked in the Tariscope system. To display related records, select the record in the view and click on this icon. A filter will be applied to display the related records. To return to the previous view state, click on the Previous filter icon.
- Filter by number. The choice of the icon opens a window that contains a list of telephone numbers and extensions that the view contains. You can select the desired numbers and extensions to filter only calls with them.
- Active view filter. This icon allows you to set a filter that reduces the period. The Active view filter window is opened. It contains a list of filters with different periods. Select the desired period and click Apply.
- Select columns to display. Opens the Select columns to display window. It displays a list of view columns where the user can turn on or off the display of any column. The list of columns available for display is available in the Section 2.2.3.
- Sorting. Sorting by column, where any value was selected, is executed. The Sorting window appears, where you need to select the sort order: Ascending or Descending. After applying sorting, an arrow appears in the name of the corresponding column as a reminder to which column it is applied. Sorting can be applied to multiple columns.
- Reset sorting for selected field. In order to reset a previously sorted column, you must select any cell in the derided column and click on this icon. Sorting will be canceled.
- Reset sorting. Unlike the previous icon, this can be used to deselect both in one column and immediately in all where sorting is installed.
- Grouping. This icon is used to group table data by the values of one of the columns. First you need to select the cell from the column that will be grouped and in the Grouping window select the By this field value. The word of (Group) is added to the column name. The aggregate function by default is applied to other columns. These functions are displayed in the column name. To specify the required aggregate function, select any cell of the desired column and click the Grouping icon again. In the Grouping window, select the desired function. The following functions are available: Default, Average, Count, Maximum, Minimum, and Amount.
- Reset grouping. It allows you to reset the previously set grouping.
- Edit SQL filter. A choice of the icon allows you to look at SQL query that is applied to the view and change the query.
- Save filter. This icon saves the filtering options currently used in the view. In the future, you can use the filter to create new views faster or when you will create a report.
- Reset filter. This icon is used to override previously set filtering options.
- Previous filter. Allows you to return the view to a pre-filter state, that is, a pre-filter is used.
- Next filter. With this icon, it is possible to return to the state before applying the Previous Filter icon.
- Delete. The icon is active only after selecting any cell in the table. It is used to delete the selected entry from the Tariscope database. After deleting an entry, you will not be able to get it back. It will be necessary to re-process the CDR data.
- Automatic page refresh. This icon is used to set a period to refresh the view. Click on the icon, the Automatic page refresh window appears. In the Interval (sec) box, enter value of the refresh period in seconds. By default, this value is 0. It means the view does not refresh.
- Export to file. Displays a menu that allows you to export view data to an external file. Export to files of the following types is possible: Excel, HTML, CSV, PDF.
Telephone systems from different manufacturers have different CDR formats. Tariscope results them to a single model that is displayed in a view. For some CDR formats, some information is not used in this model. Tariscope ensures that all data is saved in the Tariscope database for the following PBXs:
- Cisco Unified Communications Manager (CUCM), Cisco Systems.
- Call Manager Express (CME), Cisco Systems.
- SI3000, Iskratel.
- CS1000 / Meridian 1, Avaya and previously Nortel.
To save all data from CDR for those PBXs, the Tariscope administrator must set this setting in the PBX settings.
To view all CDR field for a specific call record, select it in the Tariscope view and click on the Record details icon on the toolbar. A menu appears that contains two items:
- In current window. Detailed information about the selected row will be displayed in the same tab of your browser.
- In a new window. Detailed information about the selected row will be displayed in a new tab of your browser.
Select the desired item. The Call details page appears. An example of the page for CUCM is shown in Figure 2.2.4.2.
Figure 2.2.4.2
The page displays all CDR fields. It contains a toolbar with the following icons:
- Header on top. The table header is displayed at the top.
- Header on left. The table header is displayed on the left.
- Select columns to display. The icon allows you select only the desired fields to display.
- Filter by selection. The choice of the icon allows you to filter the data on the selected value of any cell in the call table.
- Exclude by selection. The choice of the icon eliminates all rows that contain the selected value from the table.
- Reset filter. This icon is used to reset previously set filtering options.
- Search. The icon allows you to search for the desired information in a specific column or in the entire table.
- Reset search. This icon is used to reset previously set search options.
- Previous filter. Allows you to return the view to a pre-filter state, that is, a pre-filter is used.
- Next filter. With this icon, it is possible to return to the state before applying the Previous Filter icon.
- Export to file. Displays a menu that allows you to export view data to an external file. Export to files of the following types is possible: Excel, HTML, CSV, PDF.
