Tariscope 4.6. User's guide
Chapter 1 Getting started with Tariscope
Getting started with Tariscope the Tariscope administrator must perform the following actions:
- to install Tariscope;
- to activate Tariscope;
- to configure Tariscope.
These actions do not describe in the document. How to install, activate, and configure Tariscope, see in the document “Tariscope 4.6. Administrator’s guide”.
Tariscope 4.6. User's guide
Contents
Chapter 1 Getting started with Tariscope
Charpter 2 Tariscope application
2.1. Tariscope interface
2.2. Working with views for calls
2.2.1. Creating or selecting a view for calls
2.2.2. Management of the views
2.2.3. Fields of a view for calls
2.2.4. Working with Call View
2.2.5. View for services
2.2.6. Provider summary view
2.2.7. View for IP traffic
2.2.8. Data filtering
2.2.9. Filter by selection and Exclude selection
2.2.10. Selection of related records
2.2.11. Filter by extensions
2.2.12. Selection of calls for a period
2.2.13. Edit SQL filter
2.2.14. Saving and applying filters
2.2.15. Sorting data
2.2.16. Grouping function
2.2.17. Call categories
2.2.18. Transferring phone numbers from one subscriber to another
2.2.19. Import of accrued one-time services in Tariscope
2.3. Provider reports
2.3.1. Non-working DNs
2.3.2. Charged services
2.3.3. Recurring services charged
Tariscope 4.6. User's guide
Chapter 2. Tariscope application
2.2. Working with views for calls
Mainly the Tariscope users work with views for calls. A view for calls is the Tariscope page, in which the call data are displayed in the table form. Usually one table row corresponds to one call. For calls where a call transfer or conference were used, the call information can be contained in several table rows. Each view can have own parameters such as:
- Filtering options. They provide a display of only specific records, for example, the calls of only a specific subscriber, group of subscribers, calls during a specific period, etc.
- Sorting options. They allow to sort information in the table using one or a group of fields.
- Fields of the view. A user can set a list of fields, which will be displayed in the view.
- Data grouping. Data of a view for calls can be grouped according to some of the fields that allows you to quickly create summary reports.
You can open views with different settings in the different tabs of your browser.
Tariscope 4.6. User's guide
Purpose
This document is intended for users of the Tariscope Enterprise and Tariscope Provider editions for version 4.6 or later. Further in the text, if there is no need to clarify the edition, the Tariscope name is used. This guide describes all features of the Tariscope applications except the Tariscope installation, configuration, and maintenance.
The Tariscope installation, configuration, and maintenance are described in the Tariscope 4.6. Administrator’s guide.
Introduction
There are two editions of the Tariscope system: Tariscope Enterprise and Tariscope Provider.
The Tariscope Enterprise edition is a call accounting software for companies that have one or a group of PBXs and these telephone systems are used for their own purposes.
The Tariscope Provider edition is a telecom billing system for telecommunications service providers.
Further in the text, if there is no need to clarify the edition, the Tariscope name is used.
- provides a collection of information about calls from various data sources, such as an Ethernet port using TCP, UDP, FTP, and SFTP, local and remote folders, databases, a serial port etc.;
- processes the received information with a definition of the subscriber who made or received a call, with a call rating;
- carries out a search of the desired information about the calls or received / transmitted data using filters of different levels of complexity;
- creates reports with text and graphic information;
- assesses telephone traffic for routes, trunks (lines), or subscribers;
- includes a customer account management (only for the Tariscope Provider edition);
- interacts with other systems, for example, hotel, accounting, CRM, and others;
- manages telecommunications equipment using money or time limits on the volume of calls made or the use of Internet services;
- gives a customer (subscriber) access via the Web interface to get information about the customer (subscriber) account, call details, data traffic and allows an issue to be sent to get help or obtain information, etc.;
- collects information on Internet use from a range of data transmission equipment using NetFlow (version 5, 9), IPFIX, rFlow protocols.
The Tariscope user must possess certain skills in the telephony services provided to subscribers (customers) and / or the Internet services.
Tariscope 4.6. User's guide
Chapter 2. Tariscope application
2.2. Working with views for calls
2.2.1 Creating or selecting a view for calls
If you have already started the process of collecting data about the calls and you want to analyze the data, create a new view for calls. To work with the views, in the Tariscope menu, select Views → Views list. The Views page appears an example of which is shown in Figure 2.2.1.1.
Figure 2.2.1.1
The Views page contains a toolbar, table with views, and text box to search.
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 not available.
- Add. The item allows you to create a new view.
- Group management. This item is used to create, change, or delete a group of 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. The item allows you 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 create 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.
- Background calls recharge. The item allows you to recharge calls of the selected views 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 to file. 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 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 New view for calls page appears is as it is shown in Figure 2.2.1.2.
Figure 2.2.1.2
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. We recommend limiting the number of records.
The Equipment position allows you to select a single telephone system or group of telephone systems for which call information will display. Click on the button located right on the position. 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 a period to display calls information. The list includes the next options:
- 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 period in these boxes.
The next filtering parameters are on the General and Advanced tabs.
The General tab (Figure 2.2.1.2) 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 the desired extension. The records will be selected that contains 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 to 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 subscriber.
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 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. Specify a city (town) name in the box.
The To city box allows you to filter outgoing and transit calls, where the destination is located. Specify a city (town) name in the 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 corresponds to the selected values in this list:
- Unknown.
- Internal.
- Incoming.
- Local.
- National.
- International.
- Mobile.
- Transit.
- Call start.
- Data Transfer (Traffic).
- Data Transfer (Duration).
- VoIP.
- Corporate.
- SMS.
- 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.
- Voice over IP.
- 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 lists 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 2.2.1.3).
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 that match certain categories.
The Cost from box allows you to filter calls, which have the cost more than the specified value.
The Cost to box allows you to filter calls, which have the cost less than the 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.
Figure 2.2.1.3
If you need to select calls for specific day period, use the Time of day calendar boxes. Select the From and/or To calendar boxes and set the desired period.
If you want to filter calls with the specific duration, use the Duration calendar boxes (From, To).
If you want to filter calls with the 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. An example of the window is shown in Figure 2.2.1.4.
Figure 2.2.1.4
You can change the query and save it. Only users with rights of Tariscope administrators have ability to change the query
Also, you can choose the desired fields which will be displayed in the view. To do this, click on the Configuring the view fields button. The Select columns to display window appears as shown in Figure 2.2.1.5.
Figure 2.2.1.5
Choose the desired fields and click OK. A list of a view for calls is described below.
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.
To open an existing view, choose it on the Views page and click on the Open icon in the toolbar.