Author |
Message |
aislecom Brekeke Member
Joined: 24 Mar 2010 Posts: 10
Location: FL
|
Posted: Sat May 29, 2010 9:12 am Post subject: Convert CDR talk time |
|
|
1. Brekeke Product Name and version:2.4.4.8 Advanced
2. Java version: ver 6 update 18
3. OS type and the version: Windows 2003 server
4. UA (phone), gateway or other hardware/software involved: asterisk, mvts
5. Select your network pattern from http://www.brekeke-sip.com/bbs/network/networkpatterns.html : 9
6. Your problem:
I am uisng brekeke for whole sale sip traffic. Is there a means to store CDRs with talk time in second. Any one has an excel formula to convert to seconds. The style used not is very carrier friendly. |
|
Back to top |
|
taitan Brekeke Master Guru
Joined: 15 Mar 2008 Posts: 237
|
Posted: Tue Jun 01, 2010 1:28 pm Post subject: |
|
|
Use this at Excel
Code: |
=(HOUR(D1)*60+MINUTE(D1))*60+SECOND(D1) |
if D1 is 00:01:01, the above formula shows 61. |
|
Back to top |
|
taitan Brekeke Master Guru
Joined: 15 Mar 2008 Posts: 237
|
Posted: Tue Jun 01, 2010 1:36 pm Post subject: |
|
|
also... if you are providing a carrier service, I don't recommend that you use the default CDR information because it is a text based file..
You may need to use an advanced version because it has the radius client function which can provide a billing feature. |
|
Back to top |
|
chentron Brekeke Addict
Joined: 15 Oct 2013 Posts: 26
|
Posted: Sun Dec 15, 2013 11:01 am Post subject: |
|
|
this is a old post, but i have the same purpose.
I want to get the seconds of the call.
I can see at Call Logs. If I Select Output Format CSV, when i open the result csv file with excel (or notepad), the column with seconds is not the expected. I get a number (but not talk seconds).
So the question remain the same as original:
How I get the seconds in CDR.
Thanks
taitan wrote: |
Use this at Excel
Code: |
=(HOUR(D1)*60+MINUTE(D1))*60+SECOND(D1) |
if D1 is 00:01:01, the above formula shows 61. |
|
|
Back to top |
|
Tata Brekeke Master Guru
Joined: 27 Jan 2008 Posts: 223
|
Posted: Wed Dec 18, 2013 2:10 am Post subject: |
|
|
Put the following line in the [Configuration]->[Advanced] page.
--------------------------------------
file.log.session.date.str = true
--------------------------------------
And restart the server. |
|
Back to top |
|
|