Note: The Configuration Worksheet cannot be used by the Failure Modes and Effects Analysis (FMEA) Data Loader, the Reliability Centered Maintenance (RCM) Data Loader, or the Thickness Monitoring (TM) 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.
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 Filter Column
BATCH_FILTER_COL_ID
Character
When the data is loaded into Meridium Enterprise APM, it is processed in a series of batches. This column contains the Data Column ID that will be used for the batching of the data. All of the records will be grouped together by the unique values in the column specified in the <data> worksheet. This column must also be the first column that exists in the <data> worksheet. It must be the Column ID, which is in second row on the <data> worksheet and not the Field ID.