Web Help
|
|
Home
Back
Forward
Contents
Index
Product Help
Support
Print
Feedback|
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.
- Run Excel in background mode: Select this option to hide data sheets for a cleaner, faster run.
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)
- 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 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.
- Default no. of records in Recent and Favorites: Limit or increase the number of records displayed on the home page.
- Skip field indicator: Type in the character you want to use as the default skip field indicator.
- 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 Error management and trace files GUI scripting and Windows scripting |
Trademarks
Winshuttle.com
Back to top
