Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 6:08 pm
Voice Broadcast System


All times are UTC




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Routing at a loss.
PostPosted: Sat Sep 10, 2011 9:09 am 
Offline

Joined: Wed Sep 07, 2011 9:05 pm
Posts: 9
I setup a test tariffplan that includes these rates:

PREFIX BR SR START-DATE STOP-DATE INITB CC TRUNK RATE CARD ACTION
170055511 0.12000 0.15000 2011-09-10 07:00:24 2021-09-10 07:00:24 1 0.00000 dummy1 1700 carrierXcu Edit this Rates Delete this Rates
17005551 0.20000 0.15000 2011-09-10 06:59:00 2021-09-10 06:59:00 1 0.00000 lax-db7 1700 carrierXcu Edit this Rates Delete this Rates
17005554 0.10000 0.10000 2011-09-10 06:54:05 2021-09-10 06:54:05 1 0.00000 dummy1 1700 carrierXcu Edit this Rates Delete this Rates
17005552 0.10000 0.30000 2011-09-10 06:54:05 2021-09-10 06:54:05 1 0.00000 dummy1 1700 carrierXcu Edit this Rates Delete this Rates
1700555 0.10000 0.15000 2011-09-10 06:54:05 2021-09-10 06:54:05 1 0.00000 dummy1 1700 carrierXcu Edit this Rates Delete this Rates


Much to my chagrin a2billing is perfectly happy to route calls to 17005551 even though its loosing 0.05/min doing it.

Did I miss a frob to turn off "burn money" ?

There is no failover in my setup. the customer (SIP BINDING) cannot use any other rate card, and 1700555* only exists in this one ratecard.


I am at a loss.

Ideas?


Top
 Profile  
 
 Post subject: Re: Routing at a loss.
PostPosted: Sun Sep 11, 2011 6:50 am 
Offline

Joined: Fri Jun 23, 2006 3:56 pm
Posts: 4065
Hi

I would suggest constructing your rate tables in such a way that don't make a loss.

Quote:
17005551 0.20000 0.15000


Joe


Top
 Profile  
 
 Post subject: Re: Routing at a loss.
PostPosted: Mon Sep 12, 2011 2:47 am 
Offline

Joined: Wed Sep 07, 2011 9:05 pm
Posts: 9
I was considering a rate table scrubber, but the problem then is WHAT to do with those negative-profit-prefixes. The obvious solution is to route them to a trunk that does not exist a sip host that doesnt exists sip.example.com for example.

NB these are new arbitrary numbers they don't have anything to do with the previous rates.

Consider :
on monday 1700555 is profitable i buy at 10 and sell at 20
17005551 is too I buy at 14 and sell at 15.

But on tuesday 17005551 is not as the carrier rate jumps to 16 -- now its a loss!

No big deal I delete 17005551 from the table. But 1700555 matches as the longest string. Therefore I must delete 1700555 from the table, but i still want to route calls to 17005550,17005552...17005559 so I have to create those entries.

It only gets worse if the carrier and the customer tables don't have identical sets of prefixes. More so as the rate tables grow. [ I solved this earlier the code is slow but manageable and both my ratetable.csv files were under 5MB ]

Futhermore this would break or at least induce nasty delays in the face of proper fail-over routing! (I'm working to implement that next as its high-time we have it!). I'm loathe to shoot my self in the foot on the grounds that I didn't want to go for a walk just yet. And I wasn't sure of any filter-cc_cardrate solution that isnt shooting us in the collective foot. I suppose forcing the customer to run osp might help, but a2b would need to support it too, and I'm not working on that right now.

I'll post a proposed fix to github within the week, but it involved moving a lot of searching and sorting from PHP to SQL and NON-LCR users will have to help with the regression testing if we want legacy non-LCR behaviours.


Top
 Profile  
 
 Post subject: Re: Routing at a loss.
PostPosted: Sat Sep 17, 2011 10:58 am 
Offline

Joined: Wed Sep 07, 2011 9:05 pm
Posts: 9
The problem of merging and dropping or otherwise filtering is compounded as rates fluctuate.

I propose that we allow each Call Plan to have a customer-rates 1 to 0 or 1 relationship with a Rate Card.

If a customer-rate RateCard is defined we pull the customer billing side from that row, otherwise (field is null) legacy behaviour is exhibited.


Thoughts?


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 
Hosted Voice Broadcast


All times are UTC


Who is online

Users browsing this forum: No registered users and 7 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group