Rice Lake TransAct 3.5 - Manual (Page 74)

Admin Importing and Exporting Data
Version 3.5 75
TransactionTable
Ticket Number , Number , , , , ,
, Character ,1 , ,- , ,
Ticket Sequence , Number , , , , COMMA ,
The number of characters sent to the export file must be specified or the text will not be sent to the file.
The dash is only one character, therefore the field length is 1.
Example Number 2
This example will send the following to the export file...
Account,Ticket No. Ticket Number,Charge
101,Ticket No. 1453,150.50
TransactionTable
Account , Number , , , , COMMA ,
, Character ,11 , ,Ticket No. , SPACE ,
Ticket Number , Number , , , , COMMA ,
Charge , Number , ,2 , , NL ,
Example Number 3 - Boolean Values
By designating the second delimiter, Field Type , as Boolean, database fields can be used to export
True/False conditions of a Yes/No database field or fixed data depending on the value of a non- Yes/No
database field.
True/False Condition
Export values for true and false conditions are placed in the Fixed Value delimiter column, separated
by the “|” character.
Taxable , Boolean , , ,Yes|No , COMMA ,
When the Taxable database field is True , the word Yes is exported. When the Taxable database field is
False , the word No is exported.
Non True/False Conditions
Fixed data can also be exported depending on the value of a non-True/False database field. When used
with non-True/False database fields it is used as a compare value. To perform this function, another
field can be added to the
Fixed Value column for the boolean export type, again separated with the “|”
character. The third value is the compare value.
For example, the database field Charge Type uses the letter ‘ V ’ to designate a voided transaction. When
Charge Type is exported as a Character Field Type , the letter ‘ V ’ appears in the export file.
Charge Type , Character , , , , COMMA ,