Using the Runner add-in for Excel

Introducing Winshuttle RUNNER for TRANSACTION > The RUNNER Add-in for Excel > Using the Runner add-in for Excel

Back to

Using the Runner add-in for Excel

During the installation of RUNNER, the RUNNER add-in for Excel is installed automatically on your computer as an add-in in Excel.

NOTE: When you run an embedded TRANSACTION script, the data is uploaded from the active Excel sheet or from the sheet to which the script is bound, and not any other sheet specified in the embedded TRANSACTION script or any other TRANSACTION scripts linked to it.

The add-in allows you to run only data files. With the add-in, you can run multiple scripts that are attached to the data file and the carry settings are respected. The scripts run on the active sheet of the active data file. However, only the initial script will appear in the Runner window and does not update when each subsequent script in the script chain runs.

To view the RUNNER add-in pane

For Excel 2007, click the Winshuttle tab , and then click TRANSACTION.

-or-
For Excel 2003, click RUNNER Add-In.

Bind script

The bind script functionality has the following behaviors:

A script can run on the sheet it is bound to, but also on the active sheet.
A parent script runs either on the specified bound sheet or on the active sheet.
If the option carry sheet is on, the child script runs on the sheet on which parent file ran (Active sheet).
If the option Carry Sheet is off, the child script runs on the sheet specified in the script itself.
For backward compatibility, earlier published files run either on the active sheet or on the sheet that the parent script is bound to.

RUNNER add-in for Excel settings

Select TRANSACTION script: Available only if no published file exists in the Excel file. Click Browse and select the TRANSACTION script to open. You cannot type in the file path. See Loading an Existing Recording.

Select Published TRANSACTION script: If at least one published file exists in the Excel file, the list of the published TRANSACTION scripts appears. Select a file and its details appear automatically.

Run Rows

As specified below: Runs the rows as specified by the run settings below.

On Selected Run: Runs on rows that are currently selected in the active sheet. You can select multiple ranges of rows. Rows can be contiguous and non-contiguous selections.

On Filtered Run: Runs on rows that are obtained after applying filter on columns. This feature takes the data from the filtered rows only and not from the whole active sheet.

Start row and End row: Type the start row and end row. This is a run time setting and is not saved in the Excel sheet or in the published TRANSACTION script.

No. of rows: Displays the number of rows selected according to the start row and end row values you enter. This is a run time setting and is not saved in the Excel sheet or in the published TRANSACTION script.

Log Column: Type the Excel column where error messages are returned. The default is E. For more information, see Error Management.

Run Reason: Type a reason for the run. This is a run time setting and is not saved in the Excel sheet or in the published TRANSACTION script.

Run Options

Run Now: Use this option to execute the TRANSACTION script manually.

Run Later (Scheduling a Run): Use this setting to schedule an automated upload into SAP. For more information, see Scheduling a Run.

Run on Errors: Select this setting to re-run the TRANSACTION script for those rows of data (records) marked as errors only. After you correct any errors identified on the initial run, you can use Run on Errors to run the TRANSACTION script for the marked records only. When the TRANSACTION script is run initially, the errors are marked using the background color or a text indicator (default text is "Err:") for the Log column cells that contain messages returned from SAP. For more information, see Error Management.

Validating

You can validate data to ensure that there are no errors before you upload it.

To validate a data file

Click Validate. You are prompted to log on to a system.
Correct any errors or make changes, and then click Run to upload the data.

Run

Run Now: Use this option to execute the TRANSACTION script manually. If you are logged onto a system when you click Run or Validate, you’ll be logged off from the currently system and are required to log on again to a system to run the file.

Stop

Stop the run.

Write Headers

If no TRANSACTION scripts are published, you can open a .TxR file, and then click Write Headers write the header information for the mapped columns from the TRANSACTION script currently loaded in the add-in.

SAP Values (F4)

Select a cell, and then click SAP Values. F4 help, similar to one used in SAP, appears. In the SAP Values dialog box, use the check boxes to select multiple values. If the cell column is not mapped to any field or if no F4 help is available for the field, a message appears to tell you that no help or mapping is available.

If you are not already logged on to an SAP system, you are asked to log on to a system for which you want the F4 help. For subsequent F4 searches, you do not need to log on.

Status bar

This bar provides the logon information. It can also be used to log off from the currently logged in system.

Also in this section

Approving and rejecting from within Excel