(800) 771-9182

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

1. Close all programs

2. Open the Comm One Software Folder on the Desktop

3. Open the UTILITIES folder.

4. Double Click the TOOLBOX icon.  

5. 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.

Home | FAQ Home | Utilities | FAQ-1452

SEE ALSO
Scannex Buffer Utilities

• FAQ-1696 Scannex Memory Buffer Setup

• FAQ-1011 How to download calls from Scannex Buffer

Extension (Station) Utilities

• FAQ-1030 Make all Stations Active

• FAQ-1086 How Can I View The Structure Of The Station File?

• FAQ-1152 WIZARDS - Make All Station Names Upper Case

• FAQ-1153 WIZARDS - Make All Station Names Proper Case

• FAQ-1154 WIZARDS - Make All Stations Inactive

• FAQ-1174 WIZARDS - Replace All Names with Blank

• FAQ-1179 WIZARDS - Delete All Station Records

• FAQ-1182 WIZARDS - Copy All Stations to Excel XLS File

• FAQ-1186 WIZARDS - Copy All Stations to CSV File

• FAQ-1672 Extension/Station File CSV Import Utility

​

Department Utilities

• FAQ-1157 WIZARDS - Make All Department Names Upper Case

• FAQ-1158 WIZARDS - Make All Department Names Proper Case

• FAQ-1177 WIZARDS - Replace All Departments with Blank

• FAQ-1181 WIZARDS - Delete All Department Records

• FAQ-1188 WIZARDS - Copy All Departments to CSV File

• FAQ-1451 Build Dept (dept.dbf) from Stations (line1.dbf)
   

Division Utilities

• FAQ-1155 WIZARDS - Make All Division Names Upper Case

• FAQ-1156 WIZARDS - Make All Division Names Proper Case

• FAQ-1180 WIZARDS - Delete All Division Records 

• FAQ-1185 WIZARDS - Copy All Divisions Excel XLS File

• FAQ-1189 WIZARDS - Copy All Divisions Excel to CSV File
   

Site Utilities

• FAQ-1159 WIZARDS - Make All Site Names Upper Case

• ​FAQ-1160 WIZARDS - Make All Site Names Proper Case
• FAQ-1175 WIZARDS - Replace All Sites with Blank
  ​

Call File Utilities

• FAQ-1055 What is the File Layout of the Current Period (plm_ca.dbf) 

• FAQ-1165 WIZARDS - Zero Out All Call Costs

• FAQ-1166 WIZARDS - Zero Out All Long Distance Call Costs

• FAQ-1167 WIZARDS - Zero Out All Local Call Costs

• FAQ-1168 WIZARDS - Zero Out All Information Call Costs

• FAQ-1169 WIZARDS - Zero Out All Incoming Call Costs

• FAQ-1170 WIZARDS - Zero Out All International Call Costs

• FAQ-1171 WIZARDS - Zero Out All Toll-Free Costs

• FAQ-1178 WIZARDS - Delete All Call Records

• FAQ-1183 WIZARDS - Copy All Call Records to Excel XLS File

• FAQ-1187 WIZARDS - Copy All Call Records to CSV File

• FAQ-1452 How to Delete Calls for a Whole Year

RS-232 Serial Utilities

• FAQ-1068 Standard Pinouts For a DB9 and DB25 RS-232 Serial Connection

 
Email Utilities

• FAQ-1161 WIZARDS - Configure Email Account

Other Utilities

• FAQ-1190 WIZARDS - Modify Call Log Path Name

• FAQ-1192 Are there any required housekeeping issues with Call Accounting?

• FAQ-1262 How to enable Scheduled Task History

• FAQ-1302 How To Shutdown a PC from Remote Desktop

• FAQ-1688 How to Schedule Auto Reboot

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