About the Configuration Worksheet

Note: The Configuration Worksheet cannot be used by the Failure Modes and Effects Analysis (FMEA) Data Loader, the Reliability Centered Maintenance (RCM) Data Loader, Thickness Monitoring (TM) Equipment Data Loader, or the Thickness Monitoring (TM) Functional Location Data Loader.

The Configuration Worksheet is a common worksheet, which can be implemented by each of the data loaders. It allows you to control aspects of how your data is loaded such as batching and which other worksheets should be processed.

The Configuration worksheet is needed to describe the type of data that you will be loading and how that data should be handled during the data load.

Worksheet	Description
Configuration	The Configuration worksheet is needed to describe the type of data that you will be loading and how that data should be handled during the data load.

Configuration Worksheet

Field Caption	Field ID	Data Type (Length)	Comments
Load Data From Worksheet	LOAD_DATA_WORKSHEET	Boolean	Identifies if data from the corresponding worksheet identified in the Data Worksheet ID column will be loaded or not. True: the corresponding worksheet will be processed. False: The corresponding worksheet will not be processed.
Data Worksheet ID	DATA_WORKSHEET_ID	Character	This column contains the name of the <data> worksheet where the actual data is located. It needs to have the same name as the <data> worksheet in the data loader workbook.
Batch Size	BATCH_SIZE	Character	Modifying this field is required to determine the number of records processed in each batch. Enter the batch size you want, and the Data Loader will process that many records per batch. For example, if you want to use a batch size of 100, enter 100, and the data loader will process 100 records per batch. Note: The recommended batch size is 100. If the Batch Size column is removed from the source workbook, the data loader will default to a batch size of 100. In addition to processing the data in batches, the log file reports progress by batch.

Field Caption

Field ID

Data Type (Length)

Comments

Load Data From Worksheet

LOAD_DATA_WORKSHEET

Boolean

Identifies if data from the corresponding worksheet identified in the Data Worksheet ID column will be loaded or not.

True: the corresponding worksheet will be processed.
False: The corresponding worksheet will not be processed.

Data Worksheet ID

DATA_WORKSHEET_ID

Character

This column contains the name of the <data> worksheet where the actual data is located. It needs to have the same name as the <data> worksheet in the data loader workbook.

Batch Size

BATCH_SIZE

Character

Modifying this field is required to determine the number of records processed in each batch. Enter the batch size you want, and the Data Loader will process that many records per batch.

For example, if you want to use a batch size of 100, enter 100, and the data loader will process 100 records per batch.

Note: The recommended batch size is 100. If the Batch Size column is removed from the source workbook, the data loader will default to a batch size of 100.

In addition to processing the data in batches, the log file reports progress by batch.