CDR File Module - Revision history

Dana: /* List of available variables that could be used to construct a CDR record */

2014-01-11T13:14:51Z

‎List of available variables that could be used to construct a CDR record

2014-01-11T12:53:41Z

‎List of available variables that could be used to construct a CDR record

2014-01-11T12:47:48Z

2014-01-11T12:38:44Z

‎Section [general]

2014-01-11T12:33:08Z

2014-01-11T07:29:12Z

‎Section [general]

2014-01-11T07:21:37Z

‎Converting call time

2014-01-11T07:21:03Z

‎Converting call time

2014-01-10T17:22:34Z

‎Write CDR to file

2014-01-10T16:25:07Z

‎Set CDR billing

@@ Line 51: / Line 51: @@
 * ${callername} - caller id
 * ${billtime} - billable call duration, starts from the point when the remote party actually answers the call
-* ${ringtime} - the time for ringing
+* ${ringtime} - amount of time the call was in ring state, from first ring to answer or hangup
 * ${duration} - total time of the call
 * ${direction} - has a value of outgoing or incoming

@@ Line 39: / Line 39: @@
 ===List of available variables that could be used to construct a CDR record===
-  '''Note''': in order for a parameter to be available in the CDR, it has to be enabled in [[CDR Build Module#Configuration|cdrbuild.conf]].
+  '''Note''': in order for a parameter to be available in the CDR, it has to be enabled in [[CDR Build Module#Adding_custom_parameters|cdrbuild.conf]].
 The "cdrwrite" parameter is special, a boolean value of false will prevent the CDR from being written. This is to avoid generating CDR records for utility channels while still being able to track them.
@@ Line 61: / Line 61: @@
 * ${out_leg.ringtime} - ring time of the outgoing call leg
 * ${out_leg.duration} - total time of the outgoing call leg
 * ${out_leg.reason} - reason for outgoing call leg disconnection
 ===Usage example===

@@ Line 51: / Line 51: @@
 * ${callername} - caller id
 * ${billtime} - billable call duration, starts from the point when the remote party actually answers the call
-* ${ringtime} - total time of the call
+* ${ringtime} - the time for ringing
 * ${direction} - has a value of outgoing or incoming
 * ${status} - disposition of the call
 * ${reason} - reason for call disconnection
 ===Usage example===

@@ Line 23: / Line 23: @@
 : Each ${parameter} is replaced with the value of that parameter in the [[call.cdr]] message.
-Below are listed the format defaults for each mode combination:
+:Below are listed the format defaults for each mode combination:
 ::* tab-separated (.tsv), combined=false

@@ Line 4: / Line 4: @@
 Cdrfile is a module that receives a [[call.cdr]] message (maybe from [[CDR Build Module|cdrbuild]]).
-===Configuration===
+===The configuration file===
 The file used in configuration is cdrfile.conf.

@@ Line 35: / Line 35: @@
 ::* comma-separated (.csv), combined=true<br/>
-:::format=${time},"${billid}","${chan}","${address}","${caller}","${called}",${billtime},${ringtime},${duration},"${status}","${reason}","${out_leg.chan}",<br/>"${out_leg.address}",${out_leg.billtime},${out_leg.ringtime},${out_leg.duration},"${out_leg.reason}"
+:::'''format'''=${time},"${billid}","${chan}","${address}","${caller}","${called}",${billtime},${ringtime},${duration},"${status}","${reason}","${out_leg.chan}",<br/>"${out_leg.address}",${out_leg.billtime},${out_leg.ringtime},${out_leg.duration},"${out_leg.reason}"
 ===List of available variables that could be used to construct a CDR record===

@@ Line 104: / Line 104: @@
 If you need a human and machine readable representation of the time column you can use the following AWK script:
-  awk 'BEGIN{FS="\t";OFS="\t"} {$1=strftime("%Y%m%d%H%M%S",$1); print $0}' /var/log/yate-cdr.csv
+  awk 'BEGIN{FS=",";OFS=","} {$1=strftime("%Y%m%d%H%M%S",$1); print $0}' /var/log/yate-cdr.csv
 The above assumes comma-separated format, the ${time} parameter is in the first column (the $1 positional parameter) and the CDR file is in its usual place.

@@ Line 104: / Line 104: @@
 If you need a human and machine readable representation of the time column you can use the following AWK script:
-  awk 'BEGIN{FS="\t";OFS="\t"} {$1=strftime("%Y%m%d%H%M%S",$1); print $0}' /var/log/yate-cdr.tsv
+  awk 'BEGIN{FS="\t";OFS="\t"} {$1=strftime("%Y%m%d%H%M%S",$1); print $0}' /var/log/yate-cdr.csv
-The above assumes TAB separated format, the ${time} parameter is in the first column (the $1 positional parameter) and the CDR file is in its usual place.
+The above assumes comma-separated format, the ${time} parameter is in the first column (the $1 positional parameter) and the CDR file is in its usual place.
-Adapt the script as needed. You can make the date/time more readable by inserting separators in the time format.
+Adapt the script as needed. You can make the date/time more readable by inserting separators in the time format:
 '''See also'''

@@ Line 71: / Line 71: @@
 ====Write CDR to file====
 cdrfile.conf
@@ Line 77: / Line 79: @@
   file=/var/log/yate-cdr.csv
   format=${time},"${billid}","${chan}","${address}","${caller}","${called}",${billtime},${ringtime},${duration},"${direction}","${status}","${reason}"
 ===Converting call time===

@@ Line 55: / Line 55: @@
 * ${status} - disposition of the call
 * ${reason} - reason for call disconnection
 ==== Set CDR billing====
@@ Line 66: / Line 68: @@
   [general]
   resolution=sec
 ===Converting call time===