| Info | ||
|---|---|---|
| ||
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 exactly 20 tab separated 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 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 . 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.
| Info | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
|