Chapter 3 The Tariscope program
3.5 Working with views
3.5.23 Record details
A view of call contains a large list of fields. However, a number of telephone systems (telephone exchanges) can have fields that are not included in this list, but they are contained in CDR. Tariscope allows you to store information for all the fields provided by a telephone system in the database. A list of such telephone systems are specified below:
- CS1000, Meridian 1 (Avaya-Nortel);
- Cisco Unified Communications Manager (Cisco Systems);
- CallManager Express (Cisco Systems);
- SI3000, SI2000 (Iskratel).
If the Tariscope administrator has configured the system to save all the received fields and you want to display this information for one record or a group of records in the view, select the desired call records and right-click in the table. In the menu that appears (Figure 3.5.43) select Record details. The Call details view is appeared, an example of which is shown in Figure 5.3.47.
Figure 5.3.47
This view provides features that are available through context menus.
If you right-click on the table header, the menu appears that contains the following items:
- Hide field. The item allows you to hide a selected column.
- Select fields. The item allows to opening the Select fields window that provides a choice of desired fields and their order.
Also you can change an order of the fields using drag and drop.
When you set a focus on a column header, Tariscope displays a brief description of the field as shown in Figure 3.5.47.
If you right-click in any place of the table except the header, another menu appears that contains the following items:
- Hide empty columns. Allows hiding a selected column.
- Rows as columns. It allows turning the table so that the columns become the rows and vice versa.
- Copy. Provides copying data from selected cells.
- Select all. Provides data selection of the entire table.
- Print preview. Opens the Preview view that is described in Section 3.5.16.
- Find. Opens the Find window that is described in Section 3.5.6.
- Bookmark. Allows to set a bookmark on the selected record.
- Export to PDF. Provides an export to a file of the PDF format.
- Export to CSV. Provides an export to a file of the CSV format.
- Export to HTML. Provides an export to a file of the HTML format.
- Export to Excel. Provides an export to a file of the Excel format.
- Filter by selection. Provides a filtering by a value of the selected cell.
- Exclude selection. Provides a filtering when rows that include a value of the selected cell are excluded.
- Clear filter. Provides clearing filter conditions.
In this window, the Tariscope user can explore information that was not included in the view for calls.
It is recommended for a complete analysis of these data to create a desired report form using Report Designer that is included in Tariscope or Microsoft SQL Server Report Builder.