FAQ-1452 How to Delete Calls for a Whole Year

FEATURE DESCRIPTION

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.  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 2018 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) = "2018"
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 2018 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) = "2014"
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.

 

Comm One LLC Technical Support
138 E 12300 S Ste C102
Draper, UT 84020
385-529-5819
[email protected]

Contact Comm One
Visit the Comm One Call Accounting Web Page

Last Reviewed: 10/16/2017

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk