Versions Compared

Key

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


Info
titleWARNING

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:


patterndescriptionbill_period_initial_lenbill_period_incremental_lenday_startday_initial_chargeday_increment_chargeeve_starteve_initial_chargeeve_increment_chargenight_startnight_initial_chargenight_increment_chargeweekend_initial_chargeweekend_increment_chargeblockedconnectionChargecompensationmaximummarkup

CDR2Cloud Rate Table - Import Field Layout

CDR2Cloud - Rate Table ImportImage Added

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:

  1. Create a Rate Table in CDR2Cloud
  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 as TAB delimited
  7. 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:

  1. Identify the Rate Table (destination Rate Table) that you would like to import Rates to and click the Image Modified button. 
    CDR2Cloud - Rate Table Import RatesImage RemovedImage Added 
  2. Drag the (txt) file containing the Rate Patterns to the Upload page or click the Upload Icon to launch the file explorer
    CDR2Cloud - Import RatesImage RemovedCDR2Cloud - Date Table ImportImage Added 
  3. 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.
    CDR2Cloud - Import Rates Success
  4. Click the [View Rates] button to view the Rate Patterns in the Rate table and ensure that the Import was successful.

 

 

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


Info
iconfalse
titleRATES & RATE TABLE TOPICS

Page Tree
expandCollapseAlltrue
rootRates & Rate TablesexpandCollapseAlltrue
spacesCDR2CLOUD