Sigmafine 4 Format for a Meter Data File
In a Sigmafine 4 formatted file, the header names of the file are mapped to the Attribute names and the properties of the meter element.
Note these key points:
Every row can contain a TIMESTAMP field that specifies the time stamp for the values. The format of the time stamp depends on the Windows regional settings.
For example, for English US timestamp use 12/24/2010 7:00:00 PM for the date December 24, 2010 at 7:00 PM.
If a time stamp is not provided, then the time stamp of the command line parameter “Timestamp” or “DayOffset” and “TimeOffset” parameters is used.
If none of these is present, then the current system time is used as the time stamp.
When importing into a case, only the TIMESTAMP field in the first row of the data file is used to determine the start time of the case. If the Case does not exist at this time, the Data Loader will exit.
Sigmafine 4 Meter File Format
| Column Header Name | Required | Attribute or (Property) Name in Sigmafine 4.x |
|---|---|---|
| NAME | Yes | (Name) |
| [Attribute Name]1 | No | [Attribute Name] |
| TIMESTAMP | No | (Timestamp) Required if not specified in the Data Loader command file. |
| 1 Any Attribute that exists in the elements being imported can be used as a keyword. |
EXAMPLE: Comma delimited file for importing
The following example shows a comma delimited file for importing data for two elements.
NAME,MeasuredMass,Temperature,TIMESTAMP
meter1,100,75.1,11/19/2010 10:30:00 AM
meter2,200,60.7,11/19/2010 10:45:00 AM