2 Configuration of the SWTOSPMS Template
The SWTOSPMS Template is required to import cruise, passenger, crew, and group data from SPMS to SilverWhere.
This section describes how to configure the different areas within the SWTOSPMS Template to meet operational needs.
WARNING:
Changing any of the template settings may have an adverse impact on the ship’s operation. Consult Support and Consulting team for more information before proceeding.Note:
The different parts of the SWTOSPMS Template can be turned on or off by checking or unchecking the main function, for example, disabling 1.0 will disable all the sub-functions.
If you wish to import package information from SPMS to SilverWhere, grant SELECT object privilege to the FIDELIO.PPP and FIDELIO.PPN database tables for bkstg_dining.
General Functionalities
Table 2-1 General
Function | Description |
---|---|
Ship |
Enter the ship code (SHIP.SHIP_CODE) |
Number of Future Cruises To load |
Enter the number of cruises to import and update from SPMS |
Do a full reload X number of days before cruise starts |
Enter the number of days when a complete reload of the cruise data should take place before the embarkation date |
Performs Full System Event Log |
Enable if all events are to be written to the Event Viewer log All progress events will be entered in the Windows event log if enabled. If it is disabled, progress events will not be entered and you will see the error and regular activity log like thread terminated and others. This only applies if you have registered the GDF Template previously. |
Log Error into Database |
Enable or disable if errors should be written to the BKSTG_DINING.LOG table |
Updating Cruise from SPMS Functionalities
Table 2-2 Updating Cruise from SPMS Functionalities
Function | Description |
---|---|
1.0 Updating Cruise from SPMS |
|
1.0.1 Number of Cruise Days To extract |
Enter the number of cruise days to retrieve from SPMS, taking into account the value in the Number of Future Cruises To Load |
1.0.2 Cruise Format to import |
Enter the date format of the CRUISE.CRUISE_ID, for example, ‘yyyy-MM-dd’ |
1.0.3 Cruise Type to import |
Enter one of the below codes for the Cruise Type:
|
1.0.4 Segment Rule |
Select a Segment rule from the drop-down menu if the value in [1.0.3 Cruise Type to import] is S for Segment |
1.0.5 Pre-populate Debark Date if NULL presented |
Select the method of how the cruise should be inserted into the CRUISE table if there is no cruise end date present in SPMS |
1.0.6 Number of Old Cruise Days to delete |
Enter the number of old cruise days that should be deleted |
1.0.6.1 Include CREW Table Records |
Enable to delete the crew data from the database |
1.1 Copy Cruise Dining Room/ Table from Ship |
Enable this if you use Classic Dining onboard. |
1.1.1 Seat Time 1 |
Enter the time of the first seating. |
1.1.2 Seat Time 2 |
Enter the time of the second seating. |
1.2 Copy Cruise Availability from Template |
Enable if Alternative Dining is used onboard. |
1.3 Copy Cruise Server from Ship |
Enable to retrieve the crew data from SPMS for Classic Dining. |
1.3.1 Get Cruise Server from Last Cruise first |
Enable if server records should be duplicated from the last cruise. |
1.3.2 List of Server to add |
Enter the OPO_IDs of the positions that should be retrieved from SPMS, separated with a comma. |
1.4 Copy Cruise Itinerary from SPMS |
Enable if the itinerary details are retrieved from SPMS. |
Updating Passenger from SPMS Functionalities
Table 2-3 Updating Passenger from SPMS
Function | Description |
---|---|
2.0 Updating Passenger from SPMS |
Enable to retrieve the passenger data from SPMS. If a passenger record exists, perform an update. Otherwise a new passenger record will be created. |
2.0.1 Force update Passenger’s Group ID |
Enable to retrieve the GROUP_ID from SPMS |
2.0.2 Update Priorities Levels |
Enter the number of priority levels to retrieve from SPMS (from 1-5) |
2.0.3 Identity ID for Passenger ID |
Select the ID to use as a unique identifier for the passenger:
|
2.0.4 Extract From Base RES_STATUS |
Enter the RES_STATUS (e.g. CC,CL,DD) to retrieve from SPMS, separated with a comma. Used for the current cruise |
2.0.5 Extract From Future RES_STATUS |
Enter the RES_STATUS (e.g. RR,RE,RN,RX) to retrieve from SPMS, separated with a comma. Used for future cruises |
2.1 Copy Passenger’s Special Request from SPMS |
Enable if you want to retrieve the Special Requests from SPMS |
2.1.1 Copy Special Request from Fidelio.AME |
Enable this to retrieve the Special Requests from the FIDELIO.AME table. |
2.1.2 Copy Special Request from Fidelio.SRT |
Enable this to retrieve the Special Requests from the FIDELIO.SRT table. |
2.2 Passenger Add Description |
Enter the description to use for data that was added by the GDF, e.g. ‘Fidelio Add’ |
2.3 Import Passenger Award Level |
Enable this to retrieve the Passenger Award information from SPMS |
2.3.1 SPMS table.column |
The column name can be set from the RES or UXP table for a single column name. |
2.3.2 Source Length |
To avoid the field length error, specify the proper field length. Default 0 means no substring is required. |
2.4 Import Loyalty Status from SPMS |
Enable this to retrieve the Loyalty Status information from SPMS |
2.4.1 Source |
The column name can be set from RES or UXP table for a single column name. |
2.4.2 Destination |
Enter the PASSENGER column where SPMS data should be inserted. Parameter Validation |
2.4.3 TYP - Source Reference |
Optional. To turn off the reference field from the TYP table, use the empty/blank string. |
2.4.4 Source Length |
Enter the data length that should be inserted. |
2.5 Import FLEX-SEATING from SPMS |
Enable this to retrieve the Flex Seating information from SPMS |
2.5.1 Source |
The column name can be set from RES or UXP table for a single column name. |
2.5.2 Destination |
Enter the PASSENGER column where the SPMS data should be inserted. |
2.5.3 Source Length |
Enter the data length that should be inserted. |
2.6 Update Cruise Group Seating |
Enable to generate entries for the groups in the CRUISE_GROUP_SEATING and CRUISE_GROUP_LIMIT tables (required for the Group Management module) |
2.7 Importing Port Information of Passenger Embarkation |
Enable this to retrieve the passengers' embarkation port from SPMS |
2.7.1 Destination |
Enter the PASSENGER column where the data should be inserted. |
2.8 Importing Port Information of Passenger Disembarkation |
Enable this to retrieve the passengers’ disembarkation port from SPMS |
2.8.1 Destination |
Enter the PASSENGER column where the data should be inserted. |
2.9 Importing Meal Package Information |
Enable this to retrieve the meal packages from SPMS |
2.9.1 List Of Package Codes to Import |
Enter the PPN_IDs of the packages that should be retrieved from SPMS, separated with a comma. |
2.9.2 Destination |
Enter the PASSENGER column where the data should be inserted. |
2.10 Importing Beverage Package Information |
Enable this to retrieve the beverage packages from SPMS |
2.10.1 List of Package Codes to Import |
Enter the PPN_IDs of the packages that should be retrieved from SPMS, separated with a comma. |
2.10.2 Destination |
Enter the PASSENGER column where the data should be inserted |
Updating Crew from SPMS Functionalities
Table 2-4 Updating Crew from SPMS
Function | Description |
---|---|
3.0 Updating Crew from SPMS |
Enable this to retrieve the crew data from SPMS for Alternative Dining. |
3.1 List of Crew’s Position to Import |
Enter the OPO_IDs of the positions that should be retrieved from SPMS, separated with a comma |
Updating Cruise Group From SPMS Functionalities
Table 2-5 Updating Cruise Group from SPMS
Function | Description |
---|---|
4.0 Updating Cruise Group from SPMS |
Enable this to update the group data for this cruise from SPMS. |
4.1 Extract from RES_STATUS |
Enter the RES_STATUS (e.g. RR, RE, CC, CL) that should be retrieved from SPMS, separated with a comma. |
Updating Passenger Type Functionality
Table 2-6 Updating Passenger Type
Function | Description |
---|---|
5.0 Updating Passenger Type |
Enable the update of the passenger type based on the gender and age of the passengers sharing a cabin. |
Updating SPMS’s Reservation From SilverWhere Functionalities
Table 2-7 Updating SPMS’s Reservation From SilverWhere
Function | Description |
---|---|
6.0 Updating SPMS’s Reservation from SilverWhere |
Enable this if you are using Classic Dining and RES shall be updated with the dining assignment information from PASSENGER. |
6.1 Is Flex Dining |
Enable this if the FLEX_SEATING column is used. |
Updating Passenger Seating by Party Functionality
Table 2-8 Updating Passenger Seating by Party Functionality
Function | Description |
---|---|
7.0 Updating Passenger Seating by Party |
Enable to update the requested seating if the passenger is assigned to a party. |
Updating Passenger Seating by Cabin Functionality
Table 2-9 Updating Passenger Seating by Cabin Functionality
Function | Description |
---|---|
8.0 Updating Passenger Seating by Cabin |
Enable to update the requested passenger seating grouped by cabin |