Sales & Catering Export File Details

To display the Sales & Catering Export File List screen, select Configuration>External>Sales & Catering>Export Files (available when the Sales & Catering Interface License Code OPP ESM is marked as active). OPERA's pre-defined export files are automatically generated during the End of Day Routine. These are placed in the folder defined from the interface defaults. OPERA automatically creates the Transmit (Input)subfolder under the master folder you have defined.

Export File Location - General Information

The location of the directory where OPERA export files are stored is defined in the default_<schema>.env file environment variable (default_brisbane.env), FORMS90_OUTOUT. At installation, this variable is set to D:\micros\opera\export. Use oappcfged.exe to make configuration changes.

As an alternative to mapped drives, UNC (Universal Naming Convention) network share paths (e.g., \\app_server1\micros\opera\export) are also supported. This is also applicable for the zipping of the export files if the zip file name is defined in the export file details.

Search Criteria

File Type. Choose a specific file type to display in the grid. Then, you can select that file to edit or verify its contents.

Property. When the OPP_MHOT OPERA Property Management Multi-Property Base add-on license is active, select the down arrow to choose a Property from the list of values.

Show Inactive. Mark this checkbox to display the inactive files in addition to the active ones.

Search Results Grid

File Type. Displays the file type that meets the search criteria.

Description. Displays a full description of the file type.

The following are examples of files/descriptions that are displayed in the search results grid.

S&C Internal ID

OPERA File Name

OPERA File Type



Allotment Checkout Export



Allotment Detail Export



Allotment Comparison Export



Allotment Future Group Export



Allotment Header Export



Allotment in House Groups Export



Allotment Reservation Export



Allotment Availability Info Export


Search. Select the Search button to begin the search for the file type you selected in the previous field. The results are displayed in the grid.

Generate. Start the export data generation, see Export Files for generation details.

View Data. View the export data which has already been created, see View Export Data for details.

Copy. Copy the highlighted file type. OPERA lets you copy a pre-defined file type to simplify the process of configuring a new one. At the Copy File Type screen either keep the displayed default (the highlighted file type from the previous screen) or, select a file type from the list of values. Then, type in a new file name in the To File Type field and enter the new file type description.

New. Create a new export setup.

Edit. The Export File Details screen resembles the New Export File screen. Since OPERA offers pre-defined file types, there is really no need to edit them. However, you do have the option of verifying the information and making changes, if or when necessary.

Delete. Delete the highlighted file type. You are prompted to select Yes or No to confirm. It is not recommended to delete a pre-defined file type. To delete an export file type from the system, highlight the file type from the Export File List and select the Delete button. Answer Yes to the message, "Do you want to Delete File Type <xxx>".

Close. Exit the screen.

Export File Details Screen

Once again these files are pre-defined, which means you need not be concerned about the file layouts. You can verify and make changes to the files if necessary. From the Export File List screen, choose a file and select New to create an export file or Edit to go to the Edit screen and make the necessary verifications and changes.

Provide the following information and select the OK button.

File Type. Name of the export. To create a new file type, select New from the Export File List and enter a new file type name for the export.

File Description. Long description of the file type.

Export Source. Select the down arrow to choose from a list of available views for the export procedure.

Source Description. This description is automatically populated when the Export Source view is selected.

Pre Export Procedure. This internal procedure executes before the data export is done.

Post Export Procedure. This internal procedure executes after the data export is done.

Parameter Form. This form is commonly used for exports that can be manually generated. The parameter form takes the required input from the user and generates a manual export. One example of a required parameter is the date range for which the export needs to be run. Each pre-export procedure has a unique, hard-coded parameter form.

Note: Normally, when the parameter form is used, the pre-export procedure need not be used. However, this varies depending on the definition of the export.

Night Audit Export. Check this box if the export is to be run during the night audit.

Frequency. When the Night Audit Export check box is checked, select the down arrow to set the frequency of how often the export is to be run during the night audit process. For instance, Daily, End of month, End of Year, or Weekly.

