Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Screenshot: Import button

Image RemovedImage Added

Note
titleNote

The button will only be active when you filter the rates by the rate table.

...

Screenshot: Step 1. File Settings

Image AddedImage Removed

FieldDescription
Rate TableThis 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 TemplateSelect 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 Image Added button next to the Import Template field, specify the name, and click the Save Template button.

Screenshot: Saving a Template

Image Added

You can update the working Template by clicking the Image Added button.

Panel
borderColor#FFBABA
bgColor#FFBABA
borderWidth2px
borderStylesolid

Warning

  1. 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.
  2. While specifying the Effective Date and End Date, keep in mind that Timezone is UTC (+0000) by default.
  3. Please DO NOT import duplicates of the same Code in one import file.

...

Screenshot: Step 2. Import Settings

Image RemovedImage Added

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 type configuration here.

Screenshot: Sheet types

Image Removed

...

Image Added

To open advanced configurations, click on a grey downwards arrow  icon next to Step 2: Import Settings. Advanced settings contain the following fields:

...