Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Topics - Administrator

Pages: [1] 2 3
Cisco Call Manager Express (CME)/Unified Communication Manager Express/UC500 system should be configured to deliver CDR via a Syslog Server or FTP.  For additional information, download the installation and configuration guide for Cisco Call Manager Express below.

Collection via Syslog Server

You will require an additional utility, WinLINK Data Storage to assist in collection.  A trial of the collection utility can be found below.

Once installed, select the "Cisco Call Manager Express" from the Configure -> Data Source menu.  You may be asked to restart the utility.  Once you have restarted the utility, configure the Configuration -> Telnet or Socket Settings menu with the information below.

IP address: [Enter the IP address of the PC hosting the software]
Port: 514
Protocol: UDP
User Name and Password: [Both are left blank]

Once configured, select the Options -> File Path / Data Storage Mode.  Data Storage Mode should be set to "Save to File" and enter the Send to File path (i.e. c:\bill\cme1.raw).

Collection via FTP

If you have configured your Cisco CME to deliver call records via FTP, you may use either your own FTP server or a trial of WinLINK FTP can be downloaded below.

Configuring Call Accounting Mate with WinLINK for CME

Call Accounting Mate requires a special utility for processing the call record data, WinLINK for WCME.  Download a trial of the WCME utility from our web site below.

Unzip the WCME utility into a separate folder (i.e. c:\bill\WCME).  Launch the wcme.exe utility, enter a profile name (i.e. CME1), and click the Properties button to configure the profile.  Enter the full path & file name for both the source file (collected from your Call Manager Express - i.e. c:\bill\cme1.raw) and the destination file (the output file for WCME - i.e. c:\bill\smdr.raw).

Once WCME has been configured, return to the application and click the Connect button.  WCME will begin processing any collected call data based on the source file.  Once the progress bar is complete, please verify the output file (c:\bill\smdr.raw) has been created.  Once complete, close the WCME utility.  Call Accounting Mate cannot use the utility to process new data when it is open.

You will need to configure your Call Accounting Mate’s PBX Communication settings to call the wcme.exe utility and process the destination file.  Your configuration should be similar to the below.

Port: File
Before Import: Execute Command Line & Wait It’s Complete
Command Line: c:\bill\WCME\wcme.exe CME1
File Mask: c:\bill\smdr.raw
Type:  Schedule
Every: 1 Hour
After Import: Delete
Call Accounting Mate Q&A / How To Configure CAM for....3CX
« on: April 26, 2012, 01:50:09 PM »
In the CDR Output settings on your 3CX (in the Advance Settings group) specify to Output CDR to Socket.  The CDRTemplate-Socket.xml file in your 3CX’s CDRTemplates folder defines where the CDR is delivered.  Please locate the “CallTemplate" line similar to the below in your CDRTemplate-Socket.xml and make any required changes.

<CallTemplate Host="" Port="33555" OutboundOnly="false">

The value of Host should be changed to the IP address of the PC hosting your Call Accounting Mate.  The value of Port can be changed if desired.

The default 3CX PBX Driver can be downloaded from our web site below.

Save this file into your C:\bill\SMDR folder.  Use the following for your Call Accounting Mate’s PBX Communication settings.

Port: TCP
Port (number): Use the same port programmed on your 3CX, default is 33555
PBX Driver: 3CX (CSV)

Call Accounting Mate can also connect to the 3CX if the "Host" value is left as by selecting "Telnet" as the Port option in the PBX Communication settings and entering the IP address of your 3CX in the field provided.

**Please note: The 3CX driver listed has been configured for the default 3CX CDR template and may need changes based on the programming of your 3CX or configuration of the CDR Template.  For any change requests, please email a sample of your captured CDR data to our support team at**
Avaya (Nortel) Norstar

