Application File Imports Release Notes Sync Web Services FAQ

Member Property Creation File

Intended Application

Creates new member property items for one or more members.
 

Notes

  • Header record is required.  All data rows are processed as valid records.
  • 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

Internal Member Id

Alphanumeric

Yes

 

 
Member Property Item External Reference Alphanumeric Yes    
Member Property Name Alphanumeric Yes   The "name" of this property instance.
Member Property Custom Field External Reference Alphanumeric Yes   Field external reference in header, values in data rows.

 

 

Sample File

1:
2:
3:
ACCOUNT_ID|RESIDENCE_TYPE|PROPERTY_NAME|SQUARE_FT|LOCATION_REGION|VALUE
1001|APARTMENT|Apartment 1|1200|1|300000
1001|RV|Joe's RV|500|1|65000

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