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@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@mundivox.com To: serusers@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@mundivox.com | | Tel.: +55 +21 +3820 8839 | Cel.: +55 +21 +9823 8602 | Fax.: +55 +21 +3820 8844 | www.mundivox.com | | | _______________________________________________ | Serusers mailing list | serusers@lists.iptel.org | http://lists.iptel.org/mailman/listinfo/serusers |
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@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@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@mundivox.com To: serusers@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@mundivox.com | | Tel.: +55 +21 +3820 8839 | Cel.: +55 +21 +9823 8602 | Fax.: +55 +21 +3820 8844 | www.mundivox.com | | | _______________________________________________ | Serusers mailing list | serusers@lists.iptel.org | http://lists.iptel.org/mailman/listinfo/serusers |
-- Felipe Martins Mundivox Communications Tecnologia e Projetos fmartins@mundivox.com
Tel.: +55 +21 +3820 8839 Cel.: +55 +21 +9823 8602 Fax.: +55 +21 +3820 8844 www.mundivox.com
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
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@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@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@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@mundivox.com To: serusers@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@mundivox.com | | Tel.: +55 +21 +3820 8839 | Cel.: +55 +21 +9823 8602 | Fax.: +55 +21 +3820 8844 | www.mundivox.com | | | _______________________________________________ | Serusers mailing list | serusers@lists.iptel.org | http://lists.iptel.org/mailman/listinfo/serusers |
-- Felipe Martins Mundivox Communications Tecnologia e Projetos fmartins@mundivox.com
Tel.: +55 +21 +3820 8839 Cel.: +55 +21 +9823 8602 Fax.: +55 +21 +3820 8844 www.mundivox.com
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-
Felipe Martins -
Iqbal