[Spce-user] Billing Plan fallback on missing fee

Thu Feb 2 10:33:57 EST 2017

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

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20170202/7feecaba/attachment-0001.html>