PBXInsight Software

Interested in marketing this program or beta testing this program? Visit nortel.pbxinfo.com and send me a Private Message. Chas2002

 

PBX Insight Software

 

MsAccess Value Added Software

 

--[PBX Insight is the updated version of TrafficSwitchboard.mdb Beta Version 1.1. All intellectual rights, Visual Basic programming, and formatting for both; PBX Insight and TrafficSwitchboard.mdb are strictly reserved by Charles Bryan Carter.]--

Version 2.2a

Created by

Charles Carter

Table Of Contents

Overview Page 3

Specific Deliverable Objects Page 3

Data Storage and Conditional Requirements Page 3

Main Form PBX Insight Switchboard Page 5

Buttons, Fields, and other generalized information Page 6

Asset Form Page 7

Authorization Code Form Page 9

Console Form Page 10

Maintenance Form Page 11

Report Form Page 12

Switch Health Page 13

Trunk Analysis Page 14

Overview:

The Core Purpose of the PBX Insight Value Added Software is to automate tasks; specifically those tasks performed to collect, report upon, and modify Traffic Data from the Meridian Family of Switches.
The program is written using Microsoft Access or more to the point, MS Visual Basic via the Microsoft Jet Database. This is an "engine" that manages data and allows data to be entered, modified, collected, and reported upon in a database. Each record is unique in that it is given an "index’ or identifier. This uniqueness is what allows data to become Historical Data and is available for reports and modification far into the future.
 

Specific Deliverable Objects:
Forms: The Graphical User Interface (GUI) that overlays the Tables in the database. Offers automated data entry from the Imported Traffic file, drop down boxes, and short-cut keys. Help for each field is presented when the mouse is left over the field without clicking.
Reports: Canned reports that calculate, sum, and average number fields in the database. The program offers over 35 basic reports.
Fields: The database; date/time, text, number, and yes/no basic fields. The fields are automated when possible and require little input by the user.
Tables: There are 200+ tables in the database. The tables collect and modify data to support Reports.
Macros and Visual Basic: The programming that runs the database.
Queries: Provide search and retrieve data for reports.

 

 

Data Storage and Conditional Requirements:

 

Basic whole MS operations: MS creation, deletion and related MS-level operations.
 
Column and row access: Access to MS MAIN and sub-table rows and columns.
Sorting and selection: The ability to support bulk sorting and selection operations MS selections are expected to be expressed in a close variant of the Table Query Language (TaQL), defined elsewhere.
MAIN MS iteration: Sequential iteration through the MAIN MS table on arbitrary iteration indices, with optional retrieval of associated MS sub-table data matching the current MAIN table iteration interval. Indexed access to the MAIN table, on limited key indices, is a secondary requirement. MAIN table iteration includes simultaneous or sequential iteration through multiple MS considered as a set. Iteration is also required within MS MAIN rows, in frequency, velocity or polarization.
MS sub-table iteration: Independent sequential iteration through individual MS sub-tables, on arbitrary iteration indices. Keyed access to MS sub-tables in read-write mode, on arbitrary key indices. Iteration is also required within rows, in frequency, velocity or polarization, as appropriate for individual sub-tables.
MS derived quantities: Computation or retrieval of derived MS quantities, which require data, accesses across the MS as a whole. Examples include elevation computation, assembling higher-level coordinate information or retrieval of Doppler shift parameters.
MS data ranges: Determination of the data ranges in a given MS, for any MAIN or sub-table columns or derived quantities.
MS data objects: Provision of C++ classes to model a data cube containing part or all of the current iteration or selection, which can be operated upon by other agent classes (e.g. calibration), and passed between AIPS++ classes and between C++ and Glish.
Scratch column management: Creation and deletion of scratch columns that may be added to, or removed from the MS during reduction.
Parallel I/O support: Full integration of parallel I/O capabilities within the standard serial MS access classes, and the ability to optionally enable the parallel I/O capabilities.
Table infrastructure use: Full re-use of all Table system infrastructure and design philosophy wherever possible in the MS access classes.
Efficiency: I/O is a critical part of astronomical data reduction performance, and efficiency is a key requirement for MS access. This includes integrated I/O profiling, in both the serial and parallel case.

 

 

 

 

Main Form PBX Insight Client Switchboard:

The PBX Insight Switchboard is the Main Starting Point for the program. From this location you can;
Open Assets Form by clicking the Icon,
Open Authorization Codes Form by clicking the Icon,
Open Console Measurement Form clicking the Icon,
Open Database Maintenance Form by clicking the Icon,
Open Reports Form by clicking the Icon,
Open Switch Health Form by clicking the Icon,
Open Traffic Analysis Form by clicking the Icon,
 
 
 
 
 
 

