| Advanced Export (ttstpssiexp) |  |
| use.session.to specify the settings for advanced export of data to Excel. To start the export using the specified parameters, click Continue. To save the settings as defaults for the session where the export was initiated, click Save Defaults. When this session starts, saved defaults are retrieved automatically. See Get Defaults. 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. Related topics Exporting data from LN sessions to MS Excel
Fields | Description
Rows | The rows that will be exported. Allowed values
All | All rows within the session will be exported.
Visible | All rows displayed on your screen will be exported.
View | This option is only displayed if you export data from a session where rows are displayed in groups (views). For example, in the Subcontracted Operations by Order (tisfc2110m000) session, operations are displayed per production order. All 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 Executing an advanced export.
INCLUDE: Sessions with sub sessions
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. If you specify a folder that does not yet exist, you are prompted whether the folder should be created.
Commands | Description
Continue | Exits the dialog and starts the export using the specified parameters.
Browse | Starts a dialog where you can select a folder on the web client.
Save Defaults | Saves the settings. Settings are saved by current user, the code of the session where the export was initiated, and current company. To restore the saved defaults, use the Get Defaults command.
Get Defaults | 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.