Docs for all releases
Page History
...
Screenshot: Import button
| Note | ||
|---|---|---|
| ||
The button will only be active when you filter the rates by the rate table. |
Step 1. Selecting a File and Specifying Additional Parameters
The first thing you need to do in the import configurations view is to select select a rate table (the import template will autocomplete if existentit exists). Then, drag-and-drop or upload an import file. Additionally, you can specify the following parameters:
Screenshot: Step 1. File Settings
| Field | Description | |
|---|---|---|
| Rate Table | This field will be autocompleted with the name of a rate table if the rates are filtered in the Rates section. If not applicable, select a target rate table(s) | |
| Import Template | Select a target template for rates importing if available | |
You can also save the importing file settings as a template for further usage during import. To do so, click the 
button next to the Import Template field, specify the name, and click the Save Template button.
Screenshot: Saving a Template
You can update the working Template
...
by clicking the 
button.
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
|
...
Screenshot: Step 2. Import Settings
Starting from VCS 3.17.0, the user has a possibility to specify a type for each sheet of an imported file. Each sheet type has its own list of columns.Currently, there are 3 sheet types:
...
Starting from JeraSoft Billing v3.18.0, the user has an the option to select the Skip this sheet option for the system to ignore the respective sheet during import. More about sheet types configuration here.
Screenshot: Sheet types
On the second step, you can also save the importing rate table as a template for further usage during import. To do so, specify a template title in the bottom left corner of the tab, and click the Save Template button (see screenshot above).
the respective sheet during import. More about sheet type configuration here.
Screenshot: Sheet types
To open advanced configurations, click on a grey downwards arrow 
icon next to Step 2: Import Settings. Advanced settings contain the following fields:
...
Screenshot: Rates import - Code Rules settings
| Field | Description | |
|---|---|---|
| Code | Indicate a destination code. For all codes, use * (asterisk) | |
| Status | Indicate a status for the rates. By default, it will be Active. Set the Stashed status if you want to double-check them later after import. | |
| Effective Date | Specify a start date of a rate. There are various options to schedule this date:
| |
| Time Profile | Indicate time profile that will be used for a current rate, for example, business time, non-business time, weekends, etc. | |
| Min | Minimal time of the call that will be tariffed. For example, if the total call time was 20 seconds and Min is 30, the client will pay for 30 seconds of the call. | |
| Int | Tariffication interval. This parameter is used, when Min Time time expires. | |
| Extra | Additional parameters are stored under the downwards arrow
| |
...
Screenshot: .csv file with detailed error data
Confirming Rates
Confirming Rates
If you choose Stash Status of the rates during the Import processWhen the procedure has been executed, you will be forwarded to the Rates section where all imported rates will be displayed. If the Auto-Confirm option was disabled during the import process, you Here you need to Mass Edit the rates' status from stashed to active.
Screenshot: Confirming Rates
Import History Tab
...
Screenshot: Import History output
| Column | Description | ||||||
|---|---|---|---|---|---|---|---|
Date | Time and date of import execution | ||||||
Details | Login of a user who executed the import | File | Import and the import file. By clicking on the | ||||
| Total Rows | Total amount of imported rows | ||||||
| Total Rates | 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 | ||||||
| Closed | Total amount of closed destinations | ||||||
| Blocked | Total amount of blocked destinations | ||||||
| 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 import procedure (success/failed) | ||||||
| When clicked on, deletes respective import data from the system
| ||||||
...
Overview
Content Tools