Xerox XCounter Page Accounting Support & Software User Guide

Page of 75
Mar 2001 
XCOUNTER FOR NT USER REFERENCE MANUAL 
 
63 
Database Functions 
• 
Remove deleted records - when client codes are deleted, the space is not 
reclaimed from the file. This operation compresses the file to eliminate space 
from deleted records and speeds up file load times, and also re-indexes the 
file. 
• 
Re-index - Refreshes the index for the database files. It is recommended that 
the database is re-indexed after importing multiple new entries. 
• 
Importing data - Files containing client code lists can easily be imported into 
xpopup.dbf. If a record already exists when importing, it will not be modified or 
overwritten. 
Importing Comma Delimited Text Files 
The importation of client and subcodes into the xpopup.dbf file is a two-step process. 
The client code must be imported prior to any subcodes being imported. To import a 
comma-delimited file, the following syntax must be adhered to. Each record occupies 
a single line in the file. The format of the client code importation should be: 
ClientCode,,Description 
• 
The client code is any alphanumeric character. The length of this field is a 
maximum of 20 characters. 
• 
The client code description field is optional and can be left blank. The length of 
this field is a maximum of 50 characters. 
Note: The field delimiter is the “,” when using the comma delimited file format.   
The format of the subcode importation should be: 
ClientCode,Subcode,Description 
• 
The client code is any alphanumeric character. The length of this field is a 
maximum of 20 characters. 
• 
The subcode is any alphanumeric character. The length of this field is a 
maximum of 20 characters. 
• 
The subcode description field is optional and can be left blank. The length of 
this field is a maximum of 50 characters. 
Note: Do not import a subcode record unless its associated client code record 
exists. It is recommended that the database be re-indexed after importing multiple 
records.