Convert CDR talk time

[aislecom]

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/ ... terns.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.

[taitan]

Use this at Excel

Code: Select all

 =(HOUR(D1)*60+MINUTE(D1))*60+SECOND(D1) 

if D1 is 00:01:01, the above formula shows 61.

[taitan]

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.

[chentron]

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

Use this at Excel

Code: Select all

 =(HOUR(D1)*60+MINUTE(D1))*60+SECOND(D1) 

if D1 is 00:01:01, the above formula shows 61.

[Tata]

Put the following line in the [Configuration]->[Advanced] page.

--------------------------------------
file.log.session.date.str = true
--------------------------------------

And restart the server.