General Information

Requirements for APM Connect Data Loaders

All APM Connect Data Loaders have the same mapping and security settings requirements.

Important: To achieve best performance in the ingestion process, APM Connect recommends ingestion of maximum file size to be 10 MB. However, there are circumstances that may require larger files for ingestion. For such use cases, APM Connect allows file sizes up to 30 MB. If the file size exceeds 30 MB, an error message appears indicating that maximum file size has reached, and the file is not processed. Additionally, there will be a check for file sizes in uncompressed state to ensure that file size does not to exceed 100 MB.
Note: File size, and data model complexity are two variables of data ingestion performance. Ingesting smaller files and lower complexity data models will assist in improving the performance.

Security Settings

The Security User performing the data load operation must be associated with either the MI Data Loader User or MI Data Loader Admin Security Role.

Mapping

The Data Loaders map the datasheet columns in the Excel workbook to fields in APM families by field ID. The captions may be changed as needed, but do not change the field IDs.

Exclude Fields with Large Data

About This Task

This topic describes how to reduce the size of the GEDA archive file by excluding fields with large amount of data while loading Equipment and Functional Location records because if the size exceeds 10,000 KB, an error occurs.

Procedure

  1. Access the INGESTION_CONFIGURATION.mipref file, located in the ExcludeGedaFieldsSystemPrefFiles folder.
  2. In the GedaFieldsToExclude section, remove the fields with large amount of data.
    Tip: For a sample INGESTION_CONFIGURATION.mipref file, refer to KBA 000069790.
  3. Import data from the INGESTION_CONFIGURATION.mipref file. For instructions, refer to Import Metadata.

About Populating Site Reference Data

The APM Family Data Loader can be used to populate the Site Reference on Equipment and Functional Location records in APM.

About This Task

The APM Family Data Loader populates the ENTY_KEY system field and the MI_SITE_KEY system field associated with the Site Reference value to be populated. On asset records, the Site Reference is stored in the MI_SITE_KEY field, a system field in APM. The APM Data Loader uses the Site Name (MI_SITE_NAME) to translate the value to the corresponding Site Key and populate the MI_SITE_KEY field; therefore, you do not need to know the key to be able to populate the site reference. This functionality is important because this value can change from one database to another.

Procedure

  1. On the data worksheet, add a column that contains MI_SITE_NAME in the column name.
    For example if you are working with a relationship, where a distinction needs to be made regarding which family is associated with each column, then the column name will be prefaced with the Family ID. As shown in the following image, the column name might take the form MI_EQUIP000|MI_SITE_NAME, where MI_EQUIP000 is the Family ID.
  2. Enter the site name to designate the site by which the asset record, once loaded into APM, will be filtered.
  3. Continue populating the source workbook, and then run the data loader.