Managing Export Columns
Configure the export columns (data fields) for an export. Select the Header (first row), Data (repeating rows) or Footer (last row) to add columns. You can select a columns (fields) from the export data source or setup a custom formula column using the expression editor.
Adding Export Data Source Columns
To add a field from the data source.
-
From the OPERA Cloud menu, select Miscellaneous, select Exports, and select either General, Country, Membership, or Back Office.
-
Enter search criteria, then click Search.
-
Select the export definition in the search results, then click the vertical ellipsis Actions menu and select Columns.
-
Click New.
-
Column Type.
-
Select Use Existing Column.
-
-
Column Name: Select a column from the list.
-
Order By: Enter a number to indicate the sequence in the file.
-
Field Data Type: Select a data type from the list.
-
Header: Add column to first row.
-
Data: Add column to repeating row.
-
Footer: Add column to last row.
-
-
Default Value: Enter the value that is automatically inserted in the column.
-
Column Alignment: Select a value from the list.
-
Ignore Length: Select check box to have the field length varies depending on what data is stored in it.
-
Column Length: Enter a number to indicate the length of the field; for instance a character field can be 50 characters long.
-
Column Format: Enter a format mask if applicable, for example 'YYYYMMDD'. (Enabled for date fields).
-
-
Click Save.
Adding Export Pseudo Columns
To add a pseudo field.
-
From the OPERA Cloud menu, select Miscellaneous, select Exports, and select either General, Country, Membership, or Back Office.
-
Enter search criteria, then click Search.
-
Select the export definition in the search results, then click the vertical ellipsis Actions menu and select Columns.
-
Click New.
-
Column Type.
-
Select New Pseudo Column.
-
-
Column Name: Select a column from the list
-
Order By: Enter a number to indicate the sequence in the file.
-
Field Data Type: Select a data type from the list.
-
Header - Add column to first row
-
Data - Add column to repeating row
-
Footer - Add column to last row
-
-
Column Alignment: Select a value from the list
-
Ignore Length: Select check box to have the field length varies depending on what data is stored in it.
-
Column Length: Enter a number to indicate the length of the field; for instance a character field can be 50 characters long.
-
-
Click Save.
Adding Export Formula Columns
To add a formula (computed) field. For more information, see Export APIs.
-
From the OPERA Cloud menu, select Miscellaneous, select Exports, and select either General, Country, Membership, or Back Office.
- Enter search criteria, then click Search.
-
Select the export definition in the search results, then click the vertical ellipsis Actions menu and select Columns.
-
Click New.
-
Column Type.
-
Select Formula
-
-
Column Name: Select a column from the list
-
Order By: Enter a number to indicate the sequence in the file.
-
Field Data Type: Select a data type from the list.
-
Header - Add column to first row
-
Data - Add column to repeating row
-
Footer - Add column to last row
-
-
Default Value: Enter the value that is automatically inserted in the column.
-
Column Alignment: Select a value from the list
-
Ignore Length: Select check box to have the field length varies depending on what data is stored in it.
-
Column Length: Enter a number to indicate the length of the field; for instance a character field can be 50 characters long.
-
Formula: Click the pencil to launch the Using the Expression Editor.
-
-
Click Save.
Editing Export Columns
-
From the OPERA Cloud menu, select Miscellaneous, select Exports, and select either General, Country, Membership, or Back Office.
- Enter search criteria, then click Search.
-
Select the export definition in the search results, then click the vertical ellipsis Actions menu and select Columns.
-
Select Header, Data or Footer tab.
-
Select the column in the search result, then click the vertical ellipsis Actions menu and select Edit.
-
Update details.
-
Click Save.
Deleting Export Columns
-
From the OPERA Cloud menu, select Miscellaneous, select Exports, and select either General, Country, Membership, or Back Office.
- Enter search criteria, then click Search.
-
Select the export definition in the search results, then click the vertical ellipsis Actions menu and select Columns.
-
Select Header, Data or Footer tab.
-
Select the column in the search result, then click the vertical ellipsis Actions menu and select Delete.
-
Click Delete to confirm.
Parent topic: Managing Exports