View Source

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 exactly 20 tab delimited 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}

_{weekend_initial_charge}

_{weekend_increment_charge}

_blocked

_{connectionCharge}

_compensation

_maximum

_markup

CDR2Cloud Rate Table - Import Field Layout

CDR2Cloud - Rate Table Import

CDR2Cloud Rate Table Source file in Excel

The easiest way to convert your rates into the CDR2Cloud Tab delimited format is to do the following:

Create a Rate Table in CDR2Cloud
Add 2 or 3 rates to the Rate Table
Export the Rate Table to a text file (see the Rate Table - Export topic)
Open the file with Excel. Don't double click the file. Open Excel first, then do "file open" to open the text file. Choose TAB delimited
Update the file with your rates
Save the file as TAB delimited
Import the file into your CDR2Cloud Rate Table (see below).

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.

The maximum Rate Table file size that can be imported with the CDR-10 (Free) Subscription is 5 Mb.