To be successfully imported through a CSV file, the column headings for these preferences should be:
- Bathroom Min*
- Bathroom Max*
* The following upper and lower case variations are also accepted: Bathroom Min, Bath Min, Bathmin, BathroomsMin, Bathrooms Min.
If these are not successfully matched during the Verify stage of an upload, you can manually match them.
To be successfully imported through a CSV file, the data for Minimum and/or Maximum Bathroom preferences should be written as numbers only, for example: 2
Decimals used to indicate half bathrooms, e.g: 2.5, are also supported.
These values should exclude:
- Text, e.g: Two
- Commas, e.g: 2,3
- Other symbols, e.g: dollar signs
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 (e.g: just the Bathroom 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.