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.