The rooming list can also be imported from an Excel sheet.
To obtain a template for the reservation, containing the basic data and the required format, call up the context menu on the reservation and select template rooming list import. It is recommended to store the templates in a pre-defined folder in the SIHOT-Path. Templates are always created in csv-format and to save the file, you can use the suggested name or enter a new name.
Figure 39: Creating a template
Open the file in Excel and complete the rooming list entries. Note the following points:
•If there are already some names on the rooming list in SIHOT, these will be taken over automatically in the Excel sheet.
•Use one line per guest. Sharers are always entered in the sequence of the list.
•If you enter more names than reserved in SIHOT, the last ones will not be imported.
•If you enter fewer names than reserved in SIHOT, the remaining names will be generated automatically. I.e. either with the client’s name or with a default name as per registry key [8146].
•The columns title and Address (salutation) in the Excel sheet must contain the exact terms as per the combobox.
•Existing guest profiles of repeat guests are identified by their email address. Other factors are not taken into consideration. Should SIHOT find an identical email address, then data of the existing guest profile will override any diverging data of the Excel sheet.
Import the data of the Excel sheet as follows:
•Via context menu, select the command rooming list import.
•Drag & drop the Excel sheet from its directory into the tab reservation information.
Any existing data in the rooming list listbox will be overridden with the data from the Excel sheet.
Figure 40: Rooming list import