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 .
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 full reload of the cruise data should take place before the embarkation date |
|
Performs Full System Event Log |
Enable or disable if all events are to be written to the Event Viewer log If it is enabled, then all progress events will be entered in Windows event log. If it is disabled, progress events will not be entered and you will see the error and normal 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
| 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 CRUISE table if there is no cruise end date present in SPMS |
|
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 being 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 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 column in PASSENGER in which the SPMS data should be inserted. Parameter Validation |
|
2.4.3 TYP – Source Reference |
Optional, to turn off the reference field from TYP table, please put the empty/blank string. |
|
2.4.4 Source Length |
Custom Properties [2.4.4 Source Length (P)] Enter the data length which 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 column in PASSENGER in which the SPMS data should be inserted. |
|
2.5.3 Source Length |
Enter the data length which 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) |
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 to update 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. |