From 6d167446d719a361d84bf6be752ad24d718eaa35 Mon Sep 17 00:00:00 2001
From: mark <mark>
Date: Mon, 14 Feb 2011 23:01:10 +0000
Subject: [PATCH] VoipNow import adjustment, RT#11178

---
 bin/cdr-voipnow.import | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

diff --git a/bin/cdr-voipnow.import b/bin/cdr-voipnow.import
index eb36010af..c16b00d7c 100755
--- a/bin/cdr-voipnow.import
+++ b/bin/cdr-voipnow.import
@@ -45,7 +45,8 @@ print "Selecting CDRs from $start_id to ".($end_id || 'end')."...\n";
 my $table = $opt{T} || 'call_history';
 # spelled "disposion" in the table
 my @cols = ( qw( 
-  id extension_number flow channel partyid start answer duration disposion) );
+  id extension_number flow channel partyid start answer duration disposion did
+  client_client_id ) );
 my $sql = 'SELECT '.join(',', @cols). " FROM $table WHERE id >= $start_id";
 $sql .= " AND id <= $end_id" if $end_id;
 $sql .= " ORDER BY id";
@@ -80,6 +81,7 @@ while ( $row = $sth->fetchrow_hashref ) {
       startdate     => str2time($row->{start}),
       answerdate    => str2time($row->{answer}),
       cdrbatchnum   => $cdrbatchnum,
+      accountcode   => $row->{client_client_id},
     }
   );
   print $row->{id},"\n" if $opt{v};
@@ -88,7 +90,7 @@ while ( $row = $sth->fetchrow_hashref ) {
     $cdr->dst($row->{'partyid'});
   }
   elsif ( $row->{flow} eq 'in' ) {
-    $cdr->dst($row->{'extension_number'});
+    $cdr->dst($row->{'did'});
     $cdr->src($row->{'partyid'});
   }
   else {
-- 
2.11.0