Home Inspire Application File Imports Release Notes Sync Web Services FAQ Search

Day Based Simple Transaction File with Details

Intended Application

For transaction importing in which 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 will result in processing errors.
  • Records containing potentially dangerous sequence of characters and commands used in cross-site scripting attacks may be rejected.

 

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(20)

Yes

 

 
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|1001|0.00|50.00
10/10/2010 13:15:49|1003|19.44|50.00
10/10/2010 13:49:50|1004|32.00|75.00

Kognitiv Logo

Please note: All external Kognitiv Loyalty links and references are directed to US datacenter unless specifically noted.

Tags:
Home: Kognitiv Loyalty © 2023 Kognitiv Corporation. All Rights Reserved.