Xerox XCounter Page Accounting Support & Software Betriebsanweisung
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.
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.
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.
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:
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.
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.
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.
maximum of 20 characters.
•
The subcode is any alphanumeric character. The length of this field is a
maximum of 20 characters.
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.
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.
exists. It is recommended that the database be re-indexed after importing multiple
records.