Recent Changes - Search:

Resources


IP PBX Systems


Telephony Switch


Phones


Access Gateway
Signaling Converter


Lawful Interception Recorder


Others


Discontinued Products


Main Domains


In Social Media


About Us
Contact Details





.

XTools_Database_Structure

Introduction

XTools (Version 3.00 or later) uses Mysql database.

XTools store data in MySql database located in xtmsdb folder. The folder is created automatically where XTools run. In order to access CMDR records within mysql database, MySql and Apache services should be active. An opensource server like Wampserver may used for the purpose. You may download Wampserver free.

Mysql Database Fields

The fields of the Cdata table are briefly mentioned below:

sqnosequence number
typetype of record. Letter A for CMDR records
tdatedate and time of the record generated within the Telesis system.
durationduration of the call in seconds
cportport access code (address), which is to be billed
pportport access code of the port that carried the call if different than cport
uportport access code of the outgoing (or terminating) port
rdatadigits received from the originating port
xdatareplaced digits after routing analysis
rpulstotal number of charge pulses received by uport (real charge pulses)
ppulstotal number of locally generated charge pulses by call control (pseudo charge pulses)
crefacall reference of a party
crefbcall reference of b party
crefcreserved for future use
flags (8 bits)services used for the call. Available deflection types are (in hexadecimal):
 01Hex PIDynm: Last number redial
 02Hex PIUser: Dial from user pool
 03Hex PISkey: Dial by special key
 04Hex PIShot: System controlled hot line
 05Hex PIUhot: User controlled hot line
 06Hex PIIcmp: Redial in incomplete
 07Hex PIBusy: Redial destination busy
 08Hex PIAret: Alerting timeout
 20Hex No information
 21Hex Ucdefl: User controlled call forwarding (BRI ISDN)
 22Hex UcdivU: User controlled unconditional call forwarding
 23Hex UcdivB: User controlled call forwarding busy
 24Hex UcdivN: User controlled call forwarding no reply
 25Hex ScdivU: System controlled unconditional call forwarding
 26Hex ScdivB: System controlled call forwarding busy
 27Hex ScdivN: System controlled call forwarding no reply
 40Hex UcxfrA: Call tranfer after answer
 41Hex Calbck: Call back
 42Hex UcdivR: User controlled divert routed call
 43Hex UcxfrB: Call transfer while the destination is busy
 44Hex UcxfrN: Call transfer while the destination is ringing
 45Hex AltRtg: Alternative routing
flags (5 bits)incoming channel id for CCS signalling ports
flags (5 bits)outgoing channel id for CCS signalling ports
flag (1 bit)reserved for future use
flag (1 bit)if set, originating port is tie-line
flag (1 bit)if set, terminating port is tie-line
flags (4 bits)stars count of the call (0-15 stars can be reported)
flagtreserved for future use
flagureserved for future use
ipadrIP address of the Telesis system, which sent the record
Xidreserved for future use

for versions prior to 3.00

XTools (versions prior to 3.00) uses Microsoft Access database. When the XTools Utility collects call and other records from a Telesis system, the collected data is stored in the xtools.mdb file automatically. Xtools.mdb is a database file supported by Microsoft Access. It has call and information records. Maximum xtools.mdb file size is limited to 1GB. If xtools.mdb approaches to the limit; XTools should be stopped, xtools.mdb should be archived (with copying to another directory, renaming etc.) and a new mdb should be created with re-running XTools.

This document explains the database structure of the xtools.mdb file for software developers aiming to write their own CMDR reporting program instead of using the already available freeware Telesis utilities.

Database Fields in XTools.mdb File

The fields of the Cdata table within the xtools.mdb file are briefly mentioned below:

sqnosequence number
typetype of record. Letter A for CMDR records
tdatedate and time of the record generated within the Telesis system.
durationduration of the call in seconds
cportport access code (address), which is to be billed
pportport access code of the port that carried the call if different than cport
uportport access code of the outgoing (or terminating) port
rdatadigits received from the originating port
xdatareplaced digits after routing analysis
rpulstotal number of charge pulses received by uport (real charge pulses)
ppulstotal number of locally generated charge pulses by call control (pseudo charge pulses)
crefacall reference of a party
crefbcall reference of b party
crefcreserved for future use
flags (8 bits)services used for the call. Available deflection types are (in hexadecimal):
 01Hex PIDynm: Last number redial
 02Hex PIUser: Dial from user pool
 03Hex PISkey: Dial by special key
 04Hex PIShot: System controlled hot line
 05Hex PIUhot: User controlled hot line
 06Hex PIIcmp: Redial in incomplete
 07Hex PIBusy: Redial destination busy
 08Hex PIAret: Alerting timeout
 20Hex No information
 21Hex Ucdefl: User controlled call forwarding (BRI ISDN)
 22Hex UcdivU: User controlled unconditional call forwarding
 23Hex UcdivB: User controlled call forwarding busy
 24Hex UcdivN: User controlled call forwarding no reply
 25Hex ScdivU: System controlled unconditional call forwarding
 26Hex ScdivB: System controlled call forwarding busy
 27Hex ScdivN: System controlled call forwarding no reply
 40Hex UcxfrA: Call tranfer after answer
 41Hex Calbck: Call back
 42Hex UcdivR: User controlled divert routed call
 43Hex UcxfrB: Call transfer while the destination is busy
 44Hex UcxfrN: Call transfer while the destination is ringing
 45Hex AltRtg: Alternative routing
flags (5 bits)incoming channel id for CCS signalling ports
flags (5 bits)outgoing channel id for CCS signalling ports
flag (1 bit)reserved for future use
flag (1 bit)if set, originating port is tie-line
flag (1 bit)if set, terminating port is tie-line
flags (4 bits)stars count of the call (0-15 stars can be reported)
flagtreserved for future use
flagureserved for future use
ipadrIP address of the Telesis system, which sent the record
Xidreserved for future use
Print - Recent Changes - Search
Page last modified on October 17, 2016, at 06:29 AM EST
Subject to change without any notice. All rights reserved 2010 - Telesis A.S.
Iskitler Cad. No.68 Ankara, TURKEY. Tel: +90 312 3840540 Fax: +90 312 3840549 http://www.telesis-pbx.com