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

Multiple Transaction & Location - Day Based Simple Transaction File with Details

Intended Application

For transaction importing in which a single file may contain transactions from multiple locations and/or multiple transaction types.  Supports either retail amount->point conversion via Kognitiv Loyalty transaction point formula, and also direct point entry in 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.
  • Header record is not expected.  All data rows are processed as records.
  • Negative values in either the retail value or point amount columns will result in an error.
  • Standard point adjustment transaction type is not supported.

 

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.0  
Point Amount Decimal Yes 0.0  
Transaction Translation Id Alphanumeric Yes    
Location External Reference Alphanumeric Yes    

* - 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|14.93|0.00|FOOD|DELI2
10/10/2010 13:15:49|1003|11.49|0.00|MERCH|BOOKST
10/10/2010 13:49:50|1004|0.00|2.00|VISIT|STADIUM

Kognitiv Logo

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

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