2 Configuring DGS ResOnline

This section describes the configuration of DGS ResOnline Interface.

Setting Up the Parameter

  1. Login to DGS ResOnline and navigate to Settings tab.

  2. Select the sub-tab and select the relative option check boxes.

  3. Click Apply to save.

  4. Restart the application for the changes to take effect.

Setting Up Alert Email List

The Alert e-mail List notifies users listed in the alert list of the changes made to the reservation. This requires set ups in Administration module.

Setting Up Email Server

  1. Login to Administration module and select System Setup, Database Parameter from the drop-down menu.

  2. In the Database Parameters Setup window, available Parameters are grouped by the function groups. Click the plus‘+’ key to expand the group and select, or use the Quick Search section to look up. Enter the parameter name ‘Promo’ in Group/Name field and then click Search.

    Figure 2-1 Email Server Parameters


    This figure shows the parameters used to set up an email server for alerts.
  3. Enter the information in the following parameters and click Apply at each of the parameter.

    • SMTP Server IP Address: Enter the email server IP address.

    • SMTP Server IP Port: Enter the email server port. Default port value is 25.

    • SMTP Server Require Login Authentication: Set the Value to 1 if it requires login authentication.

    • SMTP User Name: Enter a valid email user account for login

    • SMTP User Password: Enter the password for the email user account

  4. Exit the program when the update is completed.

Inserting Email Alert Report Template Script

The email alert uses a report template to send the alert and this templates are uploaded using an SQL script.

  1. Open the Command Prompt with Run as Administrator

  2. At the command line, type SQLPLUS and then press the Enter key.

  3. Enter the SQL System user name and password.

  4. At the SQL command-line, enter the following command @”<file location + file name”. For example @”C:\temp\ResOnline Email Alert.sql”.

  5. Press the Enter key to execute the script, and close the SQL command and the Command Prompt.

Uploading Email Alert Report Template

  1. Login to Administration module and select System Setup, Report Setup from the drop-down menu.

  2. At the Current Reports List, ResOnline group, right-click, and select Add Report.

  3. Navigate to select Upload New Report (Load Variables From the Report Template) or Upload Report and then search for the .RPT file on your local drive, if you are uploading a report template.

  4. In the Report Details section, enter the following:

    1. Report ID: Unique ID of customized report.

    2. Report File Name: Crystal Report file name, for example, testreport.rpt.

    3. Report Title: Report name to show in Current Report List.

    4. Report Access: User Access allowed to view/print the report.

    5. Report Sort: Sort order of the report within the assigned report group.

    6. Report Group: Group this report belongs to. Select from the drop down menu.

    7. Report Comments: Additional comments/information pertaining to this report.

    Figure 2-2 Report Setup Details


    This figure shows the report details section in Report setup window.

  5. At the Print Default section, select the printer type and print orientation from the drop-down list, and then enter the number of copies to print.

  6. Click Save to add the report to the list, and OK at the Save New Report prompt. The newly loaded report template is shown.

Setting Up Email Alert List

Figure 2-3 Email Alert Report Linking


This figure shows the Email Alert Report Linking window.

  1. Login to DGS ResOnline and go to Settings, Alert e-Mail List tab.

  2. Click the Add New button to insert a report entry.

  3. Insert the Report ID from report setup into Report Template ID and add the Mailing List and Display Name in the grid. Use a semicolon “;” to separate multiple email address, if any.

  4. Click the Apply button to save the changes.

  5. Repeat the steps above to add more report alerts for other department. The Alert E-Mail Template settings are save to AlertEMail.xml in Public Documents folder C:\Users\Public\Documents\Oracle Hospitality Cruise.

  6. The Alert e-Mail sent is based on the parameter stored in OHCSettings.par [#Res Online Data Import.Parameter.LastSendRspID=xxxxxx#] that references to the ID of last sent alert.

  7. Copy the OHCSettings.par from the Oracle Hospitality Cruise folder of the ResOnline Interface PC to the new PC that you intend to run DGS ResOnline application. If the [#Res Online Data Import.Parameter.LastSendRspID=xxxxxx#] on the next PC is reset or starts from zero, the application then resend all previously sent alert.

Setting Up Email Alert Mapping Field

Besides configuring the e-Mail server and adding the user email accounts to the alert list, you are also required to define the trigger fields for alerts in ResOnline Viewer. See ResOnline Viewer User Guide- Configuring a View with Field Mappings section for details.

Setting Up Pre-Posting Quantity to Unit Price

This parameter enables the display of imported prepaid posting amount to be shown as unit price x quantity in the guest invoice. To use this parameter, an additional setting in Administration module is required, and the Multiply Pre-Posting Quantity to Unit Price is checked in DGS ResOnline.
  1. Login to Administration module and select System Setup, Database Parameter from the drop-down menu.
  2. In the Database Parameters Setup window, available Parameters are grouped by function group. Click the plus (+) key to expand the group and select, or enter the parameter name ‘General’ in Group/Name field and then click theSearch button.
  3. Select the Default Prepaid System Account and insert the credit department code in the value field. The credit department code must start with an ‘S’. For example: S9185 for Prepaid account.
  4. Click the Apply button to save the changes.

Enabling ‘Log Changes into chglog’

If the change log parameter is checked in DGS ResOnline, you are require to define the change log trigger fields in OHC Tools.exe. See Tools User Guide to setup the mapping fields.

DGS Prioritization

The application supports prioritization of data to import by record sequence of a bigger value first and then the NULL value last. The sequence value here refers to the XML file where ‘RESERVATION_MSGS > PRIORITY_VALUE’.