If you are a telecommunication firm
seeking affordable data collection and billing software
that runs on a Windows PC platform, then you've come
to the right place. Our data collection software provides
you with a unique graphical view of the telephone traffic
as it is being collected and saved to a database. Our
billing software then seamlessly processes this data
to produce a bill to anyone of your telecom customers.
Microforce,
the company providing this Telcosoft website, has developed
two programs that have been successfully used over a
four year period to collect telephone call data from
a Harris 20/20 switch, and to produce billing reports.
The programs run on any 32 bit Microsoft Windows PC
platform. The data collection program is called Traffic
Cop. It is a visually informative application
that processes real time telephone data 24 hours a day
and continuously saves it to a Microsoft Access 2000
database. The other application is the billing program
and is mnemonically titled Traffic Ticket.
This is because it is later used to read and process
the collected traffic to produce a ticket, i.e., a bill
to the customer.
Traffic
Cop runs on a PC using Windows NT/2000/XP and
receives Call Detail Record data over the serial port
from the main telephone Switch. The CDR event information
is processed to allow the creation of an End Of Call database
containing all the telephone data necessary to produce
a bill to any telecom customer using the Switch. While
the database is being produced by Traffic Cop, the active
telephone traffic, complete with duration times, and the
T1 circuits being used, are being graphically displayed
on the PC monitor in multiple windows. One glance at the
monitor, and you have a clear image of how much traffic
is flowing through your telephone circuits. Traffic Cop
runs nonstop year round, and continuously updates its
Microsoft Access 2000 database files and tables. The Access
database files are opened and closed automatically each
month, while the End Of Call tables being built inside
this monthly database are opened and closed daily. Go
to Traffic Cop Diagram
to see a block diagram of the hardware and software connectivity,
to Traffic
Cop Details for more explanatory details,
and to Traffic
Cop Graphics to see a snapshot view of
a prior Traffic Cop real time traffic collection session.
The
companion program Traffic Ticket is
used to create the bill to the Telecom customers that
were using the Switch. It runs most efficiently on a
separate PC in a network environment that allows the
download of the Access 2000 database files from the
Traffic Cop computer. Since a prerequisite to bill creation
is the availability of a Rate table containing the Country
Name, Country Code, and Rate per Country Code, Traffic
Ticket was designed to be capable of displaying and
modifying such a Rate table. This is an all important
and user friendly feature that makes the necessary editing
of the rates based on new agreements between customer
and vendor easy to accomplish. Traffic Ticket assumes
that your company bills other telecom customers basis
dedicated In-Trunk assignments in your Switch. These
In-Trunk parameters, specific to the customer, along
with billing period dates are then manually entered,
and the bill creation process is run automatically to
produce the final report. During the billing run, the
customer specific rates are applied to the duration
seconds in the End Of Call Tables produced earlier by
Traffic Cop. The final bill report is grouped by Country
Code for display and printing purposes. Go to Traffic
Ticket Diagram to see a block diagram of the hardware
and software connectivity, to Traffic
Ticket Details for more explanatory details,
and to Traffic
Ticket Graphics to see a snapshot view
of a final bill from an earlier Traffic Ticket bill
creation session.
All
of the tables that contain the telephone traffic data
are neatly stored in Microsoft Access 2000 database
files that can then be viewed and queried using Microsoft
Access itself. Since most of the telecom world makes
extensive use of the two very popular Microsoft Office
applications - Access and Excel, then the use of an
Access 2000 database platform for permanent telephone
data storage makes practical and economic sense for
any midsize telecom firm.
BACK
TO TOP
|
