Below are some of the process messages based on the parameters defined.
Sample XML File Format
Below is the sample information of the XML file.
<DataSetReservations> <MESSAGE__TYPE> <MSSG_CONTENT></MSSG_CONTENT> <MSSG_XFRSHIP></MSSG_XFRSHIP> <RESERVATION> <RESERVATION_RCDID></RESERVATION_RCDID> <RESERVATION_XFRSHIP></RESERVATION_XFRSHIP> <RESERVATION_XFRSTATUS></RESERVATION_XFRSTATUS> <RESERVATION_RCDMODDATE></RESERVATION_RCDMODDATE> <RESERVATION_RES_ID></RESERVATION_RES_ID> <RESERVATION_PAX_GUID></RESERVATION_PAX_GUID> <RESERVATION_TYPE></RESERVATION_TYPE> <RESERVATION_CABIN></RESERVATION_CABIN> <RESERVATION_CABIN_SHARING></RESERVATION_CABIN_SHARING> <RESERVATION_STATUS></RESERVATION_STATUS> <RESERVATION_EMBARK></RESERVATION_EMBARK> <RESERVATION_DEBARK></RESERVATION_DEBARK> <RESERVATION_BOOKINGNO1></RESERVATION_BOOKINGNO1> <RESERVATION_BOOKINGCODE></RESERVATION_BOOKINGCODE> <RESERVATION_BOOKINGDATE></RESERVATION_BOOKINGDATE> <RESERVATION_V_GUESTID></RESERVATION_V_GUESTID> <RESERVATION_VIP></RESERVATION_VIP> <RESERVATION_GROUP_ID></RESERVATION_GROUP_ID> <RESERVATION_ACATEGORY></RESERVATION_ACATEGORY> <RESERVATION_PCATEGORY></RESERVATION_PCATEGORY> <RESERVATION_PRODUCT></RESERVATION_PRODUCT> <RESERVATION_PREPRODUCT></RESERVATION_PREPRODUCT> <RESERVATION_CRUISE_FARE></RESERVATION_CRUISE_FARE> <RESERVATION_TRAVEL_TYPE></RESERVATION_TRAVEL_TYPE> <RESERVATION_PPD_TAG></RESERVATION_PPD_TAG> <RESERVATION_OPERATOR></RESERVATION_OPERATOR> <RESERVATION_AGENTID></RESERVATION_AGENTID> <RESERVATION_CREDITLIMIT></RESERVATION_CREDITLIMIT> <RESERVATION_EMBARKPORTCODE></RESERVATION_EMBARKPORTCODE> <RESERVATION_DEBARKPORTCODE></RESERVATION_DEBARKPORTCODE>
Refresh Interval
Figure 5–1 below shows the system constantly checks for new records to process every 60 seconds or per a defined interval time.
Figure 5-1 Sample Refresh Interval Messages
Delete reservation data older than 60 Days
In the Messages tab, data older than 60 days from the date of modification is removed.
Figure 5-2 Sample Deleted Reservation Message
Stop update on embarkation day
A message “Update Disable for current embarkation date after x:xx:xx” is added to the ResOnline Data Import log file, when the Stop Update on Embarkation parameter is enabled or when a value is inserted into the field.
Figure 5-3 Sample Stop update on embarkation day message
Log SQL statement
The system logs an SQL statement into a log file in C:\Users\Public\Documents\Oracle Hospitality Cruise\ResOnlineDataImportYYYYMMDD.txt
if you have the Log SQL Statement checked in Parameter1. You can view the statement from the Debug tab.
Do not update package after guest check-in (B2B)
This parameter updates the booking records based on the selection of the check box.as described in the following:
It does not process or update the package plan be it new or of the same plan.
It processes and creates a new package plan when new plan is send in and prompts ‘No Changes’ if the plan is the same as previous and without changes.
It creates a new package plan when a new plan is sent in and prompts ‘No Changes’ if the plan is the same as previous and without changes.
Stop process when QCI Offline Sync is enabled
This parameter backs up and restores the latest database to the QCI Shore Database when the parameter is enabled and the QCI Sync Interface is started.
At the point when Quick Check In Synchronizer Ship database mode is in an Enabled status in Offline Mode, the DGS ResOnline Interface status switches to a Pause and resumes when the Offline Mode is Disabled.
Figure 5-4 QCI Synchronization Status
Figure 5-5 DGS Pause Mode
Do not import cruise (SCR), only import cruise details (SCD)
When this parameter is enabled, the system only imports the cruise details excluding the cruise date.
Figure 5-6 Sample Do Not Import Cruise Details Messages
Only process UCIData with account check in status = 0
Below is the sample message of UCIData when the parameter value of ‘Only Process UCIData With Account Check In Status’ is set to 0 and the option is checked in the application.
Figure 5-7 Sample Message of Only Process UCIData With Account Check In Status
Number of hours to retry process credit card info
If this parameter is enabled and the Pretty Good Privacy (PGP) Credit number fails to decrypt during the import process, the application will retry to process with the credit card information stored in the credit card buffer based on the hours defined in the parameter.
Figure 5-8 Sample Retry Processing Credit Card Info Messages
Stop Reservation Update x Days Before Embarkation
This parameter stops the import of reservation updates based on the number of days defined in the parameter and logs a fail message, ‘Expected Embark date must be x day(s) after the system date.’
For example, the number of days defined before embarkation is three and record with embark date less than or equal to three days after the system date are not imported
Figure 5-9 Sample mMessage on Stop Reservation Update x Days Before Embarkation
Enable Shore Excursion Language Import
This parameter allows import of excursion booking by Language to prevent the overbooking of tour buses/guide. It applies to the same bookable tour with a different language (ESE_LANGUAGE) and with same external ID (ESE_EXTERNAL_ID)
A search based on ESE_EXTERNAL_ID + ESE_DATE.
If the search returns no record, then the application searches the next record using the ESE_DATE + ESE_NO.
If no result is yielded, the application reject the import and inserts an error, “tour code is not found” in the record.
If the search returns a record, then the tour code is inserted into the excursion booking table (EPO), regardless of the language set in ESE_LANGUAGES
field.
If the search returns more than one record, then the application checks and matches the language in <EXCURSIONS_LANGUAGE>
set during import.
If no match is found, the application then searches the Account_Languages
.
If it still does not return a matching result, the program then inserts the booking into the first bookable excursion.
Enable Over Weight Bookings Price Increase
This parameter triggers a price increase based on the value set up in Shore Excursion, Overweight Price Increase (either in Value or Percentage). When the import is processing, the system updates the price Gross Price in Shore Excursion. The price increase is based on the EXCURSION_EXTRA_SEAT
value set to “W” in the XML file.
Allow Update Flights for Check-In Guest
This parameter disables users from adding, deleting or editing the flight information in the Management and Crew, Flight Information function, and sets it to view only. When the parameter is checked, importing of flight information including checked-in guest is allowed.
Figure 5-10 Sample Allow Update Flights for Check-In Guest
Do not allow Import Zero Price Shorex/Ticket Prepaid/Prebook Transactions
When this parameter is checked, the system checks for prepaid records that have an empty price in the XML file, and rejects the import and then sets status=Fail.
Figure 5-11 Sample messages Do Not Allow Import Zero Price From Shorex/Ticket Prepaid/Prebook Transactions
Only Update Cruise ID, Department, Net Price and Sales Price For Excursion/Ticket
The system only updates the cruise ID, department, net price, and sales price for excursion when the parameter is selected, and no other changes shall take place. The example below shows the price value has been updated.
Figure 5-12 Sample message of Update Cruise ID, Department ID, Net Price
Allow Change Excursion/Ticket Date for the same tour
When this parameter is turned on and a date change is made to the same excursion, the system does not create a new booking but update the excursion date with new date sent by the interface.
When the data is sent with the same EPO_VID, ESE_ID=EPO_ESE_ID
with different booking date, the EPO_ESE_ID and EPO_SDAT
the updated the same record.
Figure 5-13 Sample message of Allow Change Excursion/Ticket Date
Validate ENOAD Data
This parameter validates ENOAD data during import and inserts an import warning if the ENOAD data is found to be missing. You can view the data validation warning from ResOnline Viewer.exe under Import Warning
Allow Update Value to Null
This parameter updates the existing data to null, excluding fields that do not allow null.
Figure 5-14 Sample message of Allow Update Value To Null
Prevent Process Duplicate UCIData
When this parameter is enabled, the system processes the latest UCIData records and ignore the earlier records if multiple records were sent for the same guest. If the parameter is disabled, the system processes all records for the same guest.
Figure 5-15 Sample message of Disabled Prevent Process Duplicate UCIData
Allow Field Update for B2B Guest > Embarkation Date
This parameter updates the disembarkation date according to the XML file for guest with back to back bookings that are checked-in. When the expected disembarkation date of the checked-in guest in the XML file is greater than current cruise end date, the system creates the second record. You can view the details of the imported messages with the ResOnline Viewer
Interval to Send Alert e-Mail
This parameter triggers an alert e-mail to the the user based on the Alert e-Mail list defined in Setting Up Alert Email List. If the system finds a record that matches the settings during an import process, a report is generated and sent to the respective user. A message also appears in the Message tab with “xxxxxx Generating Report-ShorexAlertEmail”, followed by “xxxxxx Sending eMail to Shorex Booking (xxxx)”
Enable Update of Shorex/Ticket Bookable and Template
This parameter checks and updates the bookable records x days before the next cruise. For example a price change from 300 to 150 is set in Shore Excursion. During import, the application checks the date to Stop Bookable Update, and updates the price accordingly to the future cruises, where applicable.
This change is reflected in the Shore Excursion, Pricing & Sales tab.
This change also affects the shore excursion bookable and template, and is only applicable to a future cruise. You cannot change the current cruise shore excursion bookable and template.
Figure 5-16 Sample Price Update on Shore Excursion, Ticket Bookable and Template
The following section describes some functional features that run in the background.
Connection Lost Retry 10 Times
When a connection is lost, the interface attempts to reconnect and display an error message ‘Error – DB is down’ in ResOnline Message tab after the 10th retries.
Figure 5-17 Sample message of Lost Connection Retry
Assuming the Refresh Interval is set at 60 seconds and the DB down time hits 300, this closes the application.
The application prompts a command prompt screen when it restarts and closes the command prompt screen after the application restarts completely.
Prevent Application from Running Multiple Times from Different PC
This handling is added to prevent the application from being started at multiple locations. It prompts a message on screen when the application is started from another location. An allowance of 60 seconds is added before the application can be closes.
The system adds an ‘Error’ entry to the Message tab with date and time stamped, and the location mentioned in the Description section. For example, “xxxxxxxx DGS ResOnline.exe is running at workstation xxxxxx”
Guest Picture Import
The application supports importing a guest picture from an XML file, inserting the value into the MSSG_GUEST_HISTORY
field, and stores the picture in the SEC
table. The picture cannot be updated after the guest checks-in.
Figure 5-18 Sample picture string in XML file format
Import Guest History
The application supports importing guest history for analysis purpose and this includes transactions, item details, shore excursion booking, amenities, and special requests.
When the XML content is uploaded and updates the RESERVATION_MSGS.MSSG_CONTENT
and RESERVATION_MSGS.MSSG_GUEST_HISTORY
of the guest, the history value and request are shown in Management, Guest Handling, Guest History tab and Service Info tab respectively. The service request can be copied into the current cruise. See Management User Guide on how to copy the service request.
Insert EST_LANGUAGES to ESE_LANGUAGES
When the ESE_LANGUAGES
is empty during import, the application replaces the value into this field when EST_NO=ESE_NO
.