Samples and Formats of Transaction Files from Clients

As explained above, clients agree to send Transaction files to TIBCO Reward in a format that is strictly defined. This format is the result of a careful needs analysis and a corresponding data mapping effort that identifies which of the client’s available data fields will be included in the transaction file supplied to TIBCO Reward.

The preferred format is an XML file corresponding to the requirements of the XSD schema (ISCLog.xsd).This file format is based on ARTS/IXRetail data model, and this is the preferred format for the Transaction files received from clients. TIBCO Reward can also transform Transaction files sent in other formats so that they can be used to supply the necessary transaction data. TIBCO Reward has extensive experience in performing such transformations.

Samples of some transaction files appear below. Each sample is followed by a corresponding table that shows the sample file format and its data formatting parameters.

Typically, a client company provides a sample file and a formatting table to indicate the data and formatting it will provide in its transactions files. The file format samples and tables convey information about the fields in their native file format. The client and TIBCO Reward must formally agree on the information provided in these tables, and TIBCO Reward must be able to use the sample files (after any agreed-upon transformations).

When a live Transaction file is imported by TIBCO Reward, any required transformations are performed automatically, based on the understanding that each transaction file will always follow the formatting guidelines established and documented in the tables. Each live file is transformed (as necessary) and ultimately processed as part of a TIBCO Reward ISCLog file.