Application defaults

New features in TRANSACTION version 10.6/10.7 > Setting up for use > Application defaults

Back to

Application defaults

Use Application Defaults to set the defaults for the TRANSACTION application:

On the Main Menu, click Tools, and then click Options to display the Options dialog box with the Application Defaults active.
You can also click Application Defaults on the left side of the Options dialog box at any time to display the Applications Defaults.

The Application Defaults settings contain:

Path defaults

You can either click the (folder icon) on the right to browse to the default file location you want to select, or type any of the default file paths. These paths indicate where specified types of TRANSACTION files are stored, including the data source files (Excel or Access), script files (.TxR extension), Log files, and Auto Logon (ALF) files.

The defaults values are:

Excel/Access files: C:\Documents and Settings\<user name>\MyDocuments\Winshuttle\Transaction\Data
TRANSACTION scripts: C:\Documents and Settings\<user name>\MyDocuments\Winshuttle\Transaction\Scripts
Log files: C:\Documents and Settings\<user name>\MyDocuments\Winshuttle\Transaction\Log
Auto Logon (ALF) files: C:\Documents and Settings\<user name>\MyDocuments\Winshuttle\Transaction\ALF

Microsoft Excel defaults

Enter the Excel worksheet default values:

Sheet name: Default Excel sheet to use when running your script file (default is Sheet 1).
Log column: Default Excel column where error messages are returned (default is E). For more information, see “Error Management”.
Enable RUNNER Excel Add-in: Select this to ensure that the RUNNER add-in appears in Excel.
Use Excel Spreadsheet in the mapper preview: This setting allows you to toggle between the new Excel preview and the legacy preview. The Excel preview provides faster preview loading, a cleaner Excel-like interface, capability to map more than 256 columns, and a view of graphic and formatted data. This setting should be cleared only in consultation with Winshuttle support and ensure that you are not in the mapper when you enable the setting.
NOTE: Make sure the column you assign for the log results is empty. TRANSACTION overwrites any data in the specified Log column with the transaction log results.

Data read preferences

Select how TRANSACTION interprets Excel data using either of the available formats: As stored (internally) or As displayed (the default). For example, the actual stored internal value in column C is 2.146, while this value is displayed as 2.15. If you select the As stored setting, it is read as 2.146. However, if you select the As displayed setting, it is read as 2.15. This is the value that is passed to SAP.

NOTE: You must make sure that the SAP field that is mapped to this column matches the format of the data in the Excel spreadsheet, as well as your Data read preferences. For example, when the SAP field is formatted to accept only two decimal places, and you are passing a number containing more than two decimal places, an error message is displayed.

Usage defaults

Enter the Excel worksheet usage defaults:

No. of rows to remain empty before TRANSACTION stops: Use this value to determine the number of consecutive empty rows allowed before the run stops automatically. For example, if the default is set to 5 (the default), TRANSACTION automatically stops running after it processes five consecutive empty rows.
Trim data before uploading into your SAP System: Select this check box to remove the leading and trailing spaces from the data read before uploading into your SAP system.

Also in this section

SAP defaults

Auto update

Error management and trace files

Auto logon

Production Server Warning (Prod. Svr. Warning)

Client connection settings

Header log details

Restore defaults

GUI scripting and Windows scripting

Enable GUI scripting

Unicode implementation for TRANSACTION scripts