[Spce-user] Billing Plan fallback on missing fee

Thu Feb 2 10:44:46 EST 2017

I'm doing tests over that, but not using the cdr client ... but integrating the real-time evapi, so far, so good till now. Still some scenarios not working, but trying to figureout why and fixing them. 

> De: "Barry Flanagan" <barry at flanagan.ie>
> Para: "Raúl Alexis Betancor Santana" <rabs at dimension-virtual.com>
> CC: spce-user at lists.sipwise.com
> Enviados: Jueves, 2 de Febrero 2017 15:59:57
> Asunto: Re: [Spce-user] Billing Plan fallback on missing fee

> On 2 February 2017 at 15:33, Raúl Alexis Betancor Santana <
> rabs at dimension-virtual.com > wrote:

>> Are you using the Kamailio evapi ? as the cGRates tutorial suggest, or other way
>> to create the CDRs?

> No because that would require more customization to SP than we wish to do. So
> far we have just used the cdr client cdrc to inject them.

> As I say, at this point we are just at the proof of concept stage. Lacking in
> manpower right now to push it further - cgrates itself is a steep learning
> curve. Hopefully some time this year we will run the two in parallel as a
> further test and see how it goes.

> -Barry

>> Best regards

>>> De: "Barry Flanagan" < barry at flanagan.ie >
>>> Para: "Oleg" < spce at irg-x.net >
>>> CC: spce-user at lists.sipwise.com
>>> Enviados: Jueves, 2 de Febrero 2017 15:47:59
>>> Asunto: Re: [Spce-user] Billing Plan fallback on missing fee

>>> On 2 February 2017 at 15:34, Oleg < spce at irg-x.net > wrote:

>>>> Interesting, I would have bet you'd be modifing kamailio-proxy.cfg to add routes
>>>> with cgrates acc code.

>>> No - I think that might be a step too far for the good people at Sipwise Support
>>> :-)

>>> -Barry

>>>> Thanks

>>>> Oleg

>>>> On 2017-02-02 16:24, Barry Flanagan wrote:

>>>>> On 2 February 2017 at 14:53, Oleg < spce at irg-x.net > wrote:

>>>>>> Thanks for Your comment. Indeed, I too have to update 10 or 30
>>>>>> Billing Plans every time my upstream providers change rates. It's
>>>>>> somewhat cumbersome to maintain and repeat same fees across all the
>>>>>> billing plans all the time.

>>>>>> Your idea with CGRates sounds interesting. Any pointers for
>>>>>> integration between sipwise and cgrates?

>>>>> We would just intend to replace rate-o-mat with a daemon to feed in
>>>>> the CDR to cgrates then mark them as rated in SP. Our invoicing system
>>>>> then takes in its rated CDR from cgrates instead of SP.

>>>>> We have already decoupled our front-end rate management system from
>>>>> SP. Instead of writing the rates directly to SP it gets written to a
>>>>> separate system, which can then populate the rates in either/both SP
>>>>> and cgrates.

>>>>> So far we have successfully exported the same rate card to both
>>>>> systems and have sent sample SP CDR to cgrates and confirmed they were
>>>>> correctly rated. Still a lot of work to do though.

>>>>> -Barry

>>>>>> Thanks.

>>>>>> Oleg.

>>>>>> On 2017-02-02 14:48, Barry Flanagan wrote:

>>>>>> On 2 February 2017 at 13:01, Oleg < spce at irg-x.net > wrote:

>>>>>> Hello,

>>>>>> Just wandering if there is a way to tell SPCE to fallback to an
>>>>>> alternative billing_plan if rate-o-mat does not find a Fee in the
>>>>>> current plan (on Customer's billing plan missing Fee, apply
>>>>>> Reseller' billing plan fee for the given destination, if present).

>>>>>> No, not possible at the moment. Pity. It would be great if you
>>>>>> could
>>>>>> assign a "fallthrough" rate card to a customer. So, you could have
>>>>>> your standard rate card as base, and then for customer A you can
>>>>>> have
>>>>>> a rate card with just a few (say UK) rates. A call from this
>>>>>> customer
>>>>>> would first check their rate card and if not found, check the
>>>>>> fallthrough one.

>>>>>> This would mean that instead of having to maintain full separate
>>>>>> rate
>>>>>> cards for every customer where there is a slight difference, you
>>>>>> just
>>>>>> maintain the standard rates and then the smaller individual rate
>>>>>> cards
>>>>>> per customer.

>>>>>> This and the lack of multiple Free Time "buckets" are my biggest
>>>>>> gripes with SP (I am on Pro).

>>>>>> We are actually investigating cgrates as an alternative rating
>>>>>> engine
>>>>>> (we don't use the invoicing built in to SP)

>>>>>> -Barry Flanagan

>>>>>> Example.

>>>>>> - 'DefaultResellerBillingPlan' contains all the destinations
>>>>>> - 'ClientsOfferPlan' contains one destination Fee only (ex.: 5%
>>>>>> discount calculated for fees to US
>>>>>> '^1,on_peak_init_rate,on_peak_init_interval,...')

>>>>>> A user with 'ClientsOfferPlan' assigned is billed through
>>>>>> DefaultResekkerBillingPlan for all the destination (therein
>>>>>> present), except for one Fee ('^1'), which is billed through
>>>>>> 'ClientsOfferPlan'.

>>>>>> In other words, I'd like sipwise to rate (and include in Invoice)
>>>>>> 'accounting.cdr.source_reseller_cost' (if > 0) when
>>>>>> accounting.cdr.source_customer_cost=0.

>>>>>> Is this possible?

>>>>>> Thank You

>>>>>> Oleg
>>>>>> _______________________________________________
>>>>>> Spce-user mailing list
>>>>>> Spce-user at lists.sipwise.com
>>>>>> https://lists.sipwise.com/listinfo/spce-user [1] [1]

>>>>>> Links:
>>>>>> ------
>>>>>> [1] https://lists.sipwise.com/listinfo/spce-user [1]

>>>>> Links:
>>>>> ------
>>>>> [1] https://lists.sipwise.com/listinfo/spce-user

>>> _______________________________________________
>>> Spce-user mailing list
>>> Spce-user at lists.sipwise.com
>>> https://lists.sipwise.com/listinfo/spce-user

>> _______________________________________________
>> Spce-user mailing list
>> Spce-user at lists.sipwise.com
>> https://lists.sipwise.com/listinfo/spce-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20170202/611a9687/attachment-0001.html>