Application File Imports Release Notes Sync Web Services FAQ

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@smartbutton.com|0.00|50.00
10/10/2010 13:15:49|tom@smartbutton.com|19.44|50.00
10/10/2010 13:49:50|roger@smartbutton.com|32.00|75.00

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 © 2003-2018 Smart Button, an Aimia Company. All rights reserved.
What's new: Recently changed articles