'header' => 1,
'import_fields' => [
- skip(2), #id
- #billing period
+ skip(1) , #id
+ skip(1) , #billing period
'accountcode', #account number
skip(2), #username
#service id
- sub { my ($cdr, $calldate) = @_;
+ sub { my ($cdr, $calldate, $param) = @_;
+
$cdr->set('calldate', $calldate);
- $calldate =~ /^(\d{4})-(\d{2})-(\d{2})\s*(\d{2}):(\d{2}):(\d{2})$/
- or die "unparseable date: $calldate";
- my $tmp_date = "$2/$1/$3 $4:$5:$6";
+ if ($calldate =~ /^(\d{4})-(\d{2})-(\d{2})\s*(\d{2}):(\d{2}):(\d{2})$/){
+
+ my $tmp_date = "$2/$3/$1 $4:$5:$6";
$tmp_date = str2time($tmp_date);
$cdr->set('startdate', $tmp_date);
+
+ } else {
+
+ $param->{skiprow} = 1
+ }
}, #date
skip(1), #tariff region
'src', #originating number