Rooming List - Group Bookings
This is the fourth of eight tasks described in this user manual for changing booking details.
NOTE: The numbering is simply for reference - there is no particular order in which tasks need to be completed and, depending on the booking, they might not all be needed.
The full list is:
- General Setup - Group Bookings
- Pax Configurations - Group Bookings
- Pax Totals Group Bookings
- Rooming List - Group Bookings (this task)
- Markup / Commission - Group Bookings
- Booking Notes
- Agent Notes
- Recalculate Booking
The Rooming List screen allows Passenger Names to be entered against the booking, using the "Pax Names" option. Names can also be imported from a spreadsheet in a specific csv (comma separated values) format (see Lists tab - Importing pax names and details).
Names are assigned to Rooms and then to Lists and different lists can be created (e.g. for different itineraries or services) using List Configuration.
Pax tab - Entering pax names and details manually
There can be multiple Lists per booking for different booking combinations if required; e.g. per booking Itinerary, per Service Type etc. The following procedure describe how to enter pax names and details manually.
NOTE: It is also possible to import pax information from a csv file, which is described in Lists tab - Importing pax names and details.
Pax - Insert pax names and details
- Search for and retrieve a booking to work with. If you haven't done this already, see Retrieve an Existing Group Booking.
-
The default view for a booking is the
Dashboard View.
To create rooming lists with individual pax names and details, from the Groups menu, selectGroups > Booking Details > Rooming List.
-
Examine the
Rooming List (PAX) tab.
NOTE: There are three tabs available from the Rooming List screen: PAX, LISTS and SERVICES. The default view is the PAX tab and the list will be empty on first view of the rooming list for a booking.
-
Click
Insert to enter pax details.
-
On the
Pax Details screen, enter information about the first pax in this rooming list.
-
NOTE: This step is optional. Once a Surname is entered, the Insert button for the Contacts section becomes available:
-
Click the Contacts
Insert button to enter pax details.
-
On the
Insert Pax Travelling Contact screen, enter contact information for the current pax (the contact name is populated from the Pax Details screen).
-
Click
Save to keep the changes.
-
Click
Exit to discard any changes.
-
- On the Pax Details screen:
- Repeat steps 4 - 7 for additional pax in this rooming list.
About the Pax tab fields
Pax Name
Title (10 Chr), Forename (60 Chr), Surname (60 Chr)
The Save button becomes live once a Surname is entered.
NOTE: For individual pax names to be listed on various Tourplan generated documents such as vouchers, the names of each passenger must be entered here.
Pax Type (drop-down)
Choose the appropriate selection from the drop-down list.
Date of Birth, Age
Enter either Date of Birth (in day/month/year format) or Age.
NOTE:
- Product Database Age Policies are not validated in Groups. Any Date of Birth/Age is information only and can be output on documentation/messages etc.
- Ages can be entered as either Date of Birth or Age. When an Age is entered, the date of birth is calculated as the booking travel date less the age in years.
- If adult Dates of Birth are being entered, check that the DOB is not a date prior to the Years from/to as defined in Windows Settings. By default, Windows interprets 2 digit years as being between 1930 and 2029. If a DOB is entered which is prior to 1930, it is calculated as 100 years later; e.g. 1927 is calculated as 2027.
Client Email
Passenger email address.
Special Requirements
These four fields of 60 characters each are available to enter notes that are specific to the passenger.
Passport Details
The information stored in fields in the Passport Details section is self-explanatory.
Contacts
Contact details can be added for each passenger using the green Insert button as described in step 4 of Lists - Import a rooming list.
Contact Type
This is a drop-down list populated from data entered via menu Home > Code Setup > Messaging > Contact Type. Select the relevant type of contact.
Apart from Contact Type, the information stored in fields in the Contacts section is self-explanatory.
Lists tab - Importing pax names and details
Names can be imported from a csv (comma separated values) text file. For an example csv file, see About the Rooming List fields.
Lists - Import a rooming list
- Search for and retrieve a booking to work with. If you haven't done this already, see Retrieve an Existing Group Booking.
-
The default view for a booking is the
Dashboard View.
To import a rooming list from a csv file, from the Groups menu, selectGroups > Booking Details > Rooming List.
-
On the rooming list view, click the
LISTS tab.
NOTE: There are three tabs available from the Rooming List screen: PAX, LISTS and SERVICES. The default view is the PAX tab and the list will be empty on first view of the rooming list for a booking.
-
Click
Insert List to import a list.
-
On the
Insert Rooming List screen, click Upload....
-
Using the Windows Open dialogue box, browse to the location of the csv file, select it and click Open.
The example shows a list name called Import 1 ready to be imported.
If the csv file is not in the correct format or does not contain the correct data format, the file will not import and an error message appears (see About the Rooming List fields for information on the correct format for the csv file). -
Click Save to begin the import. An
Import Rooming List confirmation appears.
- Click Yes to import the file, or No to cancel the import.
-
When the import completes, the names are shown in a named
rooming list (where the list name is highlighted at left), comprising columns labelled Seq Key, Room, Description and Pax Names.
NOTE: When a subsequent new list is being inserted, an existing list can be copied by selecting it and clicking the Copy List button (in the screenshot above, the list selected is called Import 1).
-
Click the green Edit List button to show the
Rooming List in edit mode.
To edit a list entry, select the list item on the left-hand side of the screen and make the required changes to that entry using the fields on the right-hand side.
NOTE: If there is more than one entry to be changed, simply highlight the next entry without clicking Save in-between - click Save only when all required changes have been made to return to the Rooming List view.
About the Rooming List fields
Rooming list names can be imported from a CSV file. There is some flexibility with the format of the file but the first row must contain the column names. Valid column names are:
'Title' or 'Honorific'
'Forename'
'Surname'
'Pax Type'
'Room Key'
'Room Type'
'DOB', 'Birth Date' or 'Date of Birth'
'Age'
'Notes' or 'Notes1'
'Notes2'
'Notes3'
‘Notes4'
'Notes5'
'Passport Number'
'Passport Name'
'Passport Nationality' or 'Nationality'
'Passport Issued', 'Issued', 'Issued On' or 'Passport Issued On'
'Passport Place' or 'Passport Issued At'
'Passport Expiry', 'Expiry', 'Expires' or 'Passport Expires On'
NOTE: Current mandatory fields are Title, Forename, Surname and Pax Type.
Example 1
Room Key,Room Type,Title,Forename,Surname,Pax Type,Birth date,Passport Number,Notes,Notes2,Notes3,Notes4
1,SG,,,Fiona Eaves,,01/01/1980,,test,test2,test3,
2,SG,,,Janet King,,01/01/1980,,,,,
3,SG,,,Vickie Abel,,01/01/1980,,Vegetarian Meals,,,
4,SG,,,Sheila Lunn,,01/01/1980,,,,,
5,SG,,,Judith Nelson,,01/01/1980,,,,,
6,DB,,,Chris Little,,01/01/1980,,,,,
6,DB,,,Audrey Gregory,,01/01/1980,,,,,
7,TW,,,Susan Perkins,,01/01/1980,,Vegetarian meals,,,
7,TW,,,Marian Cooke,,01/01/1980,,,,,
Example 2
Room Type,Title,Forename,Surname,Pax Type,Birth date,Passport Number,Notes,Notes2,Notes3,Notes4
SG,,,Fiona Eaves,,01/01/1980,,test,test2,test3,
SG,,,Janet King,,01/01/1980,,,,,
SG,,,Vickie Abel,,01/01/1980,,Vegetarian Meals,,,
SG,,,Sheila Lunn,,01/01/1980,,,,,
SG,,,Judith Nelson,,01/01/1980,,,,,
DB,,,Chris Little,,01/01/1980,,,,,
DB,,,Audrey Gregory,,01/01/1980,,,,,
TW,,,Susan Perkins,,01/01/1980,,Vegetarian meals,,,
TW,,,Marian Cooke,,01/01/1980,,,,,
Sample CSV File
Room Key,Room Type,Title,Forename,Surname,Pax Type,Notes,Notes2,Notes3,Notes4
1,SG,Mr,Bill,Smith,A,,,,
2,SG,Ms,Harriet,Hopeful,A,,,,
3,SG,Miss,Helen,Robertson,A,,,,
4,SG,Mr,TBA,Escort,A,Tour Escort,,,
5,SG,Mrs,Robyn,Johnston,A,,,,
6,TW,Mr,Bob,Jones,A,,,,
6,TW,Mrs,Jill,Jones,A,,,,
7,TW,Mr,Rob,Wells,A,,,,
7,TW,Mr,Tom,Wells,A,,,,
8,TW,Mr,Pete,Wells,A,,,,
8,TW,Mr,Bill,Wells,A,,,,
9,TW,Mr,Graeme,Turner,A,,,,
9,TW,Mr,Harry,Beecham,A,,,,
10,TW,Mr,Ross,Howard,A,,,,
10,TW,Mr,Andrew,Simson,A,,,,
11,TW,Mr,Gary,Fussell,A,,,,
11,TW,Mr,Robert,Fussell,C,,,,
12,TW,Mr,Rashid,Hall,A,,,,
12,TW,Mr,Peter,Maddison,A,,,,
13,DB,Mr,Jack,Brown,A,,,,
13,DB,Mrs,Jackie,Brown,A,,,,
14,DB,Mr,Jim,Harris,A,,,,
14,DB,Mrs,Jess,Harris,A,,,,
15,DB,Mr,Fred,Blogg,A,,,,
15,DB,Mrs,Freda,Blogg,A,,,,
16,DB,Mr,Wayne,Saunders,A,,,,
16,DB,Ms,MaryAnne,Royce,A,,,,
17,DB,Mr,Donald,Rogers,A,,,,
17,DB,Mrs,Maureen,Rogers,A,,,,
Room keys can be added or edited after names have been imported.
Services tab - Attaching list configurations to services
This tab enables list configurations to be attached to services in the booking; i.e. assign a list of names to a service or multiple services.
In the example below, the objective is to tie the Import 1 list to most services that are in the Main Tour itinerary, and the Pre Accomm list to the services that are unique to the Pre Tour Accommodation itinerary.
Services - Attach list configurations to services
- Search for and retrieve a booking to work with. If you haven't done this already, see Retrieve an Existing Group Booking.
-
The default view for a booking is the
Dashboard View.
To attach a list configuration to booking services, from the Groups menu, selectGroups > Booking Details > Rooming List.
- Make sure at least two list configurations are available (see Lists - Import a rooming list).
-
On the rooming list view, click the
SERVICES tab.
The first list configuration created is selected by default (in this case Import 1), showing the services available to be attached.
NOTE: Services that are not tagged are available in all lists. Conversely, services that are tagged (i.e. have already been attached to a list) do not display for subsequent lists.
For example, the Pre Accomm list has only one tagged service, which does not appear in the Import 1 list. The other services available are not tagged and therefore are available in both this list and the Import 1 list.
-
Change the attachment of services for a list by clicking the Tag check-box alongside the service or use the Select All/Unselect All buttons.
ClickSave to save the list configuration.
-
Click
Discard to discard all changes.
NOTE: Both Save and Discard are dimmed-out until you make changes.
About the Services tab fields
Tag (Checkbox)
Tag (click) to select service to include the service(s) in the configuration list.
Select All/Unselect All
Use to select all services listed, or unselect services in bulk.
Day/Seq
The day number and sequence number of the service within the boooking.
Itinerary
The Itinerary Name that the service belongs to.
Product
The full product code of the service.
Description
The service description
Pax
The physical count of Adult pax on the service - including Escorts/Drivers/Guides.
SG/TW/DB/TR/QD
The breakdown of Pax Numbers by Room Type.
NOTE: Accommodation services display the number of Rooms by type. Non Accommodation per person priced services will show the number of Pax (Second Charge Units - SCU) in the TW column and will be net of any FOC quantities. Non Accommodation group priced services will show the number of SCU ("Tour", "Visit" etc) in the TW column.
Rooming list data can be output on messages and documentation. Details on the formatting and output of these message types are in the System Setup User Manual (Messaging section).