Page Comparison

Challenge

You are a VoIP Retailer and your VoIP Wholesaler (Provider) provides you with 3 different services which you resell to your customers. They are SMS, MMS and VOICE services. Your VoIP Provider provides you with CDR files on a timely basis which you in turn use for billing your customers, however each CDR file contains CDR records for all 3 services as followsshown below in the CDR file extract:

_{click to enlarge}

_{CDR file extract showing SMS VOICE & MMS records in a single file}

You charge your customers 3 different rates for SMS, MMS and VOICE, as follows:

You however can only assign one Rate Table to a Customer record, so you need a solution that will allow you to define 3 separate Rate Tables, one each for SMS, MMS and VOICE and allow the CDR2 Cloud , allowing the CDR2Cloud system to use the applicable table depending on the type of service consumed by your customer.

Solution 

You define 4 separate Rate Tables each having the same name but different Override expression as follows:

The Override RegEx value must be entered as a Regular Expression which evaluates to true. As such the values in this example are enclosed in parentheses.

Image Added

A quick way of creating multiple Rate Tables for a Group is to use the Rate Table Copy feature.

Note that when using the Rate Table Override feature to create a group of Rate Tables, there must always be a main Rate Table having the same name and NO Override RegEx value. As such you will have at least 2 Rate Tables with identical Rate Table Names, one with no Override RegEx and another (or multiple) with with an Override RegEx.

Lastly you will assign the Rate Table to the customer record(s) as shown below:

Image Added

Note that you simply assign the customer record to the main Rate Table and CDR2Cloud will figure out which Rate Table in the Group should be used for each CDR record.