Chapter1: Running a Process file using command line

Chapter1: Running a Process file using command line

This section provides the information about running a Process file using command line.

To run Process file using command line

1.Open the Command Prompt window.

2.Go to the folder containing the ProR.exe file and run the following command:

“<ProR.exe>” “<PathToProcessfile>” [“|AutoRun=<True/False>”] [“|LogonFile=<LogonShortcutFile>”] [“|SilentMode=<True/False>”] [“|ExcelFile=<ExcelDataFile>”] [“|SheetName=<ExcelSheetName>”] [“|StartRow=<StartRow>”] [“|EndRow=<EndRow>”] [“|CloseExcel=<True/False>”] [“|SessionID=<SessionIdentifier>”]

 

Where:

<PathToProcessfile> is the full path of the Process file that you want to run.

AutoRun indicates that the Process file is run without intervention, when set to True. Provide the full path to the logon shortcut file if this parameter is set to True.

<LogonShortcutFile> is the logon shortcut file that is used to connect to SAP.

SilentMode indicates that the file is run silently without displaying any error messages.

<ExcelDataFile> is the full path of the external Excel file from where the data is uploaded, or to where the data gets extracted.

<ExcelSheetName> is the name of the sheet from where the data is uploaded or to where the data gets extracted.

<StartRow> is the Excel row from where the run starts.

<EndRow> is the Excel row where the run stops.

CloseExcel indicates that the Excel file that used to run a Process file is closed after the run is complete. This parameter ignores the Edit > Excel Control > Basic > Close Excel after run setting.

<SessionIdentifier> is the new alphanumeric session identifier for the current run.

 

Note: Italicized text in angular brackets represents mandatory user input. Italicized text in square brackets indicates the optional parameters.

 

Example:

“C:\Program Files (x86)\Innowera\Process Runner\ProR.exe” “C:\Users\TestUser\Documents\Innowera\ProcessFiles\Sample_File.itf”

“|AutoRun=True” “|LogonFile=TestUser.ilf” “|SilentMode=True” “|ExcelFile=C:\Users\TestUser\Documents\sample.xlsx” “|SheetName=Sheet1”

“|StartRow=5” “|EndRow=10” “|CloseExcel=True” “|SessionID=72e4636d”

 

After you run the command, the data will get extracted to the sample.xlsx file, and the Excel file will be closed.

 

 

Next

Automatically generate VBA code from Process Runner