Rockwell Automation FactoryTalk Metrics User Guide - Manual (Page 72)

Chapter 3 Collecting Performance Data
5. Click OK.
The value appears under Lookup Code Values.
Instead of manually configuring a lookup code list, you can import
an existing list from a comma-separated values file (.csv).
NOTE
If a shift description lookup list already contains values, and you intend
to import other values to this list, the original values will be replaced
with the new ones.
To import Shift Description lookup list values:
1. Under Previous Import File Path, click Import.
The Open dialog box appears.
2. Select a file that contains the lookup list, and then click Open.
See "Event Lookup Value CSV Format (page 72)" for the
required file format of the Comma Separated Values (.csv) file.
3. Click OK.
Structure the content of the .csv file in the following way:
Lookup Value, Description, Fault State, Severity, Normal State
Where:
This item: Is data of type:
Lookup Value Numeric
Description String
Fault State Boolean:
• 1, 0, or
• true, false (case-insensitive).
Severity Numeric:
• -1 (to indicate no severity), or
• Between 0 (high severity) and 100 (low severity).
Event Lookup Value CSV
Format
72 Rockwell Automation Publication PLTMT-UM001M-EN-P-June 2014