Docs for all releases
Page History
...
The system will recognize the file and display first 5 rows of it. Then, you need to indicate the following required columns:
- 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.
the first sheet. To switch from one sheet with rates to another, click on respective tab: Sheet 1, Sheet 2, etc.
Starting from VCS 3.17.0, user has a possibility to choose specify a type for each sheet of an imported file. Each sheet type has its own list of column.Currently, there are 3 sheet types:
- Rates type - a mandatory sheet type with the most diverse list of columnsan 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
...
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 |
...