Question 140: Using ignore.dbf to ignore certain extensions
Question: How can I use the ignore.dbf file to ignore
particular extensions ?
Version: Call Accounting Pro.
Answer: The file ignore.dbf is used to make the Call
Processing ignore particular extensions during call processing. It can also be used to set
particular numbers dialed to be ignored. When the processing runs, it checks this
file to see if the call it is processing matches on either the extension number, or the
number dialed. If there is a match, this call is ignored and not processed.
You can use the ToolBox to add/edit/delete entries in the ignore.dbf file.
Here is the syntax:
CLOSE DATABASES
SELECT A
USE IGNORE.DBF
GOTO TOP
BROWSE
PACK {An Optional Command - See Below}
CLOSE DATABASES
If you mark any entries for deletion (using Ctrl-T) be sure to run the PACK
command after you browse so that the items marked for deletion are removed from your file.
You can also use Ctrl-N to add a new record to the table.
Question 141: Using ignore.dbf to Identify Authorization Codes on
Specific Numbers Dialed, and automatically assign an Authorization Code to these
extensions
Question: How do I use the ignore.dbf to identify
specific calls by number dialed, and automatically assign an authorization code to these
extensions ?
Version: Call Accounting Pro - Customized Option.
Not available in Standard Software
Answer: A customization to the ignore.dbf table has
been made for a client that runs a shared tenant office. They needed the system to
watch for particular long distance numbers dialed from a phone at the main desk, and
charge these to the authorization code of the client, rather than charging these calls to
the front desk. If these numbers were dialed from another tenants phones, they would
be ignored and not billed back to the first tenant. This allows the operator to
transfer or forward calls received at the front desk to long distance numbers, and have
the system automatically assign the correct authorization code to the call.
Here are the instructions for editing the ignore.dbf table to add/edit, or
delete codes.
ADDING A NEW PHONE NUMBER TO TRACK:
CLOSE DATABASES
SELECT A
USE IGNORE.DBF
BROWSE
CTRL+N
Enter the phone number (without dashes) in the field titled ME.
Enter the authorization code in the field titled ACODE
Enter Optional Company and Person Information
Enter the same authorization code into the Station Administration Module and
assign it to the department to which you want it to bill. All Calls made to that
phone number will automatically bill to that authorization code.
REMOVING A PHONE NUMBER
CLOSE DATABASES
SELECT A
USE IGNORE.DBF
BROWSE
Cursor to the item to delete and type CTRL+T and a bar or dot will show up on the
left of the record. Repeat this process for all the items you wish to delete.
Press the ESC key to exit the browse.
Type PACK to remove the items you marked for deletion.
EDITING A PHONE NUMBER OR AUTH CODE
CLOSE DATABASES
SELECT A
USE IGNORE.DBF
BROWSE
Cursor to the item to edit, make changes, then press CTRL-W to save changes to
the file.
Answer: Yes, you can define a period to be anything
you like using Comm One Call Accounting. Here is a table of the different options
available to you in defining periods:
OPTION
DESCRIPTION
No Period Defined
This is the system default to Call Accounting. All Calls will
by default process into the current period until you go to the File menu and manually run
the Close Period Routine.
Periods by Month
Under the Utilities - System Setup Options, you can define your
periods to be Monthly. Using this option, your months will automatically close out
on the last day of the month after call processing and your periods will automatically be
named MMMYY.DBF, or JAN02.DBF for the month January 2002.
Non-Standard Month
You can also set the system to close on a day other than the last
day of the month. If you set the system to close in the 15th for example, your
period will go from the 16th of the prior month at midnight, until midnight of the current
month. When the file automatically closes, it will be named MMMYY.DBF for the month
the file closed in. For example, if you set the system to close on the 15th, a
system running in July of 2002 would close on July 15th, at midnight, would contain calls
from June 16th to July 15th, and would be named JUL02.DBF.
Question 144: How do I add a second
Trunk Group with separate Costing
Question: How do I add a second trunk
group with separate costing ?
Version: Call Accounting Pro - Version 3.3
- 3.5
Answer: Follow these steps to add another
trunk group that has its own carrier table for costing.
Start Call Accounting. From the RATES menu option, Select
the CARRIER file.
Add a new Carrier Table with the desired costing, Save the Table
Next add the new Trunk Group Code in the Trunk Group file.
Edit the New Trunk Group Code and specify the Carrier Code that
you created in step 1 above. When calls are made on that trunk
group, they will use the carrier code specified.
Question 145: What special settings
should I use for NEC 2400 Call Processing
Version: Call Accounting Pro
v3.5
Answer: The NEC 2400
PBX does not send a CR (Control Return) or LF (Line Feed) after each call
record, it sends a ^C after each record. This makes each call record run
together on the screen and makes the raw detail logs almost impossible to
interpret and difficult to process. To eliminate these problems with the
NEC log files you can use the following procedures to make each call record
show left justified in the call log so that each field in the record is in the
same column.
Create a translate table in Procomm Plus 32
that translates ^C to ^J, and exclamation ! to ^M. This will tell
Procomm plus that when it sees the ^C character at the end of a call
record, to translate it to a ^J and ^M which are CR and LF. This
will put each call record on a new line. Name the translate table NEC.XLT.
In the dialing directory under the ADVANCED OPTIONS tab set the
translate table to the NEC.XLT table. This will set the script to
use that translation table when the buffer is called.
Call the Memory Buffer and issue a ^B05
command and change the end of record character to a ^C. Type ^B16
and check that it shows the correct character.
Edit the script file so that it shows the
calls in the log the same as it shows on the screen. Search for the
script text 'SET CAPTURE RECORDMODE RAW" and change it to SET CAPTURE
RECORDMODE SCREEN.
On the dialing entry change the terminal type
to VT-100 if it is not already set to that.
Last of all load Procomm and go to the DATA
SETUP options. Change the current terminal to VT-100. Next
make sure that the LINE WRAP box is NOT CHECKED, and that the INCOMING CR
to CRLF is also NOT CHECKED.
With these settings made, your log files will be
pretty and clean instead of garbled as they are normally on a NEC2400
PBX. Finally, you need to get the updated Call Processing script from
our Technical Support department.
Question 146: How do I clear the
contents of the Set Type Box in Station Administration
Version: Call Accounting Pro
v3.5
Answer: The Set Type
Popup box allows you to select set types from a pre-defined list. The
system ships with some sample set types. Most users do not use all of
the sample set types. You can delete the items you do not use, or you
can use the following toolbox command to clear out the file and start over.
CLOSE DATABASES
SELECT A
USE CA_SET.DBF
DELETE ALL
PACK
QUIT
Question 147: How do I view Raw Call
Accounting Log Files
Version: Call Accounting Pro
v3.5
Answer: You can view
raw log files using the toolbox module. The command you use is MODIFY
COMMAND followed by the path and file name of the log file you wish to edit.
Below are some examples.
To set the toolbox default directory you use the
SET DEFAULT command shown below. You will be shown a directory popup box
which you should navigate thru to your call accounting log directory.
Most logs are located in the LOGFILES subdirectory under your CA35 directory.
SET
DEFAULT TO ?
To view a log file you can type:
MODIFY
COMMAND ?
When prompted, select the log file you wish to
view, and it will appear on your screen. When you have completed viewing
you can press ESC or CTRL-W and you will be returned to the toolbox.
Type QUIT to exit the ToolBox.
Question 148: How do I change Duration
from 100ths to Seconds
Version: Call Accounting Pro
v3.5
Answer: The system
defaults to tracking call duration by 100ths of a minute. For example a
call for 2 minutes and 30 seconds will show up on the system as 2.50 or 2 1/2
minutes. You can however change the duration field on any report to show
minutes and seconds. This would show 2.30 instead of 2.50 for the same
call. To accomplish this you do the following:
Preview the report you wish to modify and get
the report name from the bottom right corner. We will use the
default call detail report (carpt1.frx) for this example.
Start toolbox and issue the MODIFY REPORT
command as follows: MODIFY REPORT CARPT1.FRX
You should see the report generator for the
report you wish to modify.
Find the duration field on the report.
It will be in a box on the detail line below the call duration heading and
will be named DUR. DUR represents the field name for the standard
duration in 100ths of a minute.
Double click the DUR field to view its
contents and change it to the following:
((60 * (DUR - INT(DUR))) * .01) + INT(DUR)
Press OK to save the changes to the field and
press CTRL-W to save the report
Repeat the procedure for any other report you
wish to change from hundredths to seconds.
Question 149: How do I change the
clock on my memory buffer
Version: Call Accounting Pro
Answer: When calls are
received by a memory buffer they are time and date stamped by the memory
buffer. If the clock is wrong on the memory buffer, calls will be shown
in Call Accounting with an incorrect date. To remedy this situation you
need to dial into the buffer and set the correct date and time. Here is
how you do it:
DIALING THE BUFFER: From Procomm press ALT-D to bring up the dialing directory.
Highlight your buffer dialing entry and select DIAL from the menu shown below
it. Your computer will dial the memory buffer.
PASSWORD: Once you connect to the buffer, you may need to enter a password for the
buffer. If you do not know the password for your buffer please email us
at support@commone.com
CHECK BUFFER DATE: You can check the buffer date by issuing either a ^B16 command or by
typing STATUS and pressing return. You should be shown a status screen
that shows the current date and time at the top.
POLLSAFE MODEL 680: Using a Pollsafe 680 the command to change the clock is either ^B11 or
SETUP CLOCK. This command is used to set the internal real-time clock on
the buffer. The PS680 will prompt you for a time, a date and a day of
the week which are then used to set the real-time clock. 24-Hour time is
used for the clock.
POLLSAFE MODEL 635: Using a Pollsafe 635 the command to change the clock is CLOCKSET.
This command is used to set the internal real-time clock. 24-Hour time
is used for the clock. The format for the command is:
CLOCKSET MM/DD/YY HH:MM Day(1-7-SUN-SAT)
Example: To set clock for Tue Tuesday July 1, 2004,
1:30pm use:
CLOCKSET 07/01/04 13:30 3
Question 150: How to do a Manual
Download & Call Processing
Version: Call Accounting Pro
Background:
Occasionally you may
need to look up a call record that has not been downloaded or processed from
your computer yet. When using a memory buffer, as calls are completed
they are stored in the buffer. In order to access the date, it needs to
be uploaded and processed into the current months call file.
PROCOMM SCHEDULER VS WINDOWS SCHEDULER:
Occasionally
There are 2 main scheduling programs used to schedule the download and
processing of your buffer. You can use the WINDOWS SCHEDULER program, or
the SCHEDULER program that is included with Procomm Plus. Either program
will give you options for daily downloading and processing.
Resolution:
The first step
is to get the calls downloaded from the buffer and stored onto your
computer. You can do this by manually running the download programs in
Windows Scheduler or Procomm Scheduler
WINDOWS SCHEDULER:
Right click scheduled event and select the RUN NOW option.
PROCOMM SCHEDULER:
Select the download scheduled event and then click on TEST RUN
in the middle of your screen. The processing event usually has PW4
or PW5 on the Program line.
The last step is to
manually run the call processing file that will add the call records to your
system. You can find this program in the same place as described in #1
above. Make sure that the main Call Accounting program is not running
when you run Call Processing or the system will return an error message.
With call records downloaded and processed, you can now run reports.
Question 151: How to Edit Raw Logs/
How to Edit Processed Call File
Version: Call Accounting Pro
Background:
How do I look at and/or edit the raw call detail and processed
call records.
Caution: If
you save any changes made while editing either the raw or processed data
files, you need to be careful that you do not change any file formats.
If you do, you could damage the file so that it is unusable in the future.
Be careful that any changes you make do not affect the structure of the file.
Also, any changes made to the raw data file are unrecoverable.
Edit / View Raw Data:
The raw data files are
stored in the \\logfiles directory under your
Call Accounting Software. The default path name is c:\ca200X where X is the version (ex. ca2002,
ca2004). These files are stored in plain ASCII format and can be edited
from any text editor. To edit them from the Comm One Toolbox issue the
following command:
MODIFY COMMAND ?
Edit / View Processed Data:
Processed data is stored in the current file
PLM_CA.DBF located in the current directory. To edit this file, load the
toolbox module and type the following commands:
CLOSE DATABASES
USE PLM_CA.DBF
BROWSE NORMAL
When you are complete, just close the window.
The file saves changes as you leave each field automatically.
Question 152: How do I do a manual
download & processing with a CA_TERM
Version: Call Accounting Pro
Background: Ocassionally you may need to
look up a call record that has not been downloaded or processed from your
computer yet. As calls are completed, the raw data is captured by the
CA_TERM program. These logs are usually in flat ASCII format with no
delimiters.
At the scheduled time, the CA_TERM will close out and save a log file
containing raw call detail. Another event, Call Processing will then run and
convert the raw call data into the Comm One Accounting database files so that
reports can be run.
Stop CA_TERM:
Stop the CA_TERM program by selecting
it and then closing it by clicking the "X" in the top right corner. As
the CA_TERM close, it will save the raw data iit has captured and store it in
a directory on your computer named
\\ca2002\logfiles.
Restart
CA_TERM:
Once the file has captured and the CA_TERM has closed, restart the CA_TERM again so that the system can go back
on-line and you will not lose any data
Run Call Processing:
The last step in to manually run Call
Processing, You can do this by clicking on the Call Processing Event in
your windows Schedule, and then selecting RUN NOW. This will run the
call Processing and convert any raw logs that have not been processed into the
Call Accounting. Make sure that the main Call Accounting program is not
running when you run the Call Processing or the system will return an error
message. With call reports downloaded and processed, you can now run
reports.
Symptoms:
The screen resolution on the report
preview screen is controlled by the font on the report, and by the resolution
settings on your computers graphic card. Microsoft has confirmed a
problem with previewing reports, especially using NT and/ or low resolution
monitors.
Resolution:
This problem has been addressed and
corrected with Comm One v2003 and later with file dates after May 31, 2003.
Microsoft also recommends that you set your screens resolution to a higher
setting such as 1024 x 768. Depending upon your graphics card and
monitor, you may be okay using lower monitor resolution.
Changing
Screen Resolution:
Your screen resolution is controlled
by the Display Settings found in the Windows Settings. These settings
and options are controlled by Microsoft and programmed from within our system.
Microsoft recommends that if your reports are not legible you can try
increasing the resolution of your screen. On most monitors, increasing
the resolution will make the preview more legible. To do this follow
these steps:
From the Desktop, right click on a blank
area of the screen and select Properties.
From the Display Properties dialog box, select the
Settings Tab.
From the Settings Tab move the Screen Area control
to the right increasing the number of pixels on the screen and increasing
the resolution. You may have to try two of three settings until you
find the one that works for you.
Copyright 1991 -
2008 Comm One, Inc. Comm OneŽ is a
registered trademark of Comm One, Inc.
Other trade names mentioned are registered trademarks
of their respective companies.
