Tags to Assets Relationship Data Loader
The Tags to Assets Relationship Data Loader General Loading Strategy
The Tags to Assets Relationship Data Loader manages relationships between existing GE Digital APM records including: Tag records, Equipment records, and Functional Location records.
Before You Begin
You must have existing Tag records and existing Equipment records and/or Functional Location records in your GE Digital APM system so that they can be linked together.
About This Task
Unlike other APM Connect Data Loaders, which are used to input new data into GE Digital APM, the Tags to Assets Relationship Data Loader manages relationships between existing records. Specifically, you can use the data loader to manage the relationships between asset records (Equipment records and Functional Location records) and the following tag records:
- GE Tag Records: Stores values that are transferred from the GE System data source.
- AMS Asset Records: Store values that are transferred from the AMS Analytics data source.
- OPC Tag Records: Stores values that are transferred from OPC systems.
You can use the data loader to accomplish different objectives:
- Link tags to Equipment records.
- Link tags to Functional Location records.
- Unlink tags from Equipment records.
- Unlink tags from Functional Location records.
- Link Custom Equipment or Functional Location Families.
Procedure
About the Tags to Assets Relationship Data Loader Layout and Use
This topic provides a high-level overview and explanation of how the Tags to Assets Relationship Data Loader workbook is constructed.
In order to manage asset and tags relationships GE Digital APM provides an Excel workbook, Tags to Assets Relationship.xlsx, which supports linking and unlinking tag records to Equipment and Functional Location records.
The following table lists the worksheets that are included in Tags to Assets Relationship Data Loader workbook.
Worksheet | Description |
---|---|
TagRelationships | The only worksheet used by the Asset and Tag Data Loader. It is used to determine which tags to link/unlink to which Equipment or Functional Location records. |
TagRelationship Worksheet
Field Caption | Field ID | Data Type (Length) | Comments |
---|---|---|---|
M2M System ID | MI_TAG_SYSTEM_ID_C | Character | Logical grouping of tags within a plant. The user will need to set a unique system ID for this field to use. This value corresponds to the Parent System Id field in the GE Digital APM database. |
Tag ID | MI_TAG_ID_C | Character | The ID of the tag to be linked. |
Tag Family ID | TAG_FAMILY_ID | Character | Family to which the tag belongs. The default value for AMS Assets is MI_APTAG. |
Equipment CMMS System | MI_EQUIP000_SAP_SYSTEM_C | Character | None |
Equipment Internal ID | MI_EQUIP000_EQUIP_ID_C | Character | None |
Equipment Family ID | EQUIP_FAMILY_ID | Character | The Default value is MI_ EQUIP000. |
Functional Location CMMS System | MI_FNCLOC00_SAP_SYSTEM_C | Character | None |
Functional Location Internal ID | MI_FNCLOC00_INTERNAL_ID_C | Character | None |
Functional Location Family ID | FUNC_LOC_FAMILY_ID | Character | The default value is MI_FNCLOC00. |