An SMDR6 device is required for SMDR generation and delivery over a serial (RS-232) connection.  The PC hosting Call Accounting Mate must have a serial COM port available that can be used for data collection.  To program the SMDR6, press Feature 9 * 2 on your handset to enter the administrative options.  The SMDR6 must be programmed to deliver call data in English and we recommend using the "Norstar" data format.

Call Accounting Mate should be configured to capture call data from the COM port your SMDR6 is connected to using the same baud rate you had programmed into your SMDR6.  The Nortel Norstar Series General Driver should be selected from the PBX Driver drop down.  Section 4.2 of the Startup & Installation Guide below provides a further outline of how to configure CAM to capture call data from a COM port.

Avaya (Nortel) BCM

The BCM should be configured to deliver CDR via "CDR Pull".  There is an additional utility, Winlink for BCM, required to pull CDR from your BCM.  A trial of the Winlink for BCM software can be downloaded below.

An addition configuration document that outlines the setup of Winlink for BCM can be found at the below link.

We recommend your BCM be programmed to generate new CDR in Norstar format.  Call Accounting Mate's PBX Communication settings should be configured to process the destination file specified in the WinLINK for BCM's settings.  Below are sample settings of CAM's PBX Communication options for processing the external file.

Before Import=No Action
File Mask=c:\bill\bcmp\cdr.txt
Every=1 Hour
After Import=Delete
PBX Driver=Nortel Norstar Series General Driver

**Please note: The Nortel Norstar Series General Driver contains an additional "Date Format" option under the Properties tab in CAM's PBX Communication screen.  You will need to select the date format that matches your CDR.  After selecting the Nortel Norstar Series General Driver, if the Properties tab does not display the "Date Format" option please contact us at**
Call Accounting Mate Q&A / How To Configure CAM for....Avaya IP Office
« on: November 25, 2011, 04:44:50 PM »
Avaya IP Office v4.2 or later

Although several call data delivery options are available for Avaya IP Office, we typically recommend delivering the SMDR to the PC hosting your Call Accounting Mate via TCP/IP.  Your Avaya's SMDR settings will allow you to specify the IP addres of the PC hosting your Call Accounting Mate and the IP Port to use for delivery.  Please disable the traditional CDR formats.  Call Accounting Mate's PBX Communication settings should be configured to collect data from a TCP port.  Below are sample settings to use for processing.

Port=Enter the same number as the IP Port settings on your IP Office
PBX Driver=Avaya (IP Office)

Avaya IP Office prior to v4.2

Configuration should be similar to the above, however the IP Office SMDR format will not be available.  Instead, please select one of the traditional CDR formats (typically Unformatted or Expanded formats will provide the best data).  For your CAM's PBX Driver, please select either the "Avaya (Unformatted)" or "Avaya (Expanded Format)" driver depending on your select for CDR format on your IP Office.

Avaya IP Office prior to v3.1

Configuration should be similar to the above, however your CDR settings will need to be configured on your Delta Server.  IP Office v3.1 do not require the Delta Server to deliver SMDR/CDR data.
Please download the following documentation regarding integrating Call Accounting Mate with your Cisco Call Manager/Unified Communication Manager.

Cisco Call Manager 3.x/4.x

The Cisco Call Manager 3.x/4.x utilizes an SQL database to store call detail records on the Cisco Server.  An additional tool, WinLINK Remote CCM, will be required to retrieve this data using an ODBC connection and SQL query.  Please contact our support team to request a trial download of this tool at

Call Accounting Mate's PBX Communication settings should be configured to process an external file.  Below are sample settings to use for processing.

Before Import=Execute Command Line & Wait It's Complete
Command Line=c:\bill\wccm\wccm.exe CCM1
File Mask=c:\bill\wccm\outdata.txt
Every=1 Hour
After Import=Delete

Cisco Unified Communications Manager 5.x or later

The Cisco Unified Communications Manager 5.x and later can be configured to deliver its CDR records to an FTP Server.  You can utilize either your own FTP server or the an additional WinLINK FTP Server module.  Please contact our support team to request a trial download of the WinLINK FTP Server at