HTTP Upload. Select this option to upload the export via HTTP using an OXI interface. This file can be uploaded and transferred to the HTTP address automatically using the night audit. Also, the export file HTTP upload is available on demand and can be transferred manually to allow for more up to the minute information.

Note: If the export is configured to run during the night audit and the HTTP transmission fails, the night audit will continue to run to complete the End of Day report. However, an error message will display in the naweather.rdf report to notify the user of the transmission failure. Since this report is not mandatory, properties using the HTTP transmission must configure the report.

HTTP Address. When the HTTP Address check box is selected, type the database HTTP address where the export file will be uploaded to.

Filter Condition. This field allows you to enter a condition to filter the export by. The default for this option, is to leave this field blank and export all data. However, if only a certain type of data is required, then a condition can be entered in this field.

Note: Technically, a filter condition is the where clause in a select statement. Take for example a market codes statistics export. If only certain market codes statistics are required, like FIT, COM and IND, then the condition Market code IN (FIT,COM,IND) can be entered; where Market Code would be one of the column names in the Export source view/table.

Export Columns. When defining Export Columns for a new export, select this button and a multi-select list of values displays. Choose the columns you wish to configure for this export, then select OK to display the Export Columns Details screen. These steps only occur when setting up a new export. If the columns are already defined, then the option Export Columns will list out the columns, which have been selected.

Note: To enable the Export Columns option button when creating a new export, you must first save your changes to the current export.

File Name Formula. Enter the name of the ASCII export file to be created when the option to generate file is selected from the from the Export File List screen. This field can accept SQL formulae so that the file name can include dates or other program specific export information.

For example:

First5Characters of Property Code +Current System Month+F

would be

SUBSTR(property code,5)||MM||F

When you click the list of values box, a list of all the columns defined in the Export Source View/Table display. These are the columns that can be used to create the File Name Formula. The name of the ASCII text file can be made from any of these values or can also be any string of characters. If the file must be called WY P296, then enter 'WY P296' (the single quotes are necessary). If the file must depend on the business date of the property, then enter the following, for example:


which would give the name WY1103EXP for a business date of November 3.

File Extension Formula. Used to create any file extension for the daily export. This field can accept SQL statements so that the extension can include dates or other program specific export information (Current System Month +Day MM||DD). Examples for the file extension name would be TXT or EXP. The single quotes are necessary.

Zip File Name. The name of the zipfile if the export files are to be compressed. To make use of this functionality, the EXPORT_ZIP_NA parameter must be filled in with the zip program name. The Zip Program name parameter EXPORT_ZIP_NA is already configured in Setup>Application Settings>Exports. The Zip Program name (executable file) must be present in the \RUNTIMES directory.

Note: In order for zipping of export files to work correctly (e.g., automatic zipping of night audit files when the End of Day>End of Day Reports to be Zipped parameter is set to Y), the environment variable setting must use a mapped drive letter on the application server and may not use a UNC (Universal Naming Convention) path. This is a limitation of PKZIP, a DOS utility, which does not recognize UNC pathing. For example, the path could be D:\MICROS\OPERA\EXPORT but may not be \\<machinename>\MICROS\OPERA\EXPORT. Sites using UNC pathing may employ OS folder compression in lieu of zipping.

Compress Data. Select this checkbox to compress all records in the export file. This would be used for delimited ASCII text files. The delimiter can be entered in the box given.

Col. Separator. Displays when the Compress Data check box is selected. Select Space, Tab, Comma, or Enter (CRLF or carriage return line feed) option as the character column separator. The data column is delimited by the selected character that follows it.

Always Export Header and Footer. Based on the export setup, if no data has been generated within the export and both a header and footer is defined with a file name given in the export setup, OPERA will always generate the export file that contains no information other than the header and the footer.

Inactive. Mark this check box to make a file type Active or Inactive. If the box is checked, the file type will be Inactive. If the box is not checked the file type will be Active. This box is unchecked by default.

Add Newline. Check this box to have each record displayed on a separate line in the ASCII text file.

Component Export. Check this box to add additional exports as components of one primary export.

Components. Available when the Components Export check box is checked.

See Also