Application File Imports Release Notes Sync Web Services FAQ

Multiple Transaction & Location - Day Based Simple Transaction File with Details (Email)

Intended Application

For transaction importing in which a single file may contain transactions from multiple locations and/or multiple transaction types and the account Id used is an Email address.  Supports either retail amount->point conversion via ALP SaaS 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.
  • 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

 

Member Internal Id used in unique key.

Retail Value

Decimal Yes
0.00
 
Point Amount Decimal Yes
0.00
 
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|joet@smarbutton.com|14.93|0.00|FOOD|DELI2
10/10/2010 13:15:49|joet1@smarbutton.com|11.49|0.00|MERCH|BOOKST
10/10/2010 13:49:50|joet2@smarbutton.com|0.00|2.00|VISIT|STADIUM

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.
What's new: Recently changed articles