summaryrefslogtreecommitdiff
path: root/bin/cdr-ivr.import
blob: 9285b3b3bc5ef9f606bf2fed89c3532a68860f06 (plain)
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
#!/usr/bin/perl

use strict;
use Date::Parse 'str2time';
use FS::cdr::Import;

FS::cdr::Import->dbi_import(
  'dbd'          => 'Sybase',
  'database'     => 'TEL_DATA',
  'table'        => 'BILLING',
  'primary_key'  => 'BILLING_ID',
  'status_table' => 'FREESIDE_BILLING',
  'column_map'   => { #freeside => IVR
    'cdrid'             => 'BILLING_ID', #Primary key
    #'' => 'CALL_SESSION_ID', # Call Session Id (unique per call session – GUID)
    'uniqueid'          => 'CALL_ID', #
    #'' => 'ENTRY_TYPE', #
    'accountcode'       => 'ACCOUNT_ID', #
    #'' => 'ACCOUNT', #
    #'' => 'ACCOUNT_GROUP', #
    'startdate'         => sub { str2time(shift->{'START_DATE_TIME'}); },
    'answerdate'        => sub { str2time(shift->{'CONNECT_DATE_TIME'}); },
    'enddate'           => sub { str2time(shift->{'DISCONNECT_DATE_TIME'}); },
    #'' => 'PARENT_ACCOUNT_ID', #
    #'' => 'PARENT_ACCOUNT', #
    #'' => 'LOGIN_NAME', #
    #varchars not ints 'upstream_rateid' => 'RATE_SCHEDULE', #
    #varchars not ints 'upstream_rateplanid' => 'RATE_PLAN', #
    'channel' => 'NODE', #
    #'' => 'NODE_TYPE', #
    #'' => 'ORIGIN', #
    #'dst'               => sub { $_[0]->{COUNTRY_CODE}. $_[0]->{NPA}.
    #                             $_[0]->{NXX}. $_[0]->{LOCAL_NUMBER};
    #                           },
    'description'       => 'DESCRIPTION', # or upstream_dst_regionname ?
    #'' => 'PER_CALL_CHARGE', #
    #'' => 'PER_MINUTE_CHARGE', #
    #'' => 'PER_CALL_SURCHARGE', #
    #'' => 'PER_MINUTE_SURCHARGE', #
    'duration'          => 'ACTUAL_DURATION', #
    'billsec'           => sub { int( shift->{'QUANTITY'} * 60 + .49 ); }, #
    'upstream_price'    => 'AMOUNT', #
    #'' => 'PACKAGED_BALANCE_INDEX', #
    'upstream_currency' => 'CURRENCY', #
    #'' => 'CONVERSION_RATE', #
    'lastapp'           => 'MODULE_NAME', #
    'src'               => 'ANI', # 'clid' => 'ANI', #
    'dst'               => sub { $_[0]->{'COUNTRY_CODE'} !~ /^1/
                                   ? "011". $_[0]->{'DETAIL'}
                                   : $_[0]->{'DETAIL'};
                               },
    #'' => 'SALES_GROUP', #
    #'' => 'TAX_GROUP', #
    'userfield'         => 'USER_1', #
    #'' => 'USER_2', #
    #'' => 'USER_3', #
    #'' => 'USER_4', #
    #'' => 'USER_5', #
    #'' => 'USER_6', #
    #'' => 'USER_7', #
    #'' => 'USER_8', #
    #'' => 'USER_9', #
    #'' => 'USER_10', #
    #'' => 'INFO_DIGITS', # VARCHAR(3) Info digits from the inbound leg, if applicable
    #'' => 'RATE_INTERVAL', # TINYINT Rate interval used to bill the call (default: 60 seconds) ... create a new "upstream_granularity" field if we need this
    #'' => 'DISCONNECT_CHARGE', # DECIMAL(15,4) The disconnect charge billed for the call
    #'' => 'BILLING_DELAY', # SMALLINT Billing delay associated with the call
    #'' => 'GRACE_PERIOD', # SMALLINT Grace period associated with the call
    #'' => 'ACCOUNT_TYPE', # Account type from ACCOUNT_TYPES table
  },
);

1;