How to work with views for calls in Tariscope

Tariscope is a Web application. In Tariscope you can view, find, sort, group and analyze calls records. For this purpose, the views for calls are used.

Select a view for calls or creating a new view

To work with the views, in the Tariscope menu, select the Views item as shown in Figure 1.

Figure 1

The Views item includes the following subitems:

• View list. It allows you to get a list of views.
• CDR processing. This item allows you to process CDR file.
• Import calls and services. Provides processing of files received from telecom operators that contain information about calls and provided services, for which there is no support in the Tariscope installation package. To process such data, it is requered to create a script. 

In the current article we will consider only work with views. Select the View list item. The page is as shown in Figure 2.

Figure 2

The Views page contains a toolbar, table with views, and text box for search of view. The toolbar includes the following icons:

• Open. It is intended to open the selected view. If you did not select a view, this icon is unavailable.
• Add. It allows you to create a new view.
• Group management. This icon is used to create, change or delete a group for views.
• Edit. It allows to change the selected view settings such as: a list of fields to display, sorting, grouping and filtering. The icon is not applied to the views from the Standard views group.
• Relocate. It allows to move the selected view from one group to another.
• Delete. Deletes the selected view. You cannot delete a view from the Standard views group.
• Create shared copy. All new views are created only for user who creates them. To share a view to other users, use this icon.
• Copy for yourself. This icon is active only if you selected a view in the Shared views group. The group is appeared when a user had created a shared copy of the view. The view will be created in the Your views group.
• Background calls recharge. The item allows you to recharge calls in the selected view in the background.
• Traffic calculation. Allows to create a graph of calls traffic.
• Show filters. This icon provides a selection of filter to apply it in the view. A list of filters contains standard filters and filters which were created by user.
• Find duplicate records. It allows to find and delete duplicate records in the calls database.
• Export of the table. This icon provides an export of the view table to one of the following files: Excel, HTML, CSV, or PDF.

By default, the Views page contains only the Standard views group. The group includes the following views:

• Cost distribution by groups for previous month.
• Cost distribution by groups for this month.
• Cost distribution by subscribers for previous month.
• Cost distribution by subscribers for this month.
• Last call date and time by equipment.
• Outgoing calls for the last month without subscribers.
• Subscribers charges previous month.
• The highlighted long-distance calls for this month in off-peak time.
• The highlighted long-distance calls for the previous month.
• Top-1000 longest calls for previous month.
• Top-1000 longest calls this month.
• Top-1000 most expensive calls this month.
• Unanswered calls for today.

The Tariscope user can use one of these views or create an own view. To use a standard view, select it and click on the Add icon on the toolbar.

To create a view, click on the Add icon on the toolbar. The menu is appeared that contains the following items:

• Create a view for calls.
• Create a provider summary view.
• Create a view for services.
• Create a view for IP traffic.

Select the Create a view for calls. The page is as shown in Figure 3. 

Figure 3

In the View name box, enter a view name that displays the purpose of the view.

The Row limit (zero for no limit) box contains by default the value of 1000. This means that the view will display only 1000 records. You can change the value. To display all records, change the value to 0. Please note that a large number of entries may take some time to display.

The Equipment box allows you to select a single telephone system or group of them for which call information will be displayed. Click on the button located left on the box. The Equipment window appears. Select the desired PBXs. If you have only a single PBX, do not do anything here.

The Period list allows you to select time period to display calls information. The list includes the next options:

• No filter.
• Today.
• Yesterday.
• This week.
• Last week.
• This month.
• Last month.
• This year.
• Last year.
• Selected month.
• Selected year.
• Custom period.

If you have selected the Selected month option, two lists appear: Year and Month. Select in these lists the required year and month.

If you have selected the Selected year option, the Year list appears. Select the required year.

If you have selected the Custom period option, the From and To calendar boxes appear. Specify the required time period in these boxes.

The next filtering parameters are displayed on the General and Advanced tabs.

The General tab (Figure 3) contains the following parameters.

The Source list allows you to select a call originator. There are the next options:

• Auto.
• Extension.
• External number.
• Subscriber.
• Group.
• Route, trunk, gateway.
• List.

Consider each of these options.

The Auto option allows you to select all records that contain the value entered in the Source value box. The selection will be executed in the view fields: Originator, Number A, From subscriber, From telephone.

If you have selected the Extension option, the Select button appears on the right of the Source value box. Click on the button. The Extensions window appears that contains a list on extensions. Select one or group of desired extensions. The call records will be selected that contain the same value in the Originator column of the view.

The External number option allows you to select incoming calls where the call was made from the telephone number the value of which equals a value entered in the Source value box.

