4 use Date::Parse 'str2time';
7 FS::cdr::Import->dbi_import(
9 'database' => 'TEL_DATA',
11 'primary_key' => 'BILLING_ID',
12 'column_map' => { #freeside => IVR
13 'cdrid' => 'BILLING_ID', #Primary key
14 #'' => 'CALL_SESSION_ID', # Call Session Id (unique per call session – GUID)
15 'uniqueid' => 'CALL_ID', #
16 #'' => 'ENTRY_TYPE', #
17 'accountcode' => 'ACCOUNT_ID', #
19 #'' => 'ACCOUNT_GROUP', #
20 'startdate' => sub { str2time(shift->{'START_DATE_TIME'}); },
21 'answerdate' => sub { str2time(shift->{'CONNECT_DATE_TIME'}); },
22 'enddate' => sub { str2time(shift->{'DISCONNECT_DATE_TIME'}); },
23 #'' => 'PARENT_ACCOUNT_ID', #
24 #'' => 'PARENT_ACCOUNT', #
25 #'' => 'LOGIN_NAME', #
26 #varchars not ints 'upstream_rateid' => 'RATE_SCHEDULE', #
27 #varchars not ints 'upstream_rateplanid' => 'RATE_PLAN', #
28 'channel' => 'NODE', #
31 #'dst' => sub { $_[0]->{COUNTRY_CODE}. $_[0]->{NPA}.
32 # $_[0]->{NXX}. $_[0]->{LOCAL_NUMBER};
34 'description' => 'DESCRIPTION', # or upstream_dst_regionname ?
36 #'' => 'PER_CALL_CHARGE', #
37 #'' => 'PER_MINUTE_CHARGE', #
38 #'' => 'PER_CALL_SURCHARGE', #
39 #'' => 'PER_MINUTE_SURCHARGE', #
40 'duration' => 'ACTUAL_DURATION', #
41 'billsec' => sub { int( shift->{'QUANTITY'} * 60 + .49 ); }, #
42 'upstream_price' => 'AMOUNT', #
43 #'' => 'PACKAGED_BALANCE_INDEX', #
44 'upstream_currency' => 'CURRENCY', #
45 #'' => 'CONVERSION_RATE', #
46 'lastapp' => 'MODULE_NAME', #
47 'src' => 'ANI', # 'clid' => 'ANI', #
49 #'' => 'SALES_GROUP', #
51 'userfield' => 'USER_1', #
61 #'' => 'INFO_DIGITS', # VARCHAR(3) Info digits from the inbound leg, if applicable
62 #'' => 'RATE_INTERVAL', # TINYINT Rate interval used to bill the call (default: 60 seconds) ... create a new "upstream_granularity" field if we need this
63 #'' => 'DISCONNECT_CHARGE', # DECIMAL(15,4) The disconnect charge billed for the call
64 #'' => 'BILLING_DELAY', # SMALLINT Billing delay associated with the call
65 #'' => 'GRACE_PERIOD', # SMALLINT Grace period associated with the call
66 #'' => 'ACCOUNT_TYPE', # Account type from ACCOUNT_TYPES table