Call Router Administrator
Setup Menu
Call Router Installation Guide 03/09
29
File Options
Create Result File – If selected, a results file will be stored in the same directory and have the
same name as the delete file except the filename will have a DER suffix (ex: OLDCUST.DER). The
results file is constructed so that the failed records are copied exactly as they were in the delete
file so that the results file can be used again once corrections are made. The format of the file is as
follows:
//Delete Results for file: xxxxxx
//Date: xx/xx/yy
//Time: hh:mm
..... individual Failed records
//Reason for Failure: ???????
...
//Count Successfully Deleted Records: x,xxx,xxx
//Count of Failed Delete Records: x,xxx,xxx
Miscellaneous Line Syntax
Like the import files, Comment Records can be imbedded in the delete files as well.
See the discussion above.
Field Definitions
The format of the delete records is as follows:
@@DELETE,<FieldName>,”<Field Value>“<CR><LF>
The system searches the database for the first match of the Field Value in the specific field,
and if the match occurs, then that record is deleted from the database.
The allowed Field Names are as follows:
CALLING_PHONE
CALLING_NAME
ACCOUNT
CALLED_PHONE
CALLED_NAME
Examples
An ASCII delete file might look like the following (the Carriage Return and Line Feed
indications would not normally be seen and are indicated here as a reminder that they must be
included):
@@DELETE,CALLING_PHONE,5054388032<CR><LF>
@@DELETE,CALLING_NAME,”Travis, William”<CR><LF>
@@DELETE,CALLING_NAME,Pretty Rugs<CR><LF>
@@DELETE,CALLING_PHONE,202<CR><LF>
@@DELETE,ACCOUNT,439866<CR><LF>