Versions Compared

Key

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

Importing a Rate Destination Table from a file will overwrite the entire content of the target Rate Destination Table.

Converting your Rates to CDR2Cloud Source File Destination Table Format

CDR2Cloud allows you to import rates Destinations from a text file into any Rate Destination table you choose. The source file containing the rates Destinations must be in a very specific format that CDR2Cloud will understand.

This source file must contain 10 tab separated columns 3 Comma Separated Value {CSV} columns as shown below:

 

patterndescriptionbill_period_initial_lenbill_period_incremental_lenday_startday_initial_chargeday_increment_chargeeve_starteve_initial_chargeeve_increment_chargenight_startnight_initial_chargenight_increment_chargeblockedconnectionChargecompensationmaximummarkup
CDR2Cloud Rate
disabled

CDR2Cloud Destination Table - Import Field Layout

 

CDR2Cloud - Rate Table ImportImage RemovedCDR2Cloud  Destination Table Source file in ExcelImage Added

CDR2Cloud  Rate  Destination Table Source file in Excel

 

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

  1. Create a Rate Table
  2. Add 2 or 3 rates to the Rate Table
  3. Export the Rate Table to a text file (see the Rate Table - Export topic)
  4. 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
  5. Update the file with your rates
  6. Save the file
  7. Import the file into your CDR2Cloud Rate Table (see below).

To import Rate Patterns

To import Destinations from a file to a destination Rate Table, please follow the steps below:

  1. Identify and open the Rate Destination Table (destination Rate Table) that you would like to import Rates destinations to and click the Image Modified buttonImport Destinations button located at the top right of the page
    Image RemovedImage Added
     
  2. Drag the (txt) file {CSV} file containing the Rate Destination Patterns to the Upload page or click the Upload Icon to launch the file explorer
    CDR2Cloud - Date Table ImportImage RemovedImage Added 

  3. The Rates Destination patterns will now be uploaded to the Rate Destination Table and any existing Rate Destinations Patterns in the Rate Destination Table will be erased before the import takes place.
    CDR2Cloud - Import Rates SuccessImage RemovedCDR2Cloud - Destination Table ImportImage Added

  4. Click the [View RatesDestinations] button to view the Rate Destination Patterns in the Rate Destination table and ensure that the Import was successful.
Info
iconfalse
titleACCOUNT PLAN TOPICS

Page Tree
rootPlans
expandCollapseAlltrue
spacesCDR2CLOUD