Advanced Tab

This settings help user assign locking options at various levels in a file. Click here to know more on the options provided in the Lock Settings window.

Enabling this feature in Process Runner will disable all the operations of Process Runner which are related to SAP. It switches into mode where only custom codes and scripts viz. VB Script, JAVA Script and VB.Net Script can be executed.

•VB Script: Select this radio button if a custom VB Script is to be indulged and executed as a process file.

•Java Script: Select this radio button if a custom Java Script is to be indulged and executed as a process file.

•VB.Net Script: Select this radio button if a custom VB.Net Script is to be indulged and executed as a process file.

•Insert Sample Code: User can also fill the code area with a sample code by clicking on this option.

Once the custom code is inserted. Click on 'OK' to save the same.

•Save Excel: Controls how Excel file will be saved

•At the end of run: Save Excel at end of each run

•Do not Save: Do not save Excel file

•Save at Every nnn Calls: Save Excel at every nnnn calls. This is useful if you have very large Excel file and you want to save the changes at every few calls.

•Execute only filtered rows: Tells Process Runner to look at only filtered rows. Any rows hidden by current filter will NOT be processed when this option is selected.

•Clear data from Excel Sheet before each Run: If enabled data will be deleted from the worksheet before the Run starts without any warning.

•Clear All Data: The data in entire excel sheet will be deleted before the Run starts. Please note formulas in the current excel sheet will also be removed.

•Clear only SAP to Excel (download) columns: All the data in these columns will be deleted before run starts.

▪From 1st Row: The  SAP to Excel column data in excel sheet will be deleted starting from the first row before the Run starts.

▪From Start Row: The data in excel sheet for these columns starting from the start row specified in Home tab will be deleted before the Run starts. Data will not be cleared from rows (Start row -1, Start row -2,....,2,1).

•Write header to Excel: This option writes header information to Excel at the end of each run. Useful if you are requesting fields from SAP to Excel as this option will write what these fields are.

•Read Excel Cell Values: This controls how Process Runner interprets values stored in Excel. For example, you may have a cell value of 1.25, which may be displayed as 1.3 if you have rounded to one decimal point. Using this option, you are telling Process Runner to use values "As Displayed" i.e. 1.3 or "As Internally Stored" i.e. 1.25. Default is "As Displayed".

•Blank Row threshold for stopping: This value controls how many blank rows should Process Runner check before automatically stopping.

•Filter Excel rows where column: This works as global IF statement. If you want to ignore row based on certain value in Excel row, specify that condition here and Process Runner will skip those rows where these condition is met.

•Disable Mapped field if Mapped value in Excel Cell is: This advance option will disable (not send) SAP fields when certain condition is met.

•Vertical Transaction Repeater: It allows you  to automatically replicate transaction calls by changing value of one vertical cell i.e. column. This process enables smart mapping of vertically placed data from many columns. You will have to provide a start column, which must be mapped for VTR to work. When application executes a call to a transaction, first call will be made using excel values from this start column. In subsequent calls, value of this start excel column will be replaced by the value of excel cells from the next column, all other mapping values will NOT be changed. This process will be repeated  till the last column is reached. This option is generally useful for condition and period records where everything else remains the same and only period data changes. Works with Excel to SAP and Excel Cell Value mapping.

•Exclude hidden columns: Enabling this check box will skip the hidden columns in VTR processing.

•Run on open: Selecting this options forces Process Runner to run this file as soon as you open it.

      Note: You can also run the process file through Command Prompt or Scheduler.

      Click here , to know how to run process file through Command Prompt.

      Click here , to know how to run process file using Scheduler.

•Exit after Run:Selecting this option will force Process Runner to close itself down once run is over. Usually used for periodic Scheduled run.

•Delay before start: You can specify how many second should Process Runner wait before running once it's has started. This option is useful when you Schedule Process Runner runs.

•Delay between calls: Tells Process Runner how many seconds to wait between each calls. This is to intentionally slow Process Runner down.

•Enable Pre and Post run external process: Enabling this setting allows to run any external programs or scripts before or after each run.You can do the necessary settings in following screen by clicking “Pre/Post Run Process…” button. Click here to know more on this feature.

•Suppress status bar and Excel message at run time: Enabling this option will improve the performance while using parallel processing. process Runner will not show the detailed message in status bar and write messages to Excel at run time.

•Stop further processing on first error: Enabling this option will stop the further processing if it encounters any error.

•Enable Connection: Select this check box to enable connection to another process and specify name or ID of Process Runner file that you want to connect. This file will also be executed if you run the current file.

•Local File:  Indicates if you want to connect to a local file residing on your local machine

•EShare (Server File ): Indicates if  you want to connect file residing on EShare server. In this case, you will have to provide EShare File ID.

Use following Settings for ALL Downstream Connections

•Current Excel / iBook: Tells Process Runner to use Excel/iBook as mentioned in current file and ignore this value from all downstream connected file.

•Current Sheet: Tells Process Runner to use Sheet as mentioned in current file and ignore this value from all downstream connected file(s).

•Current Start Row value: Tells Process Runner to use value of Start Row as mentioned in current file and ignore this value from all downstream connected file(s).

•Current End Row value: Tells Process Runner to use value of End Row as mentioned in current file and ignore this value from all downstream connected file(s).

•Re Open current file after Run process is finished: Tells Process Runner to re-open current file once all the follow on files are processed successfully. Please note if there are any errors during the run, Process Runner will stop on that file and will not open the master (current) file. So this settings is only effective if there are no errors during the run.

•Current Logon/Shortcut Information: Checking this option will use the current logon or logon shortcut information in all the downstream processes.

•Stop further processing on first error: Checking this option stops Process Runner from further processing if it encounters an error.

How-To Videos:

1.VA01 Linked with VL01N

2.Business Transactions using Linked/Chained process files right from Excel

3.Linked/Chained process files MM01 CS01 CA01 right from Excel