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.
1. Column Type.
  1. Select Use Existing Column.
2. Column Name: Select a column from the list.
3. Order By: Enter a number to indicate the sequence in the file.
4. Field Data Type: Select a data type from the list.
  1. Header: Add column to first row.
  2. Data: Add column to repeating row.
  3. Footer: Add column to last row.
5. Default Value: Enter the value that is automatically inserted in the column.
6. Column Alignment: Select a value from the list.
7. Ignore Length: Select check box to have the field length varies depending on what data is stored in it.
8. Column Length: Enter a number to indicate the length of the field; for instance a character field can be 50 characters long.
9. 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.
1. Column Type.
  1. Select New Pseudo Column.
2. Column Name: Select a column from the list
3. Order By: Enter a number to indicate the sequence in the file.
4. Field Data Type: Select a data type from the list.
  1. Header - Add column to first row
  2. Data - Add column to repeating row
  3. Footer - Add column to last row
5. Column Alignment: Select a value from the list
6. Ignore Length: Select check box to have the field length varies depending on what data is stored in it.
7. 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.
1. Column Type.
  1. Select Formula
2. Column Name: Select a column from the list
3. Order By: Enter a number to indicate the sequence in the file.
4. Field Data Type: Select a data type from the list.
  1. Header - Add column to first row
  2. Data - Add column to repeating row
  3. Footer - Add column to last row
5. Default Value: Enter the value that is automatically inserted in the column.
6. Column Alignment: Select a value from the list
7. Ignore Length: Select check box to have the field length varies depending on what data is stored in it.
8. Column Length: Enter a number to indicate the length of the field; for instance a character field can be 50 characters long.
9. 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.