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

  • Link Assets and Tags: Equipment Records
    1. On the TagRelationship worksheet, populate the tag fields M2M System ID, Tag ID, and Tag Family ID.
    2. Populate the Equipment fields Equipment ID, Equipment CMMS System, and Equipment Family ID.
  • Link Assets and Tags: Functional Location Records
    1. On the TagRelationship worksheet, populate the tag fields M2M System ID, Tag ID, and Tag Family ID.
    2. Populate the Functional Location fields Functional Location Internal ID, Functional Location CMMS System, and the Functional Location Family ID.
  • Unlink Assets and Tags: Equipment Records
    1. On the TagRelationship worksheet, populate the tag fields M2M System ID, Tag ID, and Tag Family ID.
    2. Clear the Equipment fields Equipment ID and Equipment CMMS System ID.
    3. Populate the Equipment Family ID field.
  • Unlink Assets and Tags: Functional Location Records
    1. On the TagRelationship worksheet, populate the tag fields M2M System ID, Tag ID, and Tag Family ID.
    2. Clear the Functional Location fields Functional Location Internal ID and Functional Location CMMS System ID.
    3. Populate the Functional Location Family field.
  • Link Custom Equipment or Functional Location Families

    The following fields can be modified on the worksheet to accommodate linking and unlinking tags and assets in custom equipment or functional location families:

    • MI_TAG_ID_C
    • MI_EQUIP000_SAP_SYSTEM_C
    • MI_EQUIP000_EQUIP_ID_C
    • MI_FNCLOC00_SAP_SYSTEM_C
    • MI_FNCLOC00_INTERNAL_ID_C
    1. After the original ID, add a pipe character (|) followed by your custom ID.

      For example, if you are loading data into a custom asset family with an ID of MC_ASSET and using the custom asset ID field is MC_ASSET_ID_C, then you can modify the standard MI_EQUIP000_EQUIP_ID_C field to MI_EQUIP000_EQUIP_ID_C|MC_ASSET_ID_C. You will also want to make sure that the custom family ID is the Equipment Family ID field.

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.

WorksheetDescription
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 CaptionField IDData Type (Length)Comments
M2M System IDMI_TAG_SYSTEM_ID_CCharacterLogical 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 IDMI_TAG_ID_CCharacterThe ID of the tag to be linked.
Tag Family IDTAG_FAMILY_IDCharacterFamily to which the tag belongs. The default value for AMS Assets is MI_APTAG.
Equipment CMMS SystemMI_EQUIP000_SAP_SYSTEM_CCharacterNone
Equipment Internal IDMI_EQUIP000_EQUIP_ID_CCharacterNone
Equipment Family IDEQUIP_FAMILY_IDCharacterThe Default value is MI_ EQUIP000.
Functional Location CMMS SystemMI_FNCLOC00_SAP_SYSTEM_CCharacterNone
Functional Location Internal IDMI_FNCLOC00_INTERNAL_ID_CCharacterNone
Functional Location Family IDFUNC_LOC_FAMILY_IDCharacterThe default value is MI_FNCLOC00.