Advanced Export (ttstpssiexp )

Use this 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

"MS Excel integration" in the Infor Ming.le-LN Plug-in - User Guide (LN UI) (U9791)

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 (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 also 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.

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.

Export

Exits the dialog and starts the export using the specified parameters.

Browse

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

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.