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 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.
- Does not support ID Type Auto Ranges.
- 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(256) | 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|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 |
