COMM ONE CALL ACCOUNTING SOFTWARE
FAQ-1452 How to Delete Calls for a Year
HOW TO DELETE CALLS FOR A YEAR
The Comm One Toolbox allows you to enter commands that are run globally on a complete data file. That way you can quickly modify your data as needed without having to edit records one at a time.
HOW TO ACCESS THE TOOLBOX COMMAND LINE
-
Close all programs
-
Open the Comm One Software Folder on the Desktop
-
Open the UTILITIES folder.
-
Double Click the TOOLBOX icon.
-
You will be taken to the toolbox command line editor.
The following commands are entered in the ToolBox Utility. If the command is successful the command line editor will return without error. If you make a mistake in typing the command, you will see an error message. In that case, you should type CLOSE DATABASES and start the commands over again.
TOOLBOX COMMAND TO DELETE CALLS FOR A WHOLE YEAR
To delete old call records from the toolbox for all of 2020 at the ToolBox command utility you would type the following commands:
-
CLOSE DATABASES
-
SELECT A
-
USE PLM_CA.DBF
-
COPY TO HISTORY.DBF
-
DELETE ALL FOR SUBSTR(DATE,7,4) = "2020"
-
PACK
-
BROWSE NORMAL
Then scroll to the top and make sure they are gone. Then press ESC to exit the browse and type QUIT and RETURN to exit the toolbox Utility.
TOOLBOX COMMANDS TO DELETE CALLS FOR A SPECIFIC MONTH.
To delete calls for a month you need to specify the month (1,2) and the year (7,4) in your substr command.
To Delete calls for July 2020 you would type:
-
CLOSE DATABASES
-
SELECT A
-
USE PLM_CA.DBF
-
COPY TO HISTORY.DBF
-
DELETE ALL FOR SUBSTR(DATE,1,2) = "07" .AND. SUBSTR(DATE,7,4) = "2020"
-
PACK
-
BROWSE NORMAL
Then scroll to the top and make sure they are gone. Then press ESC to exit the browse and type QUIT and RETURN to exit the toolbox Utility.
SEE ALSO:
-
Extension (Station) Utilities
-
-
Department Utilities
-
Division Utilities
-
Site Utilities
-
Call File Utilities
-
FAQ-1055 What is the File Layout of the Current Period (plm_ca.dbf)
-
RS-232 Serial Utilities
-
FAQ-1068 Standard Pinouts For a DB9 and DB25 RS-232 Serial Connection
-
Email Utilities
-
Other Utilities
-
FAQ-1192 Are there any required housekeeping issues with Call Accounting?
Comm One Call Accounting Software
Technical Support
PO Box 759 | 1390 E Meadow Valley Dr
Draper, UT 84020
(800) 771-9182
FAQ-1452 How to Delete Calls for a Year
Posted: 02/02/2017
Updated: 02/13/2021
Author: Comm One Technical Support