Docs for all releases
Page History
...
- Rates type - an equivalent to a importing page from earlier version. While importing, at least 1 sheet must be of Rates type. For this type, the following columns are mandatory:
- Dst Code/Code Name - indicate at least one of them
- Rate
- Effective Date - if you don't indicate this column, the Effective Date, specified in the Code Rules information block, will be applied to imported rates.
- Src Codes type - this type allows user to indicate source codes / code names and has two columns: Src Code and Src Code Name. If selected, both columns must be specified.
- Dst Codes type - this type allows user to indicate destination codes / code names and has two columns: Dst Code and Dst Code Name. If selected, both columns must be specified.
Screenshot: Sheet types
On the second step, you can also save the importing rate table as a template for further usage in importing process. To do so, in the bottom left corner of the tab, specify a template title and press Save Template button.
To open advanced configurations, click on grey downwards arrow icon next to the Step 2: Import Settings. Advanced settings contain the following fields
Screenshot: Step 2. Import Settings
Field | Description | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
On Duplicates | Determines billing behavior if it finds duplicate rate row. Duplicates are checked by Code + Effective Date pair of columns.
| ||||||||||||
On Errors | Determines billing behavior if an inconsistency or error was found in importing file (data inconsistency, incorrect symbols, etc.)
| ||||||||||||
Date Format | Specify date format of imported file. Please note, the auto-detection of date and time can be performed with files that contain one of the date and time formats, listed below:
| ||||||||||||
Custom format | If defined, this format will be used for date parsing instead of Date Format field | ||||||||||||
Optimize Codes | This option allows to make shorter codes of importing code range. For example, code range 4400-4409 will be shortened to 440. Please note, a single code 44001 will not be shortened to 440, it only works for code ranges specified with dash "-".
| ||||||||||||
Billing Increment | Billing Incement defines the way events are billed and includes minimum volume, combination of Indicate the order of data recognition in Billing Increment column:
| ||||||||||||
Skip Dash in Codes | Select whether dash in codes must be skipped or not:
| ||||||||||||
Split Src Code Name | This option is used only in case source code names contain underscore symbol. Choose one of the following:
| ||||||||||||
Update Code Deck | Select the way you want a both Src and Dst code decks to be updated with new/existing code names from current rates file
| ||||||||||||
Dst Code Deck | Dst Code Deck that will be used for Update Code Deck option. Select a destination code deck that you want to update with the above-mentioned settings (note that code deck specified settings here will only be available if you are importing file which contains Code Names in addition to Codes) | ||||||||||||
Src Code Deck | Src Code Deck that will be used for Update Code Deck option. Select a source code deck that you want to update with the above-mentioned settings (note that code deck specified settings here will only be available if you are importing file which contains Code Names in addition to Codes) | ||||||||||||
Notificator Code Deck | Specify code decks that will be used for the next rates notification | ||||||||||||
AZ Mode | A special mode that determines system behavior regarding active/future rates:
| ||||||||||||
AZ codes | Available if AZ Mode is active. Specify the exact code(s), AZ Mode is going to be applied to. By default, field value is * (all codes) | ||||||||||||
AZ interval (days) | Available if AZ Mode is active. It consists of two fields where time and date of rates closure are specified:
| ||||||||||||
AZ close date | Available if AZ Mode is active. Field displays the time and date of rates closure based on the AZ interval (day) parameters |
Code Rules Information Block
...
Screenshot: Rates import - Code Rules settings
Field | Description | |
---|---|---|
Code | Indiacte a destination code. For all codes, use * (asterisk) | |
Service | Select a service for rate | |
Effective Date | Specify a start date of a rate | |
Profile | Indicate time profile that will be used for current rate, for example business time, non-business time, weekends, etc. | |
Min | Minimal time of call that will be tariffed. For example, if total call time was 20 seconds and Min is 30, then client will pay for 30 seconds of call | |
Int | Tariffication interval. This parameter is used, when Min Time time expires. | |
Extras | Additional parameters are stored under downwards arrow icon.
|
After specifying all additional parameters, press Import button.
...
By clicking on Download file, a .csv file with the following columns is downloaded:
Column | Description | |
---|---|---|
Sheet | Index number of the sheet, where error occurred | |
Line | Line of the sheet, where error occurred | |
Errors | Description of the error that occurred |
Screenshot: .csv file with detailed error data
...
Screenshot: Import History tab
Column | Description | |
---|---|---|
Date | Time and date of import execution | |
User Login | Login of a user who executed import | |
File | Import file. By clicking on icon, the file will be downloaded | |
Total | Total amount of imported rates | |
New | Total amount of rates with New type | |
Increased | Total amount of rates with Increased type | |
Decreased | Total amount of rates with Decreased type | |
Unchanged | Total amount of rates with Unchanged type | |
A-Z Closed | Number of rates, closed by A-Z import | |
A-Z Stashed | Number of rates, stashed by A-Z import | |
Status | Status of imopt procedure (done/failed) | |
Error File | File that contains description of all errors, occured during import. By clicking on icon, the file will be downloaded | |
icon | When clicked on, deletes respective import data from the system |