The CSV file load option expects to read a Comma Separated Variable file as input.
Note: The format of the file is reasonably flexible, but to achieve the best results it is recommended to follow the file format shown below:
Tip: To generate an example CSV file perform an export from stPro using the Excel format type.
Example CSV file:
" ","math sine","time seconds","5RT101 pv","5RT101 sp" (1)
" ","none","seconds","DEG F","DEG F" (2)
" ","Derived va","Collector ","R5101 REAC","R5101 REAC" (3)
"08/18/2004 17:28:45", 0.458424, 45, 871.57, 1000 (4..n)
"08/18/2004 17:28:50", 0.672825, 50, 772.313, 1000
"08/18/2004 17:28:55", 0.841374, 55, 654.508, 1000
"08/18/2004 17:29:00", 0.952584, 0, 526.164, 1000
"08/18/2004 17:29:05", 0.998878, 5, 396.043, 1000
"08/18/2004 17:29:10", 0.977099, 10, 273.004, 1000
"08/18/2004 17:29:15", 0.888733, 15, 165.434, 1000
"08/18/2004 17:29:20", 0.739801, 20, 80.6641, 1000
... etc ...
"08/18/2004 17:32:50", 0.672835, 50, 772.313, 1000
"08/18/2004 17:32:55", 0.841381, 55, 654.508, 1000
Key:
1. Line 1 - a list of comma separate Items names.
2. Line 2 - the Engineering units for each item.
3. Line 3 - a Description of each item.
4. Line 4 .. n - data lines, each with a Timestamp (in MM/DD/YYYY format) followed by a value for each item.
Missing Data
Where data is missing the following keywords can be used to ensure that a gap is shown for the appropriate pen in stPro:
MISSING, NO DATA or NODATA.
Bad Values
Where the value scanned cannot be represented as a number, the following keywords can be used to ensure that the appropriate text is displayed for the item and that the Bad value line style is used to depict the 'bad' data.
BAD or NAN
NEGINF or -INF
POSINF or +INF