[OpenSIPS-Users] CDRTool destinations /rates question

Adrian Georgescu ag at ag-projects.com
Wed Jan 21 10:18:37 CET 2009


The format of the actual dialed number is a routing problem and a  
configuration of the proxy issue. In CDRTool you always end-up with a  
normalized E164 number regardless of how the request URI was formated  
for the actual terminating gateway.

You may use any translation rules and LCR without having to change or  
configure the rating engine for this.

Adrian


On Jan 21, 2009, at 12:50 AM, Alex Balashov wrote:

> Unlike Brian, I am not familiar with CDRtool beyond a cursory level,  
> so perhaps I'm headed down the wrong track here.
>
> The general problem seems to be that the multiple destination  
> problem (variable-length prefixes) is multidimensional, so it is not  
> just a matter of sending to the longest dial prefix match for a  
> given destination.  The carrier must also be taken into account.   
> So, what is needed seems to be a destination metric that is a  
> composite rate of a gateway and a longest-prefix destination.
>
> The terminating carriers are fixed by a static LCR process.
>
> Is that right, Brian?
>
> Adrian Georgescu wrote:
>
>> Alex, I am trying to understand what precisely you are trying to  
>> achieve. What precisely are you working around that cannot be done  
>> in a natural way?
>> Adrian
>> On Jan 20, 2009, at 7:29 PM, Alex Balashov wrote:
>>> Good workaround is to use translations in the proxy to prepend a  
>>> prefix for each carrier to the DNIS so you can set the rating  
>>> engine loose on that.
>>>
>>> This is how billing systems attached to traditional softswitch  
>>> EMSs work.
>>>
>>> Brian Chamberlain wrote:
>>>
>>>> Thanks Adrian,
>>>> As I said, just trying to find an efficient way of doing this,  
>>>> all the  providers use different destination names, some have  
>>>> codes that don't  exist in the other's databases so trying to  
>>>> pull it all together in  CDRtool is proving a bit testing.
>>>> It is mentioned as a known limitation
>>>> 'The rating engine does not calculate prices based on the  
>>>> outbound  carriers or outbound gateways, the rating plan is is  
>>>> assigned by the  calling party and not by called party.'
>>>> I guess I am trying to figure out an efficient way to deal with  
>>>> the  slight nuances with different providers destination codes  
>>>> and  descriptions and the overlaps in between..
>>>> If it was possible to rate with the destination gateway it would  
>>>> make  things a lot easier.
>>>> Thanks,
>>>> Brian
>>>> On 20 Jan 2009, at 15:38, Adrian Georgescu wrote:
>>>>> If dest is 1 only rate for dest 1 is applied. There is no  
>>>>> longest  match performed for a dest column in a rate table entry.
>>>>>
>>>>> If you want a rate for 1617, add it to the dest table too.
>>>>>
>>>>> Adrian
>>>>>
>>>>> On Jan 20, 2009, at 4:19 PM, Brian Chamberlain wrote:
>>>>>
>>>>>> Hi Adrian,
>>>>>>
>>>>>> Thanks for the quick response. As I thought!
>>>>>>
>>>>>> Can you just confirm that if I have 1 as a destination,1 as a  
>>>>>> rate  and also 1617 as a rate and 1617 is the number dialled  
>>>>>> then  according to the documentation the rating engine will  
>>>>>> find the 1  destination but will do a longest match and find  
>>>>>> 1617 as the rating  record or am I hoping for too much?
>>>>>>
>>>>>> Regards,
>>>>>> Brian
>>>>>>
>>>>>> On 20 Jan 2009, at 15:03, Adrian Georgescu wrote:
>>>>>>
>>>>>>> Hi Brian,
>>>>>>>
>>>>>>> The logic of the rating first determines the destination then  
>>>>>>> it  searches for a price for it. So for every entry in  
>>>>>>> destinations  table you MUST have an entry in the rates table  
>>>>>>> otherwise the  price is zero.
>>>>>>>
>>>>>>> The best practice is to maintain a central minium destination   
>>>>>>> table common for all customers (add entries to it as it grows)  
>>>>>>> and  define custom rates for each of them. Also if you have  
>>>>>>> lot of  resellers you can create a main rating table and add  
>>>>>>> only  exceptions for the destinations particular to some of  
>>>>>>> them.
>>>>>>>
>>>>>>> Adrian
>>>>>>>
>>>>>>>
>>>>>>> On Jan 20, 2009, at 3:56 PM, Brian Chamberlain wrote:
>>>>>>>
>>>>>>>> Hi All,
>>>>>>>>
>>>>>>>> I am sending calls to a number of different sip providers.
>>>>>>>> I have rates & destinations from all of them. Some of the  
>>>>>>>> providers
>>>>>>>> have broken up the amount of destinations into 30,000  
>>>>>>>> different  codes.
>>>>>>>> I am trying to build the rates and destinations tables so it  
>>>>>>>> is  easy
>>>>>>>> to maintain in the future.
>>>>>>>>
>>>>>>>> Would I be best having a minimal set of destinations to cover  
>>>>>>>> each
>>>>>>>> country and my local countries/areas and having the rates  
>>>>>>>> being  more
>>>>>>>> specific.
>>>>>>>>
>>>>>>>> I suppose my questions are the folowing.
>>>>>>>>
>>>>>>>> If I have a destination:
>>>>>>>>
>>>>>>>> 1 USA
>>>>>>>>
>>>>>>>> and a rate for 1 USA .02
>>>>>>>> and a rate for 1617 USA (Boston)
>>>>>>>>
>>>>>>>> and the customer dials Boston then looking at the logic,  
>>>>>>>> even  though I
>>>>>>>> don't have a boston Destination CDRTool will still rate the  
>>>>>>>> call  using
>>>>>>>> the rate for 1617
>>>>>>>>
>>>>>>>> If the reverse was through and I had a destination 1617 for   
>>>>>>>> boston but
>>>>>>>> only a rate for 1 USA would CDRTool use the 1 rate even  
>>>>>>>> though it
>>>>>>>> found the destination for 1617 in the destinations table?
>>>>>>>>
>>>>>>>> Thanks,
>>>>>>>> Brian
>>>>>>>>
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> Users mailing list
>>>>>>>> Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>>>>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>>> Brian Chamberlain
>>>>>> Dot Net Solutions Ltd.
>>>>>> 68 Parkwest Enterprise Centre,
>>>>>> Parkwest,
>>>>>> Dublin 12,
>>>>>> Ireland.
>>>>>> DDI:
>>>>>> [+353]
>>>>>> 1
>>>>>> 6296521
>>>>>>
>>>>>> FAX:
>>>>>> [+353]
>>>>>> 1
>>>>>> 6237029
>>>>>>
>>>>>>
>>>>>> mobile:
>>>>>> [+353]
>>>>>> 86
>>>>>> 3883003
>>>>>>
>>>>>>
>>>>>>
>>>>>> web:
>>>>>> www.asterisk.ie <http://www.asterisk.ie>
>>>>>>
>>>>>> * Looking for the most advanced PBX available that can also  
>>>>>> save  you a fortune in communication costs?  asterisk.ie *
>>>>>>
>>>>>>
>>>>>> e-mail disclaimer
>>>>>>
>>>>>> This e-mail and any files transmitted with it are confidential  
>>>>>> and  intended
>>>>>> solely for the use of the individual or entity to whom they  
>>>>>> are  addressed.
>>>>>> If you are not the intended recipient, you are hereby notified  
>>>>>> that  any use
>>>>>> or dissemination of this communication is strictly prohibited.
>>>>>>
>>>>>> If you have received this e-mail in error, please advise the  
>>>>>> sender
>>>>>> immediately, then delete this e-mail.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>> Brian Chamberlain
>>>> Dot Net Solutions Ltd.
>>>> 68 Parkwest Enterprise Centre,
>>>> Parkwest,
>>>> Dublin 12,
>>>> Ireland.
>>>> DDI:
>>>> [+353]
>>>> 1
>>>> 6296521
>>>> FAX:
>>>> [+353]
>>>> 1
>>>> 6237029
>>>> mobile:
>>>> [+353]
>>>> 86
>>>> 3883003
>>>> web:
>>>> www.asterisk.ie <http://www.asterisk.ie>
>>>> * Looking for the most advanced PBX available that can also save  
>>>> you a  fortune in communication costs?  asterisk.ie *
>>>> e-mail disclaimer
>>>> This e-mail and any files transmitted with it are confidential  
>>>> and  intended
>>>> solely for the use of the individual or entity to whom they are   
>>>> addressed.
>>>> If you are not the intended recipient, you are hereby notified  
>>>> that  any use
>>>> or dissemination of this communication is strictly prohibited.
>>>> If you have received this e-mail in error, please advise the sender
>>>> immediately, then delete this e-mail.
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>>
>>> -- 
>>> Alex Balashov
>>> Evariste Systems
>>> Web    : http://www.evaristesys.com/
>>> Tel    : (+1) (678) 954-0670
>>> Direct : (+1) (678) 954-0671
>>> Mobile : (+1) (678) 237-1775
>
>
> -- 
> Alex Balashov
> Evariste Systems
> Web    : http://www.evaristesys.com/
> Tel    : (+1) (678) 954-0670
> Direct : (+1) (678) 954-0671
> Mobile : (+1) (678) 237-1775

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090121/561f99a9/attachment-0001.htm 


More information about the Users mailing list