To be successfully imported through a CSV file, the column headings for these preferences should be:
- Bedroom Min*
- Bedroom Max*
* The following upper and lower case variations are also accepted: Min Bathrooms, Bath Min, BathMin, Bathrooms Min, BathroomsMin, Baths Min. Max Bathrooms, Bath Max, Bathmax, Bathrooms Max, BathroomsMax, Baths Max.
If these are not successfully matched during the Verify stage of an upload, you can manually match them.
The individual data for Minimum and/or Maximum Bedroom preferences should be written as numbers only,
for example: 4
It should exclude:
- Text, e.g: Four
- Commas, e.g: 4,5*
- Decimal points, e.g: 4.5
- Dollar signs
* Only one value can be recorded per data cell.
If the data in your file is not compatible, you will either see the incompatibility error, and be asked to ignore the column, or the individual data cell will be skipped and noted in your Import Overview (e.g: just the Bedroom max preference for the applicable contact/s will be unrecorded, not the contact/preference in entirety).
When both Min and Max values are recorded
Additionally, if both Min and Max values are recorded, the Max must exceed the Min value.
If it does not, both cells will be skipped.
If both Min and Max values are recorded, but there is an error in one, e.g: text is used, only the cell with the error will be skipped, and the valid value will be imported.
You can download details of your skipped cells, correct the formatting in your CSV file and re-upload it to successfully record this data.