*SPAM* (LOW) Re: [Serusers] SER Billing System !!!

[Felipe Martins]

Hi Iqbal,

	What VoIP Billing System, working with SER and MySQL do you recommend, even if it is paid ?



On Tue, 26 Apr 2005 16:06:26 +0100
Iqbal <iqbal at gigo.co.uk> wrote:

> 
> Hi
> 
> If all you wish to do is to generate bills AFTER the call has completed,
> thats easily done, in your acc table you will have the start - stop
> records ( i.e INVITE, BYE) for each call. You then need to work out the
> length of the call , and then multiple it by the cost.
> 
> Now heres where it gets complicated, lets say you have different call
> costs for each prefix, i.e country code, and on top of that you have
> peak/off-peak times for each call, and then just to add little bit more,
> u decide that customers of Type I (i.e residential) get charged less
> than those of TYPE II (corporates). This is all best done via a DB
> 
> Assuming you dont have TYPE I/II customers all you need to do, is to
> assign a call cost to each segment of the day, and to each prefix, then
> get the time of the call, see what segment it falls into (or spans) and
> then do the maths for the call cost. I know this is a little
> oversimplified, but you can build on it slowly, I would start with
> assigning a cost to each country code..then each prefix within a
> country, and go from there
> 
> Iqbal
> 
> On 4/26/2005, "Felipe Martins" <fmartins at mundivox.com> wrote:
> 
> >Hi Ezequiel
> >
> >	Thanks for the response, and sorry for my mis explained e-mail. I have 2 SER Servers Using Mysql authentication. I want to log all CDR data (which I don't log nowadays) at my Mysql Bank in order to generate a billing to my clients . All I could find at internet is billing associated with ASTERISK, and I don't need to use asterisk for my clients. I'm implementing SEMS instead for some services like voicemail and so on, só I want to get the billing information (CDR) directelly from SER. Is that possible ? Is there a module that logs it ? Is there a manual which could tell me exactly what I must log to generate billing ?
> >
> >
> >Thanks in Advance
> >Best Regards
> >
> >
> >On Tue, 26 Apr 2005 11:39:44 -0300
> >"Consulta" <consulta at ksldg.com.ar> wrote:
> >
> >> Hi Felipe, how are you ?
> >> 
> >> Can you explain more what you want ?
> >> Maybe i can help you with billing modules for your SER, but i dont understand
> >> exactly what you need.
> >> 
> >> Regards
> >> Ezequiel
> >> 
> >> ----- Original Message -----
> >> From: "Felipe Martins" <fmartins at mundivox.com>
> >> To: <serusers at lists.iptel.org>
> >> Sent: Tuesday, April 26, 2005 11:03 AM
> >> Subject: [Serusers] SER Billing System !!!
> >> 
> >> 
> >> | Hi Everybody,
> >> |
> >> | Do anybody recommend a billing system that works with SER, I mean only with
> >> SER ? I have a SER server only at the company (no asterisk) and I 'd like to
> >> make it work with SER only.
> >> |
> >> |
> >> | --
> >> | Felipe Martins
> >> | Mundivox Communications
> >> | Tecnologia e Projetos
> >> | fmartins at mundivox.com
> >> |
> >> | Tel.: +55 +21 +3820 8839
> >> | Cel.: +55 +21 +9823 8602
> >> | Fax.: +55 +21 +3820 8844
> >> | www.mundivox.com
> >> |
> >> |
> >> | _______________________________________________
> >> | Serusers mailing list
> >> | serusers at lists.iptel.org
> >> | http://lists.iptel.org/mailman/listinfo/serusers
> >> |
> >> 
> >> 
> >
> >
> >-- 
> >Felipe Martins
> >Mundivox Communications
> >Tecnologia e Projetos
> >fmartins at mundivox.com
> >
> >Tel.: +55 +21 +3820 8839
> >Cel.: +55 +21 +9823 8602
> >Fax.: +55 +21 +3820 8844
> >www.mundivox.com
> >
> >
> >_______________________________________________
> >Serusers mailing list
> >serusers at lists.iptel.org
> >http://lists.iptel.org/mailman/listinfo/serusers
> >
> >
> 


-- 
Felipe Martins
Mundivox Communications
Tecnologia e Projetos
fmartins at mundivox.com

Tel.: +55 +21 +3820 8839
Cel.: +55 +21 +9823 8602
Fax.: +55 +21 +3820 8844
www.mundivox.com