Sigmafine 4 Format for Transfer Data (No Control Table)
The header names of the file are mapped to the Attribute names or properties of the transfer. A transfer Element can have many properties but only the transfer properties (Source, Destination, StartTime and EndTime) are required to create the transfer. The transfer property description is optional. Any headers that designate Attribute information are also optional.
Sigmafine 4 Transfer File Format
| Column Header Name | Required | Attribute or (Property) Name in Sigmafine 4.x |
|---|---|---|
| NAME | Yes | (Name) If the name is not provided, transfers are automatically named. |
| STARTTIME | No | (Start Timestamp) Required if not specified in the Data Loader command file. |
| ENDTIME | No | (End timestamp) Required if not specified in the Data Loader command file. |
| SOURCE | Yes | (Source) This is the name of the Element that is the source element. |
| DESTINATION | Yes | (Destination) This is the name of the Element that is the destination element. |
| [Attribute Name] | No | [Attribute Name] i.e. Measured volume, material, etc. |
EXAMPLE: Comma Delimited File for Importing
The following example shows a comma delimited file used to import data for two transfers. In this example the required transfer properties are StartTime, EndTime, Source, and Destination. The Name and MeasuredMass properties are optional.
Name, StartTime, EndTime, Source, Destination, MeasuredMass
TR-1, 7/16/2010 1:00:00 AM, 7/16/2010 2:00:00 AM, Tank1, Tank2, 1000
TR-2, 7/16/2010 1:15:00 AM, 7/16/2010 3:00:00 AM, Tank2, Tank3, 3000