Asset Management

 

Asset Management is the database that allows the PBX Manager, Supply Personnel, or System Technician to input, track, and report upon Telephone assets and Critical Spares.

 

 

 

Asset Form Fields:

 

ID - Automatically assigns an Asset ID when a new record is created.

Asset Nomenclature - Select from the dropdown list or type a descriptive name for the

asset.

PO Number - Enter the PO Number. This field will accept Numbers or Characters

Date Received - Enter the date in mm/dd/yy format. For current date press

Ctrl + semicolon.

Cost of Asset - Enter the cost of this asset.

Date Installed - Enter the Date the asset was removed from inventory and installed.

Vendor - Enter the Vendor who supplied the asset.

Installed in Department - Enter the department the Asset was installed in.

Installed for - Enter whom the asset was installed for, who requested the installation, etc.

Warranty - Check the check box if this asset has a warranty.

Type of Warranty - Select from the list or enter a warranty type.

Warranty Return - If the asset is return under a warranty, enter the date returned.

Type of Failure - Select from the list or enter a type of failure.

Asset Status - Use the check boxes to indicate the asset is in inventory or has been

Installed.

 

Asset Form - Command Buttons

 

 

Authorization Codes

 

Authorization Codes is the database that allows the PBX Manager, Supervisor, or System Administrator to input, track, and report upon Authorization Codes.

 

 

 

Authorization Code Form Fields:

 

Authorization Code - Enter the Auth Code created by the Switch Technician.

First Name - Enter the First Name of the owner of the Auth Code.

Last Name - Enter the Last Name of the owner of the Auth Code.

Department - Enter the employees Department.

Main Number to bill: - Auth codes will need to be associated with a billing number in the PMS System.

Date of Creation - Enter the date the Auth Code was created. Enter date in mm/dd/yy

Format.

 

 

Authorization Code Form - Command Buttons

 

 

Console Form

 

The Console form is part of a powerful database that collects Console Measurements and allows the PBX Manager or Supervisor to add/modify data.

 

 

PBX Console Form Fields:

 

Most fields on the Console form are automatically populated when opened. The PBX Manager will only need to add the Position Operators name. The information may entered manually as well.

 

Pos Operator Field - Select the name of the Operator for that position. If the operator does not appear in the list, then update the Operator list by opening the Database Maintenance form from the Main Switchboard.

 

PBX Console Form - Command Buttons

 

Maintenance Form

 

The Maintenance form allows the PBX Manager or System Administrator to compact, repair, view the Error log, or Add/Delete Operators.

 

 

Report Form

 

The Report form allows users to select, print preview, or print a report from a Drop Down list.

To run a report: Highlight the report in the Drop Down list, then click the "Run Detailed Report" button.

 

 

Report Form Fields:

 

Most reports require that he user enter criteria.

 

Printing Reports for a Single Date and Time:

 

When asked to type the Start Date and the End Date - Type the same date in both

dialog boxes. This will report on that date only. Date format is mm/dd/yy.

 

When asked to type the Start Time and the End Time - Type the same time in

both dialog boxes. This will report on that Time only. Time is in Military format

1:00am would be 01:00 and 3:00pm would be 15:00.

Printing a Report for Ranges in Dates and Times:

 

When asked to type the Start Date and the End Date - Type the start and end date

for the report. This will report on those dates only. Date format is mm/dd/yy.

 

When asked to type the Start Time and the End Time - Type the start and end

time for the report. This will report those times only. Time is in Military format

1:00am would be 01:00 and 3:00pm would be 15:00.

 

System Health Form

 

This form is automatically populated and is for viewing only. The database collects numerous data from the traffic file and allows System Engineers and Technicians to view the information as historical Data.

 

 

System Health Form Fields:

 

Review the appropriate NTP's for meaning of the Forms measurements.

 

Nortel Document Number: 553-2001-450

 

Trunk Analysis Form

 

This form is automatically populated and is for viewing only. The database collects numerous data from the traffic file and allows the PBX Manager, System Engineers and Technicians to view the information as historical Data.

 

 

Trunk Analysis Form Fields:

 

Review the appropriate NTP's for meanings of the Forms measurements.

 

Nortel Document Number: 553-2001-450

Below is a ShockWave Flash file that I use to assist managers in learning and managing Symposium.

Email: sprinttech@beaurivage.com