The following describes the .csv data file format. Please see Database and Data Guidelines for the data naming rules and conventions:
RELATION, COLUMN, DATE [TIME], VALUE, “DESCRIPTION”
Where:
RELATION, COLUMN, DATE, VALUE are required fields. If the relation name is entered without a destination path, the relation is loaded to the TopRelation:User:[x]:[x] category where [x] is determined by the first two letters of the relation name. For example WID.LONESTAR_2 will by default load to TopRelation:User:w:wi. Data may be loaded to a specified path. The .csv file example below shows the relation WID.LONESTAR_2 loaded to the path: TopRelation:User:WidgetsInc:Equities:w:wi.
COLUMN must be a COLUMN name already existing in the MIM.
DATE format is: MM/DD/YYYY
TIME(Oprtional) format is: HH24:mm. (Examples: 09:00, 13:00, 00:00)
VALUE The decimal value for the data point.
DESCRIPTION (Optional) Note: If the file contains multiple lines with the same relation then the description for the last line for said relation will be used.
Use a “#”sign as the first character on a line to designate a comment. A comment line is ignored.
The following is an example of a .csv file.
 | The last description field overrides the first description entry. The description Lonestar Pipeline 2-WidgetsInc. will be used. |
Once the data has loaded, it is not necessary to include the full path to the relation the next time data for the relation needs to be loaded.