Importing a Rate Table from a file will overwrite the entire content of the target Rate Table.
Converting your Rates to CDR2Cloud Format
CDR2Cloud allows you to import rates from a text file into any Rate table you choose. The source file containing the rates must be in a very specific format that CDR2Cloud will understand. This source file must contain 10 tab separated columns as shown below:
pattern
description
bill_period_initial_len
bill_period_incremental_len
day_start
day_initial_charge
day_increment_charge
eve_start
eve_initial_charge
eve_increment_charge
night_start
night_initial_charge
night_increment_charge
blocked
connectionCharge
compensation
maximum
markup
CDR2Cloud Rate Table - Import Field Layout
CDR2Cloud Rate Table Source file in Excel
To import Rate Patterns from a file to a destination Rate Table, please follow the steps below:
Identify the Rate Table (destination Rate Table) that you would like to import Rates to and click the button.
Drag the (txt) file containing the Rate Patterns to the Upload page or click the Upload Icon to launch the file explorer
The Rates will now be uploaded to the Rate Table and any existing Rate Patterns in the Rate Table will be erased before the import takes place.
Click the [View Rates] button to view the Rate Patterns in the Rate table and ensure that the Import was successful.