From: Ivan Kohler <ivan@freeside.biz>
Date: Sun, 16 Feb 2014 01:30:39 +0000 (-0800)
Subject: import public IP in voipswitch CDRs, RT#26228
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=08c277b9867608b9ba8ddc8ae8c67d1ca8bb3ff5

import public IP in voipswitch CDRs, RT#26228
---

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}),