From 08c277b9867608b9ba8ddc8ae8c67d1ca8bb3ff5 Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Sat, 15 Feb 2014 17:30:39 -0800 Subject: [PATCH] import public IP in voipswitch CDRs, RT#26228 --- bin/cdr-voipswitch.import | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/bin/cdr-voipswitch.import b/bin/cdr-voipswitch.import index 817c4bc73..a8ab9d944 100644 --- a/bin/cdr-voipswitch.import +++ b/bin/cdr-voipswitch.import @@ -121,11 +121,17 @@ my $imported = 0; my $row; while ( $row = $sth->fetchrow_hashref ) { + my $ip = $row->{ip_number}; + if ( $ip =~ /^([\d\.]+)\/([\d\.]*)$/ ) { + $ip = $1; + #$nat_ip = $2; + } + my $cdr = FS::cdr->new({ cdrid => $row->{id_call}, charged_party => sprintf('%.2d', $row->{client_type}). $row->{id_client}, - src_ip_addr => $row->{ip_number}, + src_ip_addr => $ip, src => $row->{caller_id}, dst => $row->{called_number}, startdate => str2time($row->{call_start}), -- 2.11.0