Call Accounting Mate's PBX Communication settings should be configured to process an external file.  Below are sample settings to use for processing.

Before Import=No Action
File Mask=c:\bill\wftp\cdr*
Every=1 Hour
After Import=Delete
News from / IP Office. SwitchVox, eOn Support
« on: November 04, 2010, 09:48:10 AM »
Call Accounting Mate now supports IP Office 6.0,  SwitchVox and eOn.
Endorsements / Endorsement
« on: July 18, 2007, 07:20:12 AM »
Dear Call Accounting Software developers,
I have been trying out your outstanding software,and I am astonished by its flexibility and reliance so thank you very much for creating this masterpiece.

Thank you so much.
Call Accounting Mate now supports many new PBX, IP and hybrid systems.  Some PBX systems have proprietary protocols for which we have designed special plug-ins and drivers.

We now support Nortel BCM, Cisco Call Manager/Express, Avaya IP Office, Talkswitch, Adtran and many more.

Visit our download section for connectivity information.

Call Accounting Mate Q&A / SPAMMERS! PLEASE READ!
« on: December 08, 2006, 09:59:43 AM »

Please do not post any links that are not relevant to or Call Accounting Mate! 

We do not take kindly to spammers posting adult content, links to promotional items and self-promotion.   We record every poster's IP address.  If we discover inappropriate posts they will be deleted and you will be banned.   Illegal posts will be submitted to the authorities.
Endorsements / Customer Care
« on: November 16, 2006, 03:40:50 PM »
By the way, your company has one of the most responsive Tech Support departments that I have had the pleasure of working with in a long time.
Many software company support centers have become automated to the point that you cannot get to a person to actually speak with, and if you do get to that person they are all to often reading a step-by-step troubleshooting manual that does not help in resolving the problem.
In your case, I did not have to go through that process, but more so, was able to speak with someone who worked on the problem until it was resolved and was both friendly and pro-active in the process.
Thanks again for your assistance.  I am now getting the exact information out of my telephone system that I needed.
Terry Ross
Walters Balido & Crain, L.L.P.
Endorsements / Board Launch
« on: November 16, 2006, 03:39:11 PM »
We would like to thank all our customers who have written many kind letters and emails about our product and services. We are offering this board for you to post your positive experiences with Call Accounting Mate and

Thank you for your support!

If your application requires a special import from Call Accounting Mate, please contact us and we will email you a special tool designed for your file format requirement.

