Docs for all releases
View User Guide 3.26 or visit our current documentation home page.
Import Tab
The tab is designed to provide user with a possibility to import rate to VCS by uploading .csv or .xls file. The whole process can be divided in the following steps:
Screenshot: Import tab
Step 1. Selecting File and Specifying Additional Parameters
First, you need to select a file for import. Additionally, you can specify the following parameters:
Screenshot: Step 1. File Settings
Field | Description | |
---|---|---|
Import template | Select a target template for rates importing | |
Delimiter | Specify here a delimiter symbol. Possible options are:
By default, autodetect option is chosen. | |
Auto Confirm | Select whether the system must confirm imported rates automatically or not |
Warning
- It's not possible to import a file into the Rate Table with the Min Time and Interval = 0. These fields must have at least 1 second.
- While specifying the Effective Date and End Date keep in mind that by default Time zone is UTC (+0000).
Step 2. Import Settings
The system will recognize the file and display first 5 rows of it. Then, you need to indicate the following required columns:
- 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.
To switch from one sheet with rates to another, click on respective tab: Sheet 1, Sheet 2, etc.
On this 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.
Attention Alert limitation about rate duplicates during import process. It means that the import process cannot proceed if you get more than 1,000 duplicate alerts. This limitation applies while the Alert me about duplicates option is enabled in the On duplicate rates field in the Import tab | |
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 "-".
Tip Therefore, when you make an import with enabled Optimize codes option and your importing file consists of code 440 and code range 4400-4409 at the same time, the import result will depend on the On duplicate rates settings. | |
Update Code Deck | Select the way you want a code deck to be updated with new/existing code names from current rates file
| |
Code Deck | Code Deck that will be used for Update Code Deck option. Select a 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:
Tip For a detailed explanation, check out our Knowledge Base article Attention Starting from version 3.16.0, in Day field you can specify a negative value to close active rates with a past date | |
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 |
Attention
Starting from version 3.16.0, Close rates marked by field in Settings section works for Rate field of imported file as well.
Code Rules Information Block
For adding a new code rule, click on the plus icon next to information block name.
When you add a rule and set the value in the fields, it will overwrite parameters specified the respective columns of the file. If you leave fields empty, it will take the parameters from the file.
If you a add a rule with * code for a certain service, not specified columns of the imported rates will be filled in with respective field values of this code rule. You can add rules with * code for all services. The list of code rules fields is as follows:
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.
Step 3. Import Errors
Provided a non-critical error(s) occured, you will be displayed a table, where exact sheet, line and error description are specified (see screenshot). In this case, you need to start the whole import procedure from the beginning.
Screenshot: Step 3. Import Errors
In case numerous errors occurred while importing rates, you will be displayed the respective notification:
Screenshot: Error notification
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
Comfirming Rates
When the procedure has been executed, you will be forwarded to Rates tab where all imported rates will be displayed. They are divided into the following types: Unchanged, Increased, Decreased, New. By clicking on respective buttons in the top right corner of the tab, you can filter rates by the type (see screenshot).
Attention
Imported rates will be marked as Unchanged, Increased, or Decreased only if their Effactive Rate value (e.g. 04.25.2018) is higher than Effective Rate of a current rate (e.g. 04.10.2018)
If Auto-Confirm option is disabled, you need to press Confirm Filtered Rates button (see screenshot) to change rates status from stashed to active.
Screenshot: Confirming Rates
Import History Tab
The tab contains information about all executed imports to this rate table. It is presented in a form of table with the following columns:
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 |