Advanced Export (ttstpssiexp )
Actions/Reference menu
These options are available:
- Starts the export using the specified parameters.
Saves the settings. Settings are saved by current user, the code of the session where the export was initiated, and current company.
.- 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.
- 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.