Day Based Simple Transaction File with Details (Email)

Intended Application

For transaction importing in which the account Id will be an Email Address or an alphanumeric string and a single file will contain transactions from only one transaction type and a retail value or point amount is included in the file.

Notes

Any delimiter except for [tab] can be used to separate columns. The delimiter used is then specified at the time of file import or file upload template creation.
Header record is not expected. All data rows are processed as records.
Negative values are allowed.
Does not support ID Type Auto Ranges.

File Structure

DATA COLUMN	DATA TYPE	DATA REQUIRED?	FORMATTING	NOTES
Activity Timestamp*	Date/Time	Yes	MM/DD/YYYY HH:MM:SS	Based on a 24 hour clock
Account Id*	Alphanumeric(256)	Yes		Internal Member Id is used in unique key.
Retail Value	Decimal	Yes	0.00
Point Amount	Decimal	Yes	0.00

* - Denotes that the data column helps comprise the transaction unique key for this import file specification.

Sample File

                        
                                1:
2:
3:

                                10/10/2010 13:14:19|joe@kognitivloyalty.com|0.00|50.00
10/10/2010 13:15:49|tom@kognitivloyalty.com|19.44|50.00
10/10/2010 13:49:50|roger@kognitivloyalty.com|32.00|75.00