import public IP in voipswitch CDRs, RT#26228
authorIvan Kohler <ivan@freeside.biz>
Sun, 16 Feb 2014 01:30:39 +0000 (17:30 -0800)
committerIvan Kohler <ivan@freeside.biz>
Sun, 16 Feb 2014 01:30:39 +0000 (17:30 -0800)
bin/cdr-voipswitch.import

index 817c4bc..a8ab9d9 100644 (file)
@@ -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}),