Question 600: Command to Delete Calls for Particular Month
Question: What is the ToolBox Command to Delete Calls
for a particular Month?
Version: Call Accounting Pro.
Answer: Here are the instructions for deleting call
records for a particular month. At the ToolBox Command Window type the following
commands assuming that you wanted to delete all calls for the month of July.:
CLOSE DATABASES
SELECT A
USE PLM_CA (Or select a prior period
file here)
DELETE ALL FOR SUBSTR(DATE,1,2) = '07'
PACK
CLOSE DATABASES
QUIT
If you were going to delete calls for the month of September, you would replace
the '07' with '09' in the above example.
Question: How do I export a file using the ToolBox
Module Commands ?
Version: Call Accounting Pro.
Answer: Here are the instructions for Exporting data
from the station file or the current months call file. At the ToolBox Command Window
type the following commands:
COMMANDS TO EXPORT STATION FILE TO EXCEL
CLOSE DATABASES
SELECT A
USE LINE1.DBF
COPY TO EXPORT.XLS TYPE XLS
CLOSE DATABASES
QUIT
You can name the file anything you wish by replacing the EXPORT.XLS file name
with another file name.
COMMANDS TO EXPORT STATION FILE TO LOTUS
CLOSE DATABASES
SELECT A
USE LINE1.DBF
COPY TO EXPORT.WK1 TYPE WK1
CLOSE DATABASES
QUIT
You can name the file anything you wish by replacing the EXPORT.WK1 file name
with another file name.
COMMANDS TO EXPORT STATION FILE TO ASCII COMMA DELIMITED FILE
CLOSE DATABASES
SELECT A
USE LINE1.DBF
COPY TO EXPORT.TXT TYPE DELIMITED
CLOSE DATABASES
QUIT
You can name the file anything you wish by replacing the EXPORT.TXT file name
with another file name.
COMMANDS TO EXPORT CURRENT CALL FILE TO AN EXCEL FILE
CLOSE DATABASES
SELECT A
USE PLM_CA.DBF
COPY TO EXPORT.XLS TYPE XLS
CLOSE DATABASES
QUIT
You can name the file anything you wish by replacing the EXPORT.XLS file name
with another file name.
Question 602: Structure of Station File (User File)
Question: What is the Structure of the Station File
Version: Call Accounting Pro, Cable Management Pro
Answer: Here is the data file structuire (data
dictionary) for the Station File (User File).
Structure for database: L:\V33\CA\LINE1.DBF
Memo file block size : 64
Field Field Name Type Width Dec Description
1 ELOC Character 15 Jack Location
2 BUILDING Character 15 Building
3 COMMENTS Character 60
4 EXTN Numeric 7 User Extension
5 DATA Character 7
6 PAD Character 15 Port Address
7 TYPE Character 15 Equipment Type
8 TABLE Character 2
9 NAME Character 18 User Name
10 DEPARTMENT Character 35 Department Code
11 P0 Character 8 User Defined Field
12 P1 Character 16 User Defined Field
13 P2 Character 16 User Defined Field
14 P3 Character 16 User Defined Field
15 P4 Character 16 User Defined Field
16 P5 Character 16 User Defined Field
17 P6 Character 16 User Defined Field
18 P7 Character 16 User Defined Field
19 P8 Character 16 User Defined Field
20 P9 Numeric 16 2 User Defined Field
21 P10 Numeric 16 2 User Defined Field
22 P11 Character 8 User Defined Field
23 P12 Numeric 12 2 User Defined Field
24 P13 Numeric 12 2 User Defined Field
25 P14 Numeric 12 2 User Defined Field
26 P15 Numeric 12 2 User Defined Field
27 P16 Numeric 12 2 User Defined Field
28 P17 Numeric 12 2 User Defined Field
29 P18 Numeric 12 2 User Defined Field
30 P19 Numeric 12 2 User Defined Field
31 P20 Numeric 12 2 User Defined Field
32 P21 Numeric 12 2 User Defined Field
33 P22 Numeric 12 2 User Defined Field
34 P23 Numeric 12 2 User Defined Field
35 P24 Numeric 12 2 User Defined Field
36 COST Character 8
37 SNOTES Memo 10
38 CDRCHGS Numeric 12 2
39 WOCHGS Numeric 12 2
40 OTHERCHGS Numeric 12 2
41 EQCHGS Numeric 12 2
42 FROMEXT Numeric 7
43 HZIP Character 15 Site Identifier
44 STATUS Character 15 Active or Inactive
45 NUMSET1 Numeric 3
46 NUMSET2 Numeric 3
47 NUMSET3 Numeric 3
48 NUMSET4 Numeric 3
49 SET2 Character 16
50 SET3 Character 16
51 SET4 Character 16
52 SET2CHG Numeric 8 2
53 SET3CHG Numeric 8 2
54 SET4CHG Numeric 8 2
55 LOCAL Numeric 8 2
56 INTERNAL Numeric 8 2
57 LOCMIN Numeric 8 2
58 INTMIN Numeric 8 2
59 STATIONID Character 10 Record ID
60 AH Character 3
61 AF1 Character 3
62 AF2 Character 3
63 AE1 Character 3
64 AE2 Character 3
65 RH Character 3
66 RF1 Character 3
67 RF2 Character 3
68 RE1 Character 3
69 RE2 Character 3
70 EH Character 3
71 EF1 Character 3
72 EF2 Character 3
73 EE1 Character 3
74 EE2 Character 3
75 FAX1 Character 20
76 FAX2 Character 20
77 EMAIL1 Character 20
78 EMAIL2 Character 20
79 HAND Character 20
80 ADDRESS Character 40
81 CITY Character 25
82 STATE Character 10
83 ZIP Character 10
84 PHONE Character 20
85 DIRNUM Numeric 7
86 EDOTH1 Character 10 Employee Directory Field
87 EDOTH2 Character 10 Employee Directory Field
88 EDOTH3 Character 10 Employee Directory Field
89 EDOTH4 Character 10 Employee Directory Field
90 EDOTH5 Character 10 Employee Directory Field
91 EDOTH6 Character 10 Employee Directory Field
92 EDOTH7 Character 10 Employee Directory Field
93 EDOTH8 Character 10 Employee Directory Field
94 EDOTH9 Character 10 Employee Directory Field
95 EDOTH10 Character 10 Employee Directory Field
96 ROOM Character 10 Room
97 COS Character 15
98 COM Character 15
99 HUNT Character 15
100 PICK Character 15
101 PHNML Character 15
102 FWD1 Character 15
103 FWD2 Character 15
104 FWD3 Character 15
105 CCARD Character 20
106 ACODE Character 20
107 IDATE Character 8
108 RDATE Character 8
109 PCHG Numeric 9 2 Port Charge
110 SCHG Numeric 9 2 Set Charge
111 EDOTH11 Character 10 Employee Directory Field
112 EDOTH12 Character 10 Employee Directory Field
113 FWD4 Character 15
114 PCA Character 10
115 PCB Character 10
116 PCC Character 10
117 PCD Character 10
118 PCE Character 10
119 PCF Character 10
120 PCG Character 10
121 PCH Character 10
122 PCI Character 10
123 PCJ Character 10
124 SCA Character 10
125 SCB Character 10
126 SCC Character 10
127 SCD Character 10
128 SCE Character 10
129 SCF Character 10
130 SCG Character 10
131 SCH Character 10
132 SCI Character 10
133 SCJ Character 10
134 PXA Character 10
135 PXB Character 10
136 PXC Character 10
137 PXD Character 10
138 PXE Character 10
139 PXF Character 10
140 PXG Character 10
141 PXH Character 10
142 PXI Character 10
143 PXJ Character 10
144 SXA Character 10
145 SXB Character 10
146 SXC Character 10
147 SXD Character 10
148 SXE Character 10
149 SXF Character 10
150 SXG Character 10
151 SXH Character 10
152 SXI Character 10
153 SXJ Character 10
154 PRIORITY Numeric 3
** Total ** 1750
Version: Call Accounting Pro, Cable Management Pro.,
Call Accounting Jr.
Answer: All Comm One Reports can be edited by using
the report generator features of the toolbox module. Each report has the report file
name listed on the bottom right hand corner of each report. To modify the report,
you simply issue the MODIFY REPORT command and select the report from the file selection
box. When you have completed editing the report, you type CTRL-W to save your
changes. CAUTION: If you make incorrect changes to a report format, this may
result in a system error when you try to run the report. Be careful making changes
to avoid this problem.
Answer: Instead of using the standard menu options to
delete extensions, you can use the toolbox Browse command to delete extensions. This
is usually much quicker than using the standard program prompts, and allows you to view
all extensions on a single screen. Commands to do this are as follows:
Start the Toolbox Module and type the following commands:
CLOSE DATABASES
SELECT A
USE LINE1.DBF
SET ORDER TO 2
BROWSE FIELDS extn,name,department
While the browse is open, you will see your users
sorted by extension number. If there are any that you wish to delete, place your
cursor to the left of the extension number and click the mouse. You will see a small
diamond appear if you are using the DOS toolbox, and you will see a black rectangle appear
if you are using the Windows Toolbox. This indicates that that station is marked for
deletion. To un-mark that station for deletion, simply click the same place again.
Once you have tagged all of the stations you wish to remove, press ESC to return to
the Command prompt and type PACK. This will remove the records marked for deletion.
Answer: These commands allow you to re-cost your long
distance calls using a ToolBox Command, and overwrite the costs assigned by Call
Processing. You can replace the rate shown with any rate you wish.
Start the Toolbox Module and type the following commands:
CLOSE DATABASES
SELECT A
USE PLM_CA.DBF
REPLACE ALL PRICE WITH DUR * .07 FOR CALLTYPE = "LD"
CLOSE DATABASES
QUIT
Here is a description of what the fields in the replace command mean:
PRICE: The price of the phone call shown on detail reports
DUR: The duration in minutes of the phone call
CALLTYPE: The field identifying what call type each call is.
"LD": Identifier for Long Distance Calls.
PLM_CA.DBF: Your current months call file
.07: The rate to apply against the long distance calls.
You can recost for other call types as well. Here is a list of the
CALLTYPE codes to use:
LD - Long Distance
LOC - Local Calls
INC - Incoming Calls
800 - Toll Free Calls
INT - International Calls
IHC - In House Calls
EXAMPLE: To re-cost all international calls at .40 per minute you would
type:
Start the Toolbox Module and type the following commands:
CLOSE DATABASES
SELECT A
USE PLM_CA.DBF
REPLACE ALL PRICE WITH DUR * .40 FOR CALLTYPE = "INT"
Press ESC when you are done editing. You can also use the Ctrl-T to toggle
delete a record. If you mark records for deletion, be sure to run the REMOVE DELETED
RECORDS option located under the main Call Accounting UTILITIES menu option.
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.
