This documentation relates to an earlier version of JeraSoft VCS.
View User Guide 3.20 or visit our current documentation home page.
Skip to end of metadata
Go to start of metadata
On this page

Export Section Tab

Rates exporting to Microsoft Excel *.CSV or *.XLS files (see screenshot below).

You can use same search engine as provided on Rates tab, to decide which rates you would like to export (including confirmed/unconfirmed, old, current, future or current+future).

 

Screenshot: Rates exporting window

Rates Exporting Process

Whole export process can be logically divided in three steps.

Step 1. Specifying Filter Parameters

Here you need to fill next fields:

FieldDescription
Code / Сode NameSpecify code / code name of exporting file
Status

State of the rate:

  • stashed (unconfirmed) means that the rate will not be used for billing or routing process;
  • active means that tha rate is confirmed and used for billing.
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. 
TagIndicate a respective label
Imported FileSelect imported file
"Join Parent" checkboxEnable this checkbox if you need to include rates from the parent rate table
Prev Diff StatusIndicate how should differ a current rate table from the previous
Next Diff StatusIndicate how should differ a next rate table from a current one
RateSpecify price interval
Setup FeeSpecify setup fee interval
Min Time, secSpecify minimal time interval of tarificated calls
Interval, secSpecify tarification interval
ProfileSelect time profile (all time, business time, non-business time, weekends)
Grace Time, secSpecify grace time interval
End DateIndicate a final date

 

Step 2. Specifying Date And Format Options

Fill here next fields:

FieldDescription
Last export dateParameter that affects “Rate changes” field (depending on it exported rates will be marked as new, changed, deleted etc)
Date FormatDate format in your export file. Syntax is following: for example, if you put “%d-%m-%Y” here, your date will look like 25-05-2011
Code DeckSelect a code deck here to rewrite code names in export file if needed
Codes OutputSpecify how codes should be displayed. There are few options
  • Separate rows
Each code is placed into 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 to additionally filter the export, by selecting only codes which are present in specified Code Deck
Header text / Footer textAllows you to additionally put some text into exported file as header and footer respectively

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 max 16 columns to export:

FieldDescription
Code / Сode NameCode / code name of rates
Effective From Start date before which the rate will not be used
RatePrice per one minute of call
Min TimeMinimal time interval of tarifficated calls
IntervalTarification interval
Grace TimeNot paid time interval in seconds
Setup FeeAn initial fee that is charged when call duration is longer than 0 seconds
ProfileTime profile (all time, business time, non-business time, weekends)
End DateFinal date after which the rate will expire
Previous RateLast rate in usage
Prev DiffCost changes of the rates
Prev Diff StatusDifference between current rate from the previous
Prev Diff Status (export)Rate's changes after the last export
NotesAdditional information about rate
TagLabel that belongs to a respective rate
PolicyRate policy (additive or regular)
Status

State of the rate


Click 
“Process” button and save exporting file when you finish setting 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 as first column.

 Please note that reseller's rate notification template will be overridden by existing rate export template. 

  • No labels