Versions Compared

Old Version 1

changes.mady.by.user Andrii Zinchenko

Saved on

compared with

New Version 2

changes.mady.by.user Anastasiia Kovalinas

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Export tab provides great flexibility in configuring the way rates will be exported in .csv or .xls file 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

...

Step 1. Specifying Filter Parameters

Here you need to fill in next the following fields:

FieldDescription
Type

Indicate a rate type:

  • current/future
  • current on
  • future for
  • past for
  • all

and a respective effective date

Code/Сode NameSpecify code/code name of an exporting file
Service

Specify a target service

Policy

Select the rate 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. 
TagIndicate a respective label
Imported FileSelect a target imported file
Join Parent checkboxEnable 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 the next rate table should differ from a current one:

  • Decreased
  • Increased
  • Unchanged
  • New
RateSpecify a price interval
Setup FeeSpecify a setup fee interval
Min VolumeSpecify a minimal volume interval of tariffed events
IntervalSpecify a tariffication interval
ProfileSelect a time profile (all time, business time, non-business time, weekends)
Grace VolumeSpecify a grace volume interval
End DateIndicate 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 the rate is confirmed and used for billing.

...

FieldDescription
Last Export DateParameter that affects affects the Rate changes field (depending on it, the exported rates will be marked as new, changed, deleted, etc.)
Date FormatDate The date format in your export file. Syntax The syntax is followingas follows: for example, if you indicate %d-%m-%Y here, your date will look like 25-03-2018
Code DeckSelect a code deck here to rewrite code names in an export file if needed
Codes OutputSpecify 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 FormatSpecify output file format, .xls or .csv
Fields DelimiterSet delimiter for fields if you've chosen .csv
With headers row checkboxInclude column names into the file
Codes from code deck checkboxAllows you to additionally filter the export by selecting only codes, which are present in a specified Code Deck
Header text/Footer textAllows you to additionally put some text into an exported file as header and footer, respectively

...

Panel
borderColor#ccffcc
bgColor#ccffcc
borderWidth2px
borderStylesolid
Tip

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.

...

FieldDescription
Code/Сode NameCode/code name of rates
Effective Date Start date, before which the rate will not be used
RatePrice per unit, specified in respective service settings
Min VolumeMinimal time interval of tariffed calls
IntervalTariffication interval
Grace VolumeFree of charge unit
Setup FeeAn initial fee that is charged when event duration is longer than 0 seconds
ProfileTime profile (all time, business time, non-business time, weekends)
End DateFinal A final date, after which the rate will expire
Previous RateLast rate in usage
Prev DiffCost changes of the rates
Prev Diff StatusDifference between a current rate and the 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.
The rate will have an unchanged status if the Effective Date of rate is lower than the Last Notification Date


Expand
titlePrev Diff Status usage example


Step 1: Notification type: All rates unique mode - First Notification: 07/07/2017
CodeRateEffective DatePrevious RatePrev DiffPrev Diff StatusPrev Diff Status (export)
11007/01/2017 00:00:00 +0000--newunchanged
21007/01/2017 00:00:00 +0000--newunchanged
31007/01/2017 00:00:00 +0000--newunchanged
Step 2: Added new rates with effective date 07/21/2017 - Second Notification: 07/14/2017
CodeRateEffective DatePrevious RatePrev DiffPrev Diff StatusPrev Diff Status (export)
11507/21/2017 00:00:00 +0000105increasedincreased (5.0000)
21507/21/2017 00:00:00 +0000105increasedincreased (5.0000)
31507/21/2017 00:00:00 +0000105increasedincreased (5.0000)
Step 3: Rate with code 1 was edited and the increase was canceledcancelled - Third Notification: 07/21/2017
CodeRateEffective DatePrevious RatePrev DiffPrev Diff StatusPrev Diff Status (export)
11007/21/2017 00:00:00 +0000100unchangedunchanged
21507/21/2017 00:00:00 +0000105increasedincreased (5.0000)
31507/21/2017 00:00:00 +0000105increasedincreased (5.0000)
Step 4: Rate with code 2 was edited and added a new rate for code 3 - Fourth Notification: 07/28/2017
CodeRateEffective DatePrevious RatePrev DiffPrev Diff StatusPrev Diff Status (export)
11007/21/2017 00:00:00 +0000100unchangedunchanged
22007/21/2017 00:00:00 +00001010increasedunchanged
32007/31/2017 00:00:00 +0000155increasedincreased (5.0000)



NotesAdditional information about a rate
TagTag, assigned to a respective rate
PolicyRate policy (additive or regular)
Status

Rate status


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

Panel
borderColor#ccffcc
bgColor#ccffcc
borderWidth2px
borderStylesolid
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  personal.