Docs for all releases
View User Guide 3.26 or visit our current documentation home page.
Tab overview
Export tab provides great flexibility in configuring the way rates will be exported in .csv or .xls files (see screenshot below).
You can use the same advanced search tool, as provided on the 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 the following fields:
Field | Description |
---|---|
Type | Indicate a rate type:
and a respective effective date |
Code/Сode Name | Specify code/code name of an exporting file |
Service | Specify a target service |
Policy | Select the rate policy:
|
Tag | Indicate a respective label |
Imported File | Select a 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:
|
Next Diff Status | Indicate how the next rate table should differ from a current one:
|
Rate | Specify a price interval |
Setup Fee | Specify a setup fee interval |
Min Volume | Specify a minimal volume interval of tariffed events |
Interval | Specify a tariffication interval |
Profile | Select a time profile (all time, business time, non-business time, weekends) |
Grace Volume | Specify a grace volume interval |
End Date | Indicate a final date |
Status | Determine rate status:
|
Step 2. Specifying Date And Format Options
On this step, fill in the following fields:
Field | Description | |
---|---|---|
Last Export Date | Parameter that affects the Rate changes field (depending on it, the exported rates will be marked as new, changed, deleted, etc.) | |
Date Format | The date format in your export file. The syntax is as follows: 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 an export file if needed | |
Codes Output | Specify how codes must be displayed. The options are: | |
| Each code is placed into a single row | |
| Codes are grouped by code name in a row, for example: 5510, 5511, 5512 | |
| 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 filter the export by selecting only codes, which are present in a specified Code Deck | |
Header text/Footer text | Allows you to put some text into an exported file as header and footer, respectively |
You may save settings as a template of Rate Notification. But note that a reseller's rate notification template will be overridden by the 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 | A 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 a current rate and a previous one |
Prev Diff Status (export) | Rate's changes after the last export. Shows the status of how a current rate differs from a previous one. |
Notes | Additional information about a rate |
Tag | Tag, assigned to a respective rate |
Policy | Rate policy (additive or regular) |
Status | Rate status |
Click the Process button and save an exporting file when you finish configuring the parameters.
Rates sorting will be made by the very first column. For example, if you want rates to be sorted by A-Z destination name, make Code Name your first column.
Please note, that for reseller's rate notification, existing rate export template settings have higher priority than personal.