Advanced Export (ttstpssiexp )

Use this session to specify the settings for advanced export of data to Excel.
Note: Session defaults that are saved in this session can be used automatically during a quick export. To achieve this, select the Use session defaults for quick export if present check box in the Excel Integration Settings (ttstpssidef) session.

Actions/Reference menu

These options are available:

Continue
Starts the export using the specified parameters.
Save Defaults

Saves the settings. Settings are saved by current user, the code of the session where the export was initiated, and current company.

.
Get Defaults
When this session starts, saved defaults are retrieved automatically. Click

Restores the settings that you saved with the Save Defaults command. If no defaults were saved, the settings are restored based on the generic export settings that you defined in the Excel Integration Settings (ttstpssidef) session.

If no generic settings are available, the settings are restored to the default field values.

Browse
Starts a dialog box where you can select a folder on the client PC where to store the file.

Related information

For details about the MS Excel integration, see the Infor LN UI User Guide.

Field Information

Export Settings
Rows

The rows that will be exported.

Allowed values

All All rows within the session will be exported.

Note

  • The active filter in the session is taken into account.
  • If you export data from a session where rows are displayed in groups (views), records of all groups are exported; not only records of the current group.
Visible All rows displayed on your screen will be exported.
View

DefaultThis option is only displayed if you export data from a session where rows are displayed in groups (views). For example, in the Subcontracted Operations (tisfc2110m000) session, operations are displayed per production order.

DefaultAll rows of the current group will be exported. For example, all operation rows of the current production order will be exported.

None No rows will be exported.
Fields

The fields to be exported

Allowed values

Current Tab All columns of the current tab will be exported.
All Tabs All columns of all tabs will be exported.
Predefined Set The columns that you selected in the Form Tabs (ttadv9310m000) session will be exported.

See also Sessions with sub sessions.

Options
Separate Date and Time Fields

If this check box is selected, the date and time fields in LN UI are exported to Excel as separate columns.

If this check box is cleared, date and time are combined in one column.

By default, this check box is cleared.

Add Title for Empty Column Headers

If the exported data contains child fields, this check box determines whether these child fields have column titles in the Excel sheet.

If this check box is selected, then each child field that was exported has a column title in the Excel sheet. The title consists of the name of the parent field followed by a suffix.

If this check box is cleared, then the exported child fields do not have column titles in the Excel sheet.

Exclude Additional Header Fields

If you export lines from a combined header-lines session, this check box determines whether fields from the header session are also exported. The header session is a Multi Main Table (MMT) session or a 360 dashboard.

If this check box is selected, only the lines are exported. No fields from the header session are exported to the Excel file.

If this check box is cleared, the lines and the header data are exported.

Open after export

This field indicates whether the file should be opened automatically after the export to Excel.

Allowed values

Yes After the export, the file is opened automatically in Excel.
No After the export, the file is not opened automatically.
Prompt You are prompted whether the exported file should be opened in Excel.
File location

The folder on the client PC where the file will be stored.

Specify a folder to which you have write access.

If you specify a folder that does not yet exist, you are prompted whether the folder should be created.