News from / MSN Support for Call Accounting Mate
« on: October 06, 2006, 09:07:39 AM »
In order to assist our customers with basic questions more quickly, we have created a special hotmail account ( which we frequently monitor live.

This new service is not always online but is available. It is primarily for general sales inquiries and software feature questions.

Here is how to register:

Call Accounting Mate Q&A / How to get records from Nortel BCM
« on: September 26, 2006, 01:15:34 PM »
Nortel BCM can be configured to deliver call records to via FTP Push.  It can deposit the records in a directory of your choice.  Consult your system administrator to configure your system for this option.

Call Accounting Mate can then use the Port=file option to translate the data.

The best driver for Norstar format on BCM is:  Nortel Norstar Series General Driver  (installed with your download).

If you wish to poll the data, you will need third party software from RSI.  You can contact us and we will arrange a trial download at   

Third party software can query CAM for its call records:
Call Accounting Mate Q&A / General concept of collecting CDR
« on: August 17, 2006, 11:16:04 AM »
Two primary methods are used to capture SMDR information:
A data-buffer device is connected to the SMDR port via a serial cable. This buffer may be a standalone box, or a PC. Typically, a buffer box stores SMDR records in battery-packed RAM. A computer-based buffer system usually stores records direct to hard disk. Either method provides some protection from power failures.
"Remote-pollable" buffer devices contain a modem, which is directly connected to a trunk or inside analog line. At regular intervals, the buffer may initiate a call or receive one from a computer at a central location (onsite or offsite), and deliver its load of call data for recording and subsequent analysis.

A standalone computer system running call accounting software is attached directly to the SMDR port. Records are stored to hard disk immediately. Analysis and reporting proceeds from the console, or through workstations attached to the main system over the network.
As call records are captured, the call accounting system decodes them and converts them to database records - usually in a standard format. Further analysis is performed on the converted database. Most systems also preserve the "raw" call record stream for archival purposes.
Asterisk Integration / Connecting to Asterisk using ODBC (recommended)
« on: August 02, 2006, 03:10:51 PM »
We now recommend connectivity to Asterisk using our ODBC connectivity method.

The process is fully explained in the new CAM Startup and Installation guide found in our download page:

We have developed a new Startup Guide complete with pictures and examples of how to configure CAM for your country and apply rates or tariffs.

You can find the new Startup & Installation Guide in our "Download" section.

You can also download our latest sales brochure.

From:  Dave Leibold - view profile

Part of my work in the past the linking of a hotel PBX billing systems
to another system that bills the hotel guests. A hotel PBX can send
extension and called number data to a "call accounting system" which
determines costs of calls and which extensions get billed for these
calls. These costs can be billed to the guest manually, or
automatically to a "property management system" that maintains guest
billings and reservations.

In diagram form, a call accounting setup might look like this:

                    HOBIC data from carrier
+-----------+  SMDR   +-----------------+   i/f   +---------------+
| Hotel PBX | ------> | Call Accounting | <-----> | Hotel Billing |
+-----------+         +-----------------+         +---------------+

SMDR (Station Message Detail Recording?) data is sent from the PBX.
This is usually a typical RS-232 data line that sends extension and
calling data from the PBX (but usually doesn't receive data back).

HOBIC is a special hotel billing feature offered by the telephone
carrier to send data on calls placed from the hotel through the
carrier's long distance service. This data is normally sent regarding
operator-assisted calls, such as person-to-person, card, collect or
other special cases. This allows the hotel to bill for calls placed
through the operator where the charge is not apparent from the dialing
sequence (the operator call could be no charge to the hotel, as in the
case of a card or collect call, or it could be extremely expensive in
the case of a person-to-person call). Some call accounting systems
have a "HOBIC Merge" which combines both the HOBIC data and the SMDR
data so that all types of calls may be billed.

The call accounting unit will handle the rating of calls using data
supplied by rate diskettes or cartridges. If the hotel has a computer
system that bills guests, an optional interface (i/f) link will send
the data necessary to bill the extension, and thus the room and guest.
Such data is sent through a typical serial RS-232 connection.

SMDR data formats change from one type of PBX to another. The i/f
format can also vary, but one format common to most systems sends the
following from the call accounting unit:

001A XYZ 09/21  2345 13:45 0008 $002.45 905-034-2657 L

The 001A is a sequence number than increments with each new call report.

The XYZ is a site identifier that is common to the type of call
accounting system used, or set up according to the hotel name. It
remains constant within a hotel site.

09/21 is the date (21st September)

2345 represents the extension number that was dialed (not necessarily
the room number, as some hotels set up extensions so that rooms below
the 10th floor require a 7 plus the room number).

13:45 is the time of the call

0008 is the duration of the call (8 minutes in this case)

$002.45 is the cost of the call as calculated by the call accounting system

905-034-2657 is the dialed number, and the L following that is a flag
to indicate a local call (long distance usually doesn't have a flag,
except F to indicate an international call, perhaps).

The record is often sent down with a carriage return and/or line feed
ending the record, then the hotel system receiving a call record will
send an acknowledgement such as a control-F to indicate that the call
billing data was received at the other end; if there were errors in
the record data, a "negative acknowledgement" or "nak" is sent
(usually control-U) to order the call accounting system to send the
billing data again. A few systems will even add a checksum character
to improve data integrity. Some systems don't have the ack/nak at
all, meaning billing records could be lost if there are severe
transmission errors or if the property management system side is shut

Systems that rate the calls at the hotel normally lack "answer
supervision" which indicates when the call is answered and billable
under regular long distance conditions. Thus, a hotel call accounting
system will usually take a "guess" as to when the call starts and
bill according to the guessed time on line. If the hook is off for a
few minutes, it's usually a good indication that a call is in
progress. Of course, if one rings a number and waits for 20 rings
without answering, there is a risk of a charge for getting no answer.
On the other hand, charges are missed if the system waits too long
before starting to charge. Offering hotels direct access to answer
supervision would eliminate such inaccuracies.

Dave Leibold
Call Accounting Mate now offers hotel, motels and other hospitality properties a way to post their calls into the popular property managment software from:

RezStream -

and various other systems.   A new module that resizes on your system tray retrieves call detail iinformation from the CAM database and submits it to various PMS packages.

Contact us about new additions.
Call Accounting Mate Q&A / Helpful links to various "How To"
« on: February 12, 2006, 11:08:23 PM »
Update or retrieve a new PBX driver from our website

Telephone system manufacturers often upgrade their systems and update or change the CDR (Call Detail Records).   We develop new drivers frequently.    We keep a library of these drivers available to you at all times on our website.   You can download the latest driver for your telephone system by following the procedures outlined here: To Install A New Driver From Support Web Site.mht

Import a tariff plan for your location

Call Accounting Mate can be directed to calculate cost and find location information for virtually any region around the world.  You can load the default table for your country as follows: To Load Default Tariff Plan For My Country.mht

A detailed example is available here: To Import Tariff Plan.mht

Create custom reports from Call Accounting Mate

Call Accounting Mate is equipped with a set of built-in reports that can be processed by clicking a few buttons.   The reports have a static style and look to them.  Custom reports can be designed that allow the user to select  sort order, filter and columns. 

A detailed example follows: To Use Custom Report.mht

Create custom online views

Call Accounting Mate allows you to view your data in various pre-defined and flexible formats.  You can create your own custom views in order to more readily access your information.   The more information you provide to the software, the more descriptive the views will be depicted.

A detailed example showing how to enter department/user information and creating custom templates is available here: To Use Online Views.mht

Schedule Automated Tasks

Automated tasks can be created for specific events or recurring reports.   You may want to set specific criteria for a special report to alert you of misuse/abuse or 911 calls.   You may also want certain reports to be run daily, weekly or monthly.   Call Accounting Mate allows you configure these options for email reporting.

A detailed example follows: To Use Task Scheduler.mht

Recover CAM data from a hardware or OS crash

Call Accounting Mate stores all of the call accounting data in calls.dat and all configuration in bill.ini. In an event of a hardware failure or OS crash, you need to recover these 2 files from the old system. CAM can then be installed in a new system and these 2 files copied to the directory of the new PC where CAM is installed.

In the case of calls.dat file being damaged, we have developed a recovery utility. It tries to recover damaged calls.dat file automatically and/or send user data and log files to developers for further analysis and recovery procedures.

The utility is available for download from:

I want to connect to the Call Accounting Mate database from an external query analyzer.

You will need to install an SQLite ODBC driver and make an ODBC Connection.

Various alternate ways of connecting to Avaya IP Office: to Avaya IP Office Connection.pdf

How to set the file name/mask field to accept Avaya IP Office (daily logs):

Helpful ways of setting up user security and departmental views

News from / Documentation and Brochure now available
« on: February 12, 2006, 11:32:23 AM »
Call Accounting Mate now has a new Startup & Installation Guide available online.   This new documentation will answer the most common questions and provide a more detailed explanation of installation.  There is a complete section on "How To" as well.

You can find the new Startup & Installation Guide in our "Download" section.

You can also download our latest sales brochure.

Resource Software International Ltd. (RSI) is a communications management vendor.  They provide high end desktop messaging solutions, communications management, hotel billing and enterprise call accounting solutions to large organizations.

RSI Visual Rapport is a unified messaging system that works with TAPI and Nortel LAN CTE.  This software provides CDR files which Call Accounting Mate can process.  For more information, please contact the vendor

RSI tools CTI Pack is a tool tailored for Nortel BCM and Norstar.  This application provides various functions not available on the standard out of the box systems.  They include toll restriction, forced/verified account code and SMDR (including internal calls).  Their CDR format is very similar to that of the Nortel Norstar however it is slightly different.   Please contact the vendor for further details
Call Accounting Mate can connect to telephone systems using various methods (serial, file, TCP, Telnet, ODBC etc...).

The Mitel ICP series have the ability to send data over a special telnet connection.  You may choose to utilize this form of connectivity in Call Accounting Mate.  You will need to set the following:

Configuration --->  PBX Communication --->  Port

Port = Telnet
Server Name or Address:  (address of your Mitel 3100/3300 ICP or other)
Server Port:   (port of the Mitel 3100/3300 ICP CDR data stream...usually  1752 by default)

You will also need to define the appropriate driver to translate the data.

For more information, contact

We use a third party tool to retrieve the data to a file on the hard drive.  The data should be retrieved to a .csv or CRLF terminated text file.

Call Accounting Mate can then process the file using the "Port=File" option.

We recommend a third party application from Resource Software International Ltd. (RSI), a Cisco Technology Partner.   It is available for download upon request from us at


CAM allows to import SMDR/CDR data from an OS file automatically basing on schedule or event. To setup CAM to get data from an OS file you need to use Configuration/PBX Communication page and select File in the Port filed on the Port tab on the page. Below is description of various settings related to this function.

Configuration/PBX Communication page, Port tab, Port=File

To access fields/settings described below following steps are necessary:

open Configuration/PBX Communication page
activate Port tab
select File option in the Port combobox

Symbols with special meaning (jokers) that can be used in file masks

* = any sequence of symbols of any length
? = any single symbol
%yyyy = 4 digit year
%yy = 2 digit year
%mm = 2 digit month (includes zero...i.e. 09, 10)
%m = 1 or more digit month (i.e. 1, 9, 10)
%nnn = Month name (i.e. Jan, Feb, Mar, Apr)
%n = Month name (January, February, March)
%dd = 2 digit day
%d = 1 or more digit day
%d-1 = previous day (yesterday)
%ww = 2 digit week number
%w = 1 or more digit week number
%j = julian day number (i.e. 1-365)

For example file mask "SMDR (%yyyy-%mm-%dd).CSV" at 24 Oct 2005 will be expanded as "SMDR (2005-10-24).CSV", at 25 Oct 2005 it will be "SMDR (2005-10-25).CSV" and so on.

Here is a document describing how to connect to Avaya IP Office using TCP, Serial or File mechanism: to Avaya IP Office Connection.pdf

Call Accounting Mate was experiencing an error when an operator would attempt to enter a new PBX in the PBX Configuration section.   The application would flag a "syntax" error.

The problem has been resolved.  Simply install a later version of the software (available in our download section).

Call Accounting Mate version or later.

Call Accounting Mate (as of version  is capable of allowing the user to configure an external program to run prior to parsing a file (using Port = File protocol).

Therefore, if you need to connect to a system that is proprietary or you need to pre-massage data before CAM is allowed to parse the data, you can configure an executable to run immediately before processing.


News from / Contact us Live
« on: November 02, 2005, 10:07:40 AM »
At we are making every effort to answer your questions.

We have now added 2 new features that will instantly give you access to one of our representatives.

Our new MSN contact is:

and we have added Live Help to our website.

Check it out.

Pages: [1] 2 3