Advance Tab

Previous  Top  Next

This tab provides advanced parameters to control your process. You can control how to interface with Excel, Control speed and delays on start and exit and finally manage connection to other files.

 

clip0004

 

 

Lock File: Setting this check box prevents any changes made to this file. All the controls are put in disabled state until you remove this lock again.

 

Settings: This settings help user assign locking options at various levels in a file.

 

advancetabb2

 

 

hmtoggle_plus1Excel Controls - Basic

  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.

 

  Close Excel after RUN: If you are using external Excel file, you can tell Process Runner to close the Excel at the end of the run

 

  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 all Data from Excel Sheet before each Run: This option will delete ALL the data from selected Excel before each run. This is useful when you are extracting data from SAP and want to clear all the previous data. Selecting this option will provide you a warning message to remind you that Process Runner will delete all the data from Excel Sheet.

 

  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.

 

clip0015

 

hmtoggle_plus1Excel Controls - Expert

    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 Fix Excel Cell value mapping.

 

clip0069

 

 

hmtoggle_plus1Start and Delays

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

 

  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.

 

  Repeat all the calls for: This option is special purpose option and is not generally available to end user. Using this option allows Process Runner to repeat the current run process nnnn number of times. Especially useful for load testing the SAP system.

 

clip0016

 

 

hmtoggle_plus1Process Connection

  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 a local file

 

  EShare (Server File ): Indicates if  you want to connect file 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(s).

 

  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.

 

advancetabb6

 

 

 

See Also

Home | Mapper | iBook | Notes | Scheduler | Start Page