[OpenSIPS-Users] CDRTool destinations /rates question

[Brian Chamberlain]

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
>>>> 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
>>
>> * 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

* 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.