Creating or Editing a Back Office Export File
Creating a Back Office Export
-
From the OPERA Cloud menu, select Miscellaneous, select Exports, and then select Back Office.
-
Click the vertical ellipsis and select New.
-
On the Create New Export screen, select a property for the export, select the file type you want to export, and click Continue.
Note:
You must select a file type based on the back office system that receives the data. For example, if you are exporting revenue data to a SCALA interface, you select SCALA_REVENUE to generate your export. To view file types for legacy back office exports, you must activate the General Export OPERA Control.
-
In the Details section for the export, verify the information is correct for the export file. If you need to make changes to this information, click the vertical ellipsis and click Edit. You can edit the following fields:
-
File Type: The name of the export.
-
Description: The long description of the export.
-
File Name from Columns: The name of the ASCII export file that is created when the export is generated; the SQL formulas in this field define the name. You can change these formulas by selecting a different column name.
-
File Extension Formula: This formula creates the file extension for the export.
-
Zip File Name: The file name if exporting a zip file. You can select a predefined file name.
-
Parameter Form: The name of the parameter form used to generate the manual export. This field sets the controls for manually generated exports and is not required if a pre-export procedure is defined; however, this can vary depending on the definition of the export. Each pre-export procedure has a unique parameter form.
-
Export Contents Configuration: Select one of the following: Always Export Header and Footer (select to generate an export file that contains only header and footer information), Compress Data (select to delimit the column data in the export file), Add Newline (select to have each record on a separate line in the ASCII text file), or Inactive (select to make the file type inactive).
-
Configure for Automatic Export: Select Night Audit Export if you want to generate the export during the night audit. Select the Frequency that the export file is generated.
-
-
Click the Columns link, all of the columns in the export are listed. To add additional columns, click the vertical ellipsis button and select New.
-
Click the Definitions link. You have the option to add a custom definition for the export by clicking the vertical ellipsis button and selecting New.
Editing a Back Office Export
- From the OPERA Cloud menu, select Miscellaneous, select Exports, and then select Back Office.
- Enter a Property and click Search.
- Select the file type you want to edit in the search results, click the vertical ellipsis next to it, and click Edit.
- To edit the details of the export configuration, refer to step 4 in the above procedure.
- Click Save to save your changes or click Cancel to close the screen without saving changes.
Parent topic: Back Office Exports