5 Sample Process Messages

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


This figure shows the sample refresh interval messages logged by DGS.

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


This figure shows the sample messages of deleted reservation.

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


This figure shows the sample messages of records imported when the Stop Update On Embarkation Day is enabled.

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:

  • If the check box is selected and the guest with back to back booking has checked in:

    • It does not process or update the package plan be it new or of the same plan.

  • If the check box is deselected and the guest with back to back booking has checked in:

    • 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.

  • If the check box is selected/deselected for back to back booking due to arrive:

    • 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


This figure shows the QCI Synchronizer Status when when QCI Offline Sync is Enabled.

Figure 5-5 DGS Pause Mode


This figure shows the DGS Pause Mode when QCI Sync is running

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


This figure shows the sample import text for Do not import cruise SCR and only import cruise details of SCD.

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


This figure shows the sample message of UCIData when the parameter value of ‘Only Process UCIData With Account Check In Status’ is set to 0 and option is checked in the application.

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


This figure shows the sample message of the number of hours to retry decrypting the credit card information.

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


This figure shows the sample message of 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)

When this parameter is enabled, the application performs:

  1. A search based on ESE_EXTERNAL_ID + ESE_DATE.

  2. If the search returns no record, then the application searches the next record using the ESE_DATE + ESE_NO.

  3. If no result is yielded, the application reject the import and inserts an error, “tour code is not found” in the record.

  4. 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.

  5. If the search returns more than one record, then the application checks and matches the language in <EXCURSIONS_LANGUAGE> set during import.

  6. If no match is found, the application then searches the Account_Languages.

  7. 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


This figure shows the sample message of 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


This figure shows the sample Do Not Allow Import of Zero Price Shore Excursion, Prepaid Ticket/Prebook Transactions that has empty price value.

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


This figure shows the sample message of Update Cruise ID, Department ID, Net Price when the option is enabled.

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


This figure shows the 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


This figure shows the 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


This figure shows the sample message of Prevent Process Duplicate UCIData status that set to ‘Disabled’

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


This figure shows the sample messages for price change update in Shore Excursion, Ticket Bookable and Template, when enabled.

Additional Information

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


This figure shows the sample message of a lost connection retries

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


This figure shows the example of the location of the image 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.