Application File Imports Release Notes Sync Web Services FAQ

Multiple Transaction & Location - Day Based Simple Transaction File With Details and Transaction Custom Fields

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 ALP SaaS transaction point formula, and also direct point entry in file.

 

Notes

  • Any delimiter, except for a semi-colon and [tab], can be used to separate columns.  The delimiter used is then specified at the time of file import.
  • For checkbox value types; 1, Y, YES = True (Checked) || 0, NO, N = FALSE (Unchecked).
  • Header record is expected.  The first record will not be treated as data.
  • Negative values in either the retail value or point amount columns will result in an error.
  • If custom field data is supplied, the appropriate custom field external reference must be referenced in the header, in the appropriate column position(s).
  • 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(60)

Yes

 

 

Retail Value

Decimal Yes 0.00  
Point Amount Decimal Yes 0.00  
Transaction Translation Id Alphanumeric Yes    
Location External Reference Alphanumeric Yes    
Transaction Custom Field(s) Varies No    

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

 

Sample File

1:
2:
3:
4:
TIMESTAMP|ACCOUNTID|RETAIL|POINT|TRANSID|LOCEXTREF|CASHIERID
10/10/2010 13:14:19|joet@smarbutton.com|14.93|0.00|FOOD|DELI2|333
10/10/2010 13:15:49|joet1@smarbutton.com|11.49|0.00|MERCH|BOOKST|232
10/10/2010 13:49:50|joet2@smarbutton.com|0.00|2.00|VISIT|STADIUM|233

Aimia Logo

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

Tags:
Home: Aimia Loyalty Platform SaaS Wiki Copyright © 2019 Aimia Inc. All Rights Reserved.