About the Data Loader Worksheets and Fields

In order to differentiate between required and recommended field values in the Excel workbook, cells adhere to the following color coding scheme:

• Red: a required field.
• Blue: a recommended field.

Note: The Column ID and Associated Field ID will both be colored the same.

Example:

When a cell corresponds to a field in Meridium Enterprise APM that requires a Logical value, you should enter True or False.

In Meridium Enterprise APM, family fields that have the Character data type (Character fields) restrict values to a maximum length. In the Excel workbooks, when entering data in a cell that represents a Character field, the values must not exceed the character limit of the corresponding field. The character limits for these fields are noted in the Mappings Documents.

Dates should be entered in the following format: YYYY-MM-DD hh:mm:ss, where:

• YYYY is the four-digit year.

• MM is the two-digit month.

• DD is the two-digit day.

• hh is hours in 24-hour notation.

• mm is minutes.

• ss is seconds.

For example, a complete entry would be the following: 2015-05-01 17:53:00. This corresponds to 5:53 PM on May 1, 2015.

Note: Hours should be entered in 24-hour notation (e.g., 17:53:00, not 5:53:00). AM and PM should never be included. Unless otherwise noted in the applicable Mappings Document, times entered should be based on the time zone of the user who will be performing the data load.”

Data loader Excel workbooks are available with field captions in all baseline languages supported by Meridium Enterprise APM.

You can insert additional worksheets into your data loader workbook that will not be loaded into Meridium Enterprise APM by encasing the worksheet name in parentheses. For example, if you wanted to add a sheet to record notes on the data loaded into the workbook, you could add a worksheet named (Notes). Because the name of the worksheet is in parentheses, the worksheet will not be loaded into Meridium Enterprise APM.

In the workbooks, values that correspond to a Unit of Measure (UOM) should be entered based on the current UOM Conversion Set setting for the Security User who will be performing the data load.

For example, if the UOM Conversion Set for the Security User is Metric, metric values should be entered in the Excel workbook.

In cells that correspond to a field that uses a UOM, you should not enter the actual UOM. For example, you should enter 10, not 10 Inches.