Export

In this article

Tab overview

Export tab provides great flexibility in configuring the way rates will be exported in .csv or .xls file (see screenshot below).

You can use same advanced search tool as provided on Rates tab, to choose which rates you would like to export (including all, old, current, future or current/future).

Screenshot: Rates exporting window

Rates Exporting Process

Whole export process is logically divided in three steps.

Step 1. Specifying Filter Parameters

Here you need to fill in next fields:

Field	Description
Type	Indicate a rate type: current / future current on future for past for all and respective effective date
Code / Сode Name	Specify code / code name of exporting file
Service	Specify a target service
Policy	Select the policy of the rate: *additive* - this policy signifies a usual rate definition for the event; *regular* - this policy signifies that this rate will be added to a regular rate for the event.
Tag	Indicate a respective label
Imported File	Select target imported file
Join Parent checkbox	Enable this checkbox if you need to include rates from the parent rate table
Prev Diff Status	Indicate how current rates differ from the previous ones by choosing: *Decreased* *Increased* *Unchanged* *New*
Next Diff Status	Indicate how should differ a next rate table from a current one: *Decreased* *Increased* *Unchanged* *New*
Rate	Specify price interval
Setup Fee	Specify setup fee interval
Min Volume	Specify minimal volume interval of tariffed events
Interval	Specify tariffication interval
Profile	Select time profile (*all time, business time, non-business time, weekends*)
Grace Volume	Specify grace volume interval
End Date	Indicate a final date
Status	Determine rate status: *stashed* means that the rate will not be used for billing or routing process; *active* means that tha rate is confirmed and used for billing.

Step 2. Specifying Date And Format Options

On this step, fill in the following fields:

Field	Description
Last Export Date	Parameter that affects Rate changes field (depending on it exported rates will be marked as *new, changed, deleted*, etc.)
Date Format	Date format in your export file. Syntax is following: for example, if you indicate *%d-%m-%Y* here, your date will look like *25-03-2018*
Code Deck	Select a code deck here to rewrite code names in export file if needed
Codes Output	Specify how codes must be displayed. The options are:
	Separate rows	Each code is placed into a single row
	Delimited list	Codes are grouped by code name in a row, for example: 5510, 5511, 5512
	Ranges list	Codes are grouped by code name into ranges plus delimiter, for example: 5510-5512, 5515
Data Format	Specify output file format, .xls or .csv
Fields Delimiter	Set delimiter for fields if you've chosen .csv
With headers row checkbox	Include column names into the file
Codes from code deck checkbox	Allows you to additionally filter the export by selecting only codes which are present in specified Code Deck
Header text / Footer text	Allows you to additionally put some text into exported file as header and footer, respectively

Tip

You may save settings as a template of Rate Notification. But note that reseller's rate notification template will be overridden by existing rate export template.

Step 3. Selecting Columns To Export

Here you can select from the drop-down list of maximum 16 columns to export:

Field

Description

Code / Сode Name

Code / code name of rates

Effective Date

Start date before which the rate will not be used

Rate

Price per unit, specified in respective service settings

Min Volume

Minimal time interval of tariffed calls

Interval

Tariffication interval

Grace Volume

Free of charge unit

Setup Fee

An initial fee that is charged when event duration is longer than 0 seconds

Profile

Time profile (all time, business time, non-business time, weekends)

End Date

Final date after which the rate will expire

Previous Rate

Last rate in usage

Prev Diff

Cost changes of the rates

Prev Diff Status

Difference between current rate and the previous one

Prev Diff Status (export)

Rate's changes after the last export. Shows the status how current rate differs from previous one.
The rate will have an unchanged status if the Effective Date of rate is lower than the Last Notification Date

Step 1: Notification type: All rates unique mode - First Notification: 07/07/2017
Code	Rate	Effective Date	Previous Rate	Prev Diff	Prev Diff Status	Prev Diff Status (export)
1	10	07/01/2017 00:00:00 +0000	-	-	new	unchanged
2	10	07/01/2017 00:00:00 +0000	-	-	new	unchanged
3	10	07/01/2017 00:00:00 +0000	-	-	new	unchanged
Step 2: Added new rates with effective date 07/21/2017 - Second Notification: 07/14/2017
Code	Rate	Effective Date	Previous Rate	Prev Diff	Prev Diff Status	Prev Diff Status (export)
1	15	07/21/2017 00:00:00 +0000	10	5	increased	increased (5.0000)
2	15	07/21/2017 00:00:00 +0000	10	5	increased	increased (5.0000)
3	15	07/21/2017 00:00:00 +0000	10	5	increased	increased (5.0000)
Step 3: Rate with code 1 was edited and the increase was canceled - Third Notification: 07/21/2017
Code	Rate	Effective Date	Previous Rate	Prev Diff	Prev Diff Status	Prev Diff Status (export)
1	10	07/21/2017 00:00:00 +0000	10	0	unchanged	unchanged
2	15	07/21/2017 00:00:00 +0000	10	5	increased	increased (5.0000)
3	15	07/21/2017 00:00:00 +0000	10	5	increased	increased (5.0000)
Step 4: Rate with code 2 was edited and added a new rate for code 3 - Fourth Notification: 07/28/2017
Code	Rate	Effective Date	Previous Rate	Prev Diff	Prev Diff Status	Prev Diff Status (export)
1	10	07/21/2017 00:00:00 +0000	10	0	unchanged	unchanged
2	20	07/21/2017 00:00:00 +0000	10	10	increased	unchanged
3	20	07/31/2017 00:00:00 +0000	15	5	increased	increased (5.0000)

Notes

Additional information about rate

Tag

Tag, assigned to a respective rate

Policy

Rate policy (additive or regular)

Status

Rate status

Click on Process button and save exporting file when you finish configuring the parameters.

Tip

Rates sorting will be made by the very first column. For example, if you want rates to be sorted by A-Z destination name than make Code Name your first column.

Please note that for reseller's rate notification existing rate export template settings have higher priority than personal .