The Configuration worksheet tells the APM Family Data Loader what types of data are being loaded and how the data is to be loaded.
In addition to the APM Family Data Loader workbook, you can access an example workbook Foundation_APM_Data_Loader-Health Indicators and Readings example.xlsx. This example workbook illustrates how you can use the APM Family Data Loader to load records into a defined GE Digital APM family and link records in one family to another. You can use the information in this example as a model to configure or define templates for loading data into any baseline or custom family.
The data loader in this example creates Health Indicator records in GE Digital APM, links the Health Indicator records to Equipment records, and then links the Health Indicator records to Health Indicator Mapping records. Finally, the data loader loads Readings for one of the Health Indicators. In addition, the example spreadsheet includes how you can use a reference worksheet to store list values and other reference information that users can use when populating the data loader template with data.
The HealthIndicators worksheet is populated with the actual Health Indicator records you want to load into GE Digital APM.
The HealthIndicatorsEquipment worksheet is populated with the key field values for the Equipment records to which the Health Indicators on the HealthIndicators worksheet will be linked once loaded into GE Digital APM.
The HealthIndicatorMappings worksheet is populated with the Health Indicator Mappings to load into GE Digital APM.
The HealthIndicatorReadings worksheet is populated with the actual Health Indicators data you want to load into GE Digital APM.
On this worksheet, Column C illustrates a feature of the APM Family Data Loader where the unit of measure for a given field can be indicated, so that it can be converted to the baseline unit of measure if needed. Assume, for example, that the MI_TSVALUE_VALUE_N field was defined in GE Digital APM as being stored in PSIG, but the data in the spreadsheet was represented by BAR(G). As shown in the following image, you can add the UOM column to indicate to that the unit of measure for the source data is BAR(G). When this column is added, the APM Family Data Loader will convert the data from BAR(G) to PSIG (assuming that there is a unit of measure conversion defined for this in GE Digital APM).
Tip: For more information, refer to the units of measure documentation.
Additionally, column E of the HealthIndicatorReadings worksheet illustrates how time zones can be configured. Notice the appendage to the field name as shown in the following image. Adding a column where the Field ID is appended with a |TZ indicates the timezone of the source column data.
Note: If a timezone is not specified, any Date and Time field values are assumed to be in the same timezone as the user who is loading the data.
Copyright © 2018 General Electric Company. All rights reserved.