Sigmafine 4 Format for an Analyzer Data File
In a Sigmafine 4 formatted file, the header names of the file are mapped to one single Attribute that is specified in the “Attribute” field, which must be configured to use the Component Data Reference. This configuration specifies which tag will be updated in the PI system for each component.
Note these key points:
- Only the component data is imported by the analyzer format.
- When additional Attribute values other than the component data are to be imported, use the meter import format for these attributes. See Sigmafine 4 Format for a Meter Data File.
Sigmafine 4 Analyzer File Format
| Column Header Name | Required | Attribute or (Property) Name in Sigmafine 4.x |
|---|---|---|
| NAME | Yes | (Name) |
| [Component Attribute Name]1 | No | [Component Attribute Name] |
| COMPONENT NAME | Yes | Component names used are those that have been configured in the Component Data Reference in the [Attribute Name] field. |
| VALUE | No | Value (decimal fraction) of the component configured in the [Component Attribute Name] and specified in the COMPONENT NAME field. |
| TIMESTAMP | No | (Timestamp) Required if not specified in the Data Loader command file. |
| 1 Only the Attribute that has been configured using the Analyzer calculation of the Component Data Reference can be used as a keyword. All other Attributes should be imported using the Meter file format. (see note) |
EXAMPLE: Comma Delimited File for Importing Data
The following example shows a comma delimited file for importing data for two analyzers with two elements.
Name, Attribute, COMPONENT NAME, VALUE, TIMESTAMP
Analyzer1, ComponentData, Cu, 0.5, 11/19/2010 10:30:00 AM
Analyzer1, ComponentData, Mo, 0.05, 11/19/2010 10:30:00 AM
Analyzer2, ComponentData, Cu, 0.025, 11/19/2010 10:30:00 AM
Analyzer2, ComponentData, Mo, 0.05, 11/19/2010 10:30:00 AM
Note: The value for the Component Name is specific to analyzer data using the Component Data Reference. If another Attribute has to be imported for analyzers, import it as you would a meter attribute. See the section Sigmafine 4 Format for Meter Data File.