Loyalty Member Custom Fields Update File

Intended Application

To update member custom field data for existing members.

Notes

Header record is expected. The first record will be skipped.
Custom fields must by represented by their external reference in the header, in the proper column position.
If custom field data is for a "list" type custom field, a semi-colon must be used to separate the items.
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.

File Structure

DATA COLUMN	DATA TYPE	DATA REQUIRED?	FORMATTING	NOTES
Account Id	Alphanumeric	Yes
Member Custom Field(s)	Varies	Yes

Sample File

In the file below, 'MemberType' and 'ExistedInLegacy' represent member custom fields.

                        
                                1:
2:
3:

                                AccountId|MemberType|ExistedInLegacy
1004|NP|Yes
1009|REF|No