Guest Profile Import
- CSV
- UTF-8
- Separator ; (Semicolon)
- Record Spacer \n (New Line)
- Escape \ (Backslash) e.g. \; will escape a contained semicolon
- Quotes: no
- First record as header: yes
Field Name | Description |
|---|---|
ID | unique identifier - if another import contains the same ID, the record will be updated |
guestProfileId | in case you want to reference a specific guestProfile in the hotelsoftware to be updated (use hotelsoftware internal guest profile IDs only in this field) |
company | |
profession | |
title | |
firstName | |
lastName | |
gender | anything that starts with "m" or "M" will be considered Male anything that starts with "f", "F", "w" or "W" will be considered Female all other values will be considered Undeclared |
nationality | ISO 2-character country code |
language | ISO 2-chracter language code |
birthDate | any valid date (unparsable dates will be skipped on import) |
comment | |
street | |
city | |
zipCode | |
countryCode | ISO 2-character country code |
| |
phone | preferably in international format (e.g. +43 660 737 88 90) |
mobile | preferably in international format (e.g. +43 660 737 88 90) |
fax | preferably in international format (e.g. +43 660 737 88 90) |
newsletter | values of (case insensitive) "true", "y", "t", "on" or "yes" will be considered true |
categories | DO NOT USE |
relationships | DO NOT USE |
- dd.MM.yyyy
- dd/MM/yyyy
- yyyy-MM-dd
- dd-MM-yyyy
