Intended Application
Updates existing member property item data for one or more members.
Notes
- Header record is required. All data rows are processed as valid records.
- Any delimiter, except for [tab], can be used to separate columns. The delimiter used is then specified at the time of file import.
- For checkbox value types; 1, Y, YES = True (Checked) || 0, NO, N = FALSE (Unchecked)
- 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.
File Structure
|
DATA COLUMN |
DATA TYPE | DATA REQUIRED? | FORMATTING | NOTES |
|---|---|---|---|---|
| Member Property Item Id | Numeric | Yes | The member property item instance Id that is being updated. | |
|
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: |
PROPERTY_ITEM_ID|ACCOUNT_ID|RESIDENCE_TYPE|PROPERTY_NAME|SQUARE_FT|LOCATION_REGION|VALUE 1|1001|APARTMENT|Apartment 1|1200|1|300000 2|1001|RV|Joe's RV|500|1|65000 |
