Intended Application
To populate member reward custom field data for an already issued reward, matching on the reward barcode.
Notes
- Header record is expected. The first record will be skipped.
- If custom field data is for a "list", "multi-checkbox", or "address" type custom field, a semi-colon must be used to separate the items.
- Multi-checkbox custom field values can only be enabled, not disabled.
- If an invalid parameter for a "dropdown" custom field is imported, any existing value for this field will be removed.
- For checkbox value types; 1, Y, YES = True (Checked) || 0, NO, N = FALSE (Unchecked).
- 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.
- Has the ability to update this information for canceled and redeemed rewards.
File Structure
|
DATA COLUMN |
DATA TYPE | DATA REQUIRED? | FORMATTING | NOTES |
|---|---|---|---|---|
|
Reward Barcode |
Alphanumeric |
Yes |
|
|
| Member Reward Custom Field(s) | Varies | Yes | Custom Field External Reference(s) are needed in header in proper position. |
Sample File
1: 2: |
REWARD_BARCODE|SHIP_ADDRESS 200391|NA;300 MAIN ST;APT 4;ELKTON;MD;21921;US |
