NC-AD300E Manual
- 49 -
Voice over UDP format is only an effective way.
If voice over TCP ,The format as fllows:
"\rCaaaa1,aaaa2,sssss,nnnnn,bbbb,cccc\n"
Beginning at”\r”. as the identity Character “C”
aaaa means : line number
ssss means :end_calling time
nnnn means: talk_duration
bbbb means:caller
cccc means:called number
the end : a carriage return “\n”
when we using “wcdrrx”,the format of CDR as fllows:
6.1 txt format
CDR field as fllows:
C
CC
Caller,called
aller,called
aller,called
aller,called number,starttime,endtime,talk_duration,in_channel,out_channel.
number,starttime,endtime,talk_duration,in_channel,out_channel.
number,starttime,endtime,talk_duration,in_channel,out_channel.
number,starttime,endtime,talk_duration,in_channel,out_channel.
The format of time :
year-month-day,hour:miniute:second.the
year-month-day,hour:miniute:second.the
year-month-day,hour:miniute:second.the
year-month-day,hour:miniute:second.the format
format
format
format of
of
of
of channel:PCMID.slot
channel:PCMID.slot
channel:PCMID.slot
channel:PCMID.slot
6.2 Database format
Table name:cdr
Field Definitions:
Id
type
:
int(10) unsigned
,
Not null, automatically increase,the primary Key
deviceid
` type
:
smallint
,
Not null, default:0
in_channel
`type
:
int(11)
,
Not null,default : 0
out_channel
`type
:
int(11)
,
Not null, default :0
incomingtime
`type
:
datetime
,
Not null ,default
:
'0000-00-00 00:00:00'
duration
`type
:
int(10) unsigned
,
Not null
,
default
:
0
caller
`type
:
varchar(30)
,
Not null
,
default:''
called
`type
:
varchar(30)
,
Not null
,
default:''
fail
`type
:
tinyint(4)
,
Not null
,
default :0
field means as follows:
ID
,
deviceID
,
in_channel,out_channel,incomingtime,talk_duration
,
caller
,
called
,
fail