Data Extractor Settings

Data Extractor Settings

Data Extractor Settings allows user to configure the data extraction according to the required run scenario.

 

The Advanced Settings in Process Runner varies among various technologies i.e. Advanced Settings available for Transaction, BAPI/RFM and DE are different from each other.

 

To configure advanced settings for Data Extractor

 

1.In Process Runner, select Advanced from Home tab. The Data Extractor Settings window appears.

AdvancedDataExtractorSetting

2.Enter the following information in Settings Details section:

Skip First: Indicates the number of records to be skipped while extracting the data from SAP.

Block Size: Indicates the number of records to be extracted as a block at one time. So the number of calls made to SAP will depend on the block size to extract the total number of records specified. For example, if the Max. record for extraction field in the Home tab is set to 1000 and block size is set to 500 records, then only two calls will be made to SAP and 500 records will be extracted in each call.

3.Optionally, perform the following steps in Excel and Extended RFM Settings section:

Select Append to next blank row to append the record to the next blank row in the Excel file. However, if you have more than one record to be returned, downloaded records in Excel may not match with the existing Excel records.

Select Append to next blank row when this process is child process connection chain if the current file is a child process of the previous run. If selected, the data is append after the last row of the previously processed call.

Select Ignore field mapping and write entire output to column and specify the column to ignore the mapping field and extract the data in the specified column.

Select Execute Fields Exits to convert the SAP internal value and extract them as display value.

Select Reverse Server block execution to overcome the extraction of duplicate or missing records. To use this option, make sure to implement the Innowera Custom RFM version 2.5 in the SAP system that you use while running the Data Extractor process file. For more information about how to configure the Data Extractor advanced settings, see Data Extractor Settings.

Note: If you select Reverse Server block execution, error messages similar to the following may appear:

"Stopped due to time limit exceeded"

"Stopped due to CPIC-CALL: 'CMRCV: rc=19...".

In such cases, you can increase the value of the "rdisp/max_wprun_time" parameter in the SAP system from which the data will be fetched.

 

 

Next

How to convert a field to an Excel mappable field in GUI Scripting