Bulk CDR Upload

Upload Template

"select2 small")); ?>

Gateway

"select2")); ?>

'Select Authentication Rule')+GatewayConfig::$NameFormat;?> Authentication Rule

"select2 small")); ?>

Upload (.xls, .xlxs, .csv)

Settings

Rate CDR

Verify this file

Ignore zero rated calls

Note

Allowed Extension .xls, .xlxs, .csv

Please upload the file in given Detail File Format

Sample File Detail File Download

*/ ?>

Add New Template

Template Name:

Call Rate Rules CSV Importer

Delimiter:

Enclosure:

Escape:

First row:

'Column Name','data'=>'Data'),'',array("class"=>"select2 small")); ?>

Field Remapping

Connect DateTime

"select2 small")); ?>

Disconnect DateTime

"select2 small")); ?>

Billed Duration

"select2 small")); ?>

Duration

"select2 small")); ?>

CLI

"select2 small")); ?>

CLD

"select2 small")); ?>

CLI Translation Rule

CLD Translation Rule

Account*

"select2 small")); ?>

Cost

"select2 small")); ?>

Date Format

"select2 small")); ?>

Inbound/Outbound

"select2 small")); ?>

Service

"select2")); ?>

Trunk

"select2")); ?>

Inbound Rate Table

"select2")); ?>

Outbound Rate Table

"select2")); ?>

Extension

"select2 small")); ?>

Charge Code

"select2 small")); ?>

ExtensionName

"select2 small")); ?>

Extension Description

"select2 small")); ?>

Pincode

"select2 small")); ?>

Pincode Name

"select2 small")); ?>

Remote IP

"select2 small")); ?>

Callee IP

"select2 small")); ?>

Disposition

"select2 small")); ?>

Area Prefix

"select2 small")); ?>

Userfield

"select2 small")); ?>

CSV File to be loaded

Account id	CLI	CLD	Billing Prefix	Connect Time	Disconnect Time	Duration, sec	Billed Duration, sec	Cost
BRIGHT TELECOM-563	2035000755	2222441638507980	2222441	25/03/2015 11:01:32 AM	25/03/2015 11:01:58 AM	26	60	0.00399
BRIGHT TELECOM-563	1636858774	2222441780755810	2222442	23/03/2015 05:31:26 PM	23/03/2015 05:33:25 PM	119	120	0.00798
BRIGHT TELECOM-563	1636858774	2222443301348680	2222443	23/03/2015 11:21:35 AM	23/03/2015 11:22:44 AM	69	120	0.02048

CDR Upload

CDR Detail File Format