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 |