1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
|
package FS::cdr::cdr_template;
use strict;
use base qw( FS::cdr );
use vars qw( %info );
use FS::cdr qw( _cdr_date_parser_maker _cdr_min_parser_maker );
%info = (
'name' => 'Example CDR format',
'weight' => 500,
'header' => 0, #0 default, set to 1 to ignore the first line, or
# to higher numbers to ignore that number of lines
'type' => 'csv', #csv (default), fixedlength or xls
'sep_char' => ',', #for csv, defaults to ,
'disabled' => 0, #0 default, set to 1 to disable
#listref of what to do with each field from the CDR, in order
'import_fields' => [
#place data directly in the specified field
'freeside_cdr_fieldname',
#subroutine reference
sub { my($cdr, $field_data) = @_;
#do something to $field_data
$cdr->fieldname($field_data);
},
#premade subref factory for date+time parsing, understands dates like:
# 10/31/2007 08:57:24
# 2007-10-31 08:57:24.113000000
# Mon Dec 15 11:38:34 2003
_cdr_date_parser_maker('startddate'), #for example
#premade subref factory for decimal minute parsing
_cdr_min_parser_maker, #defaults to billsec and duration
_cdr_min_parser_maker('fieldname'), #one field
_cdr_min_parser_maker(['billsec', 'duration']), #listref for multiple fields
],
#Parse::FixedLength field descriptions & lengths, for type=>'fixedlength' only
'fixedlength_format' => [qw(
Type:2:1:2
Sequence:4:3:6
)],
);
1;
__END__
list of freeside CDR fields, useful ones marked with *
acctid - primary key
*[1] calldate - Call timestamp (SQL timestamp)
clid - Caller*ID with text
* src - Caller*ID number / Source number
* dst - Destination extension
dcontext - Destination context
channel - Channel used
dstchannel - Destination channel if appropriate
lastapp - Last application if appropriate
lastdata - Last application data
* startdate - Start of call (UNIX-style integer timestamp)
* answerdate - Answer time of call (UNIX-style integer timestamp)
* enddate - End time of call (UNIX-style integer timestamp)
*[2] duration - Total time in system, in seconds
*[3] billsec - Total time call is up, in seconds
*[4] disposition - What happened to the call: ANSWERED, NO ANSWER, BUSY
amaflags - What flags to use: BILL, IGNORE etc, specified on a per
channel basis like accountcode.
*[5] accountcode - CDR account number to use: account
uniqueid - Unique channel identifier
userfield - CDR user-defined field
cdr_type - CDR type - see FS::cdr_type (Usage = 1, S&E = 7, OC&C = 8)
*[6] charged_party - Service number to be billed
upstream_currency - Wholesale currency from upstream
*[7] upstream_price - Wholesale price from upstream
upstream_rateplanid - Upstream rate plan ID
rated_price - Rated (or re-rated) price
distance - km (need units field?)
islocal - Local - 1, Non Local = 0
*[8] calltypenum - Type of call - see FS::cdr_calltype
description - Description (cdr_type 7&8 only) (used for
cust_bill_pkg.itemdesc)
quantity - Number of items (cdr_type 7&8 only)
*[9] carrierid - Upstream Carrier ID (see FS::cdr_carrier)
upstream_rateid - Upstream Rate ID
svcnum - Link to customer service (see FS::cust_svc)
freesidestatus - NULL, done (or something)
[1] Auto-populated from startdate if not present
[2] Auto-populated to enddate - startdate on insert if not specified
[3] Auto-populated to enddate - answerdate on insert if not specified
[4] Package options available to ignore calls without a specific disposition
[5] When using 'cdr-charged_party-accountcode' config
[6] Auto-populated from src (normal calls) or dst (toll free calls) if not present
[7] When using 'upstream_simple' rating method.
[8] Set to usage class classnum when using pre-rated CDRs and usage class-based
taxation (local/intrastate/interstate/international)
[9] If doing settlement charging
|