If you have selected the Subscriber option, the Select button appears on the right from the Source value box. Click on the button. The Subscribers window appears. Choose the desired subscribers.

If you have selected the Group option, the Select button appears on the right from the Source value box. Click on the button. The Groups window appears. Choose the desired group the subscribers of which made calls.

If you have selected the Route, trunk, gateway option, the Select button appears on the right from the Source value box. Click on the button. The Routes, trunks, gateways window appears. Choose the desired route, trunk or gateway from which calls were made.

If you need to select the calls records where calls were made from some extensions or external telephone numbers, choose the List item in the Source list and enter a list of extensions and/or external telephone numbers from which calls were made. These extensions or telephone numbers are displayed in the Number A column of a view.

The Destination list and the Destination value allows you to specify an object to which calls were made. This list contains the same options as the Source list.

The From city box allows you to filter incoming calls, where the originator is in the city specified in this box.

The To city box allows you to filter outgoing and transit calls, where the destination is in the city specified in this box.

The Direction list allows you to select calls the directions of which correspond to the selected values. There are the following values:

• Unknown.
• Internal.
• Incoming.
• Outgoing.
• Transit.

The Call type list allows you to choose calls the call type of which correspond to the selected values in this list:

• Unknown.
• Internal.
• Incoming.
• Local.
• National.
• International.
• Mobile.
• Transit.
• VoIP.
• Corporate.
• SMS.MMS.
• Free line.
• Paid line.

The Record type list allows you to select calls that have the record type corresponded to the selected values in this list. There are the following options:

• Unknown.
• Regular.
• Transfer.
• Conference.
• Not answered.
• Realtime.
• Imported.
• DataFlow.
• Automatic Call Distribution.
• Automatic Call Distribution transfer. 
• Automatic Call Distribution conference.
• TextMessage.

The Release cause list allows you to select calls with the specific release cause. There are the following options in the list:

• Unknown.
• Unassigned number.
• No route to specified transit network.
• No route to destination.
• Send special information tone.
• Misdialed trunk.
• and others.

In the case when you need to unite the set filter parameters with previously saved filter, the Combine with filter boxes are used. In the right list, where the word of OR is displayed, select the logical function, which will unite the set filter parameters with the saved filter.

In the left list, select the name of desired saved filter.

There are additional filter parameters that are set on the Advanced tab (Figure 4).

Figure 4

This tab includes the following filter parameters.

The Auth code box allows you to select calls that were made with authorization code entered in this box.

The Category list allows you to select calls which are corresponded to specified categories.

The Cost from box allows you to filter calls, which have the cost more than specified value.

The Cost to box allows you to filter calls, which have the cost less than specified value.

If you need to select calls for specific day of the week, use the Day type list. Select the desired day types. The following values are available:

• Unknown.
• Workday.
• Saturday.
• Sunday.
• Holiday.

If you need to select calls for specific time period, use the Time of day calendar boxes. Select the From and / or To calendar boxes and set the desired time period.

If you want to filter calls with specific duration, use the Duration calendar boxes (From, To).

If you want to filter calls with specific ring time, use the TTA calendar boxes (From, To).

If you wish to look at a part of SQL query that is after the word WHERE of the query for the set filter parameters, click on the Show query button. The SQL Editor window appears as shown in Figure 5. 

Figure 5

You can change the query and save it. Only users with rights of Tariscope administrators have ability to change the query.

If you have set all desired parameters for view, click on the Save button. The view is displayed that contains calls which correspond to the filter parameters.

If you open the View page first time, you see only the Standard views group. After you have created a new view, the Your views and Recently opened groups appears, where is the new created view. The Your views group contains all your views. By default, the Recently opened group contains 5 views that you recently opened. You can change this value. To do this, click on the Additional options menu item, then the System variable subitem. The System variables page is opened. Select the WebViewLastOpenedSize variable, click on the Edit icon on the toolbar, and change the value in the Edit window.

An example of the opened view is shown in Figure 6.

 Figure 6

A view has a toolbar and table with calls information.

If you set a restriction for displaying view rows when creating a view (Figure 3) 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 meet the filtration conditions of the view 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. The menu is opened that contains items corresponded to icons of toolbar.
• Save changes. It allows you to change the view settings.
• Rename. It allows to rename the view.
• 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 recharge the selected rows.
• Recharge all rows. A choice of the icon allows you to recharge all rows of the view.
• Record details. A choice of the icon opens the Call details view that can contains 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.
• 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).
• Filter by selection. Selecting this icon allows you to filter the data of 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. Selecting this 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.
• 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 of the column. The list of columns available for display is given below.
• 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 that 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.
• Show SQL filter. A choice of the icon allows you to look at SQL query that is applied to the view.
• Save this view. If you have made changes to the view, for example, you used filtering, sorting, grouping, changed fields for display and more, and now you want to save these changes in a new view, click on the Save this view icon. The view will be saved with the name you specified in Your views group. But the previous view remains open.
• Save filter. This icon saves the filtering options currently used in the view. In the future, this filter can be used to create new views faster.
• 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.
• Automatic page refresh. This icon is used to set a time 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 time 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.

The list of call view fields

A view for calls can display the following columns:

• ID. The row identifier.
• Node. Displays a node name where the call was made.
• Equipment. Displays a PBX name.
• Date/time. Displays date and time of call beginning.
• Date. Displays date of call beginning.
• Time. Displays time of call beginning.
• End of call. Displays call end time.
• Record. Displays a record type.
• Call type.
• Direction. Displays a call direction.
• Originator. Displays a call originator. It is a subscriber's extension for outgoing and internal calls. And it is a route or gateway number for incoming and transit calls.
• Originator Aux. ID. Displays an originator auxiliary identifier. It is used in specific PBXs to uniquely identify the call initiator.
• Terminator. Displays a call terminator. It is a subscriber's extension for incoming and internal calls. And it is a route or gateway number for outgoing and transit calls.
• Terminator Aux. ID. Displays a terminator auxiliary identifier. It is used in specific PBXs to uniquely identify the call terminator.
• Number А. Displays subscriber's extension for outgoing and internal calls. It is a CLID for incoming and transit calls.
• Number B. Displays subscriber's extension to whom the call was made for incoming and internal calls. Displays a dialed number for outgoing and transit calls.
• Duration. Displays a call duration.
• Days. Some PBXs, such as CS1000, Meridian1, support calls with duration of some days. This fields displays number of days of call.
• Call seconds. Displays a call duration in seconds.
• Cost. Displays a call cost.
• Cost2. Displays a call cost that is calculated on rate of alternative provider.
• Parent call ID. Displays ID of record with which the current record is linked.
• Access code. If access code was applied in dialed number, it displays in the column.
• Dialed number.
• Original dialed number. If Tariscope changed the original dialed number, for example, it deleted access code, this column displays the original dialed number.
• CLID. Calling Line Identification. Displays a telephone number of external subscriber for incoming calls.
• Original CLID. If CLID was changed in Tariscope, this column displays the original CLID that CDR contains.
• DNIS. Dialed Number Identification Service. This field is accessible only for incoming calls. It displays external telephone number on which the call was made.
• From subscriber. Displays a subscriber's name who made the call.
• From group. This field is applied for outgoing and internal calls. It displays a subscriber group name the subscriber of which made the call.
• To group. This field is applied for incoming and internal calls. It displays a subscriber group name the subscriber of which accepted the call.
• From telephone. This field displays a city name from which the call was made for intercity and international calls. This field displays a mobile provider name for calls were made from mobile telephones.
• To telephone. This field is applied only for outgoing calls. It displays a city name or provider name where the call was made.
• Calling party. Displays a subscriber's name who made the call if this information is in the Tariscope database.
• Called party. Displays a subscriber's name who accepted the call if this information is in the Tariscope database.
• Category. Displays a category name which was set for specific call types.
• Tarif. The rate value that it used to calculate a call cost is displayed.
• Ring time. Displays a ring time.
• Hold time. Displays a hold time.
• Release cause. Displays a release cause of the call.
• Auth code. Displays an authorization code that was applied for the call.
• Project code. Displays a project code that was entered to make this call.

Management of view groups

The TWA user can combine separate views to groups. It can be useful if you have many views and some of them have similar signs. To create a view group, in the menu, select View → View list and click on the Group management icon on the toolbar (Figure 2). The Group management window appears as shown in Figure 7.

Figure 7

In the Group name box, type a name and click on the +Add button. Until a group does not contain at least one view it is not displayed.

If you need to move a view to the group, on the Views page, select the view and click on the Relocate icon on the toolbar. The Relocating window appears as shown in Figure 8. In the Select group list, select a group and click on the Relocate button. The view will move to the selected group and this group will be displayed in the Views page.

Figure 8

To change a name of group you should in the Edit tab (Figure 9) of the Group management window, select the desired group in the Select group list, enter a new name and click on the Rename button. Then, click on the Done button.

Figure 9

If you don't need a group, you can delete it. To do this, click on the Group management icon on the toolbar of the Views page. In the Group management window, choose the Delete tab (Figure 10). In the Select group list, select the desired group. If you want to delete views that the group contains, check the Also delete the views in the group and click on the Delete button.

Figure 10