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:
| sqno | sequence number |
| type | type of record. Letter A for CMDR records |
| tdate | date and time of the record generated within the Telesis system. |
| duration | duration of the call in seconds |
| cport | port access code (address), which is to be billed |
| pport | port access code of the port that carried the call if different than cport |
| uport | port access code of the outgoing (or terminating) port |
| rdata | digits received from the originating port |
| xdata | replaced digits after routing analysis |
| rpuls | total number of charge pulses received by uport (real charge pulses) |
| ppuls | total number of locally generated charge pulses by call control (pseudo charge pulses) |
| crefa | call reference of a party |
| crefb | call reference of b party |
| crefc | reserved 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) |
| flagt | reserved for future use |
| flagu | reserved for future use |
| ipadr | IP address of the Telesis system, which sent the record |
| Xid | reserved 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:
| sqno | sequence number |
| type | type of record. Letter A for CMDR records |
| tdate | date and time of the record generated within the Telesis system. |
| duration | duration of the call in seconds |
| cport | port access code (address), which is to be billed |
| pport | port access code of the port that carried the call if different than cport |
| uport | port access code of the outgoing (or terminating) port |
| rdata | digits received from the originating port |
| xdata | replaced digits after routing analysis |
| rpuls | total number of charge pulses received by uport (real charge pulses) |
| ppuls | total number of locally generated charge pulses by call control (pseudo charge pulses) |
| crefa | call reference of a party |
| crefb | call reference of b party |
| crefc | reserved 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) |
| flagt | reserved for future use |
| flagu | reserved for future use |
| ipadr | IP address of the Telesis system, which sent the record |
| Xid | reserved for future use |
