2014-05-30

CSV file format Overview: Header: 1 line File Header information Written if option "include header information" is checked (Options/Export) starting with the character "F" TS Header(s): 1 line TS Header(s) Information starting with character "T" Keys: 1 line for each key Key information starting with character "K" Measures: 1 line for each measure Measure information starting with character "M" File Header information - Line starting with an "F": Column Descriptions: 1: Starting Character 2: File name with full path information 3: Major Version Number (currently 1) 4: Minor Version Number (currently 1) 5: Time Series Data Status (0=valid, 1=incomplete) 6: Header Size [bytes] 7: Time Series Header Size [bytes] (includes description size)) 8: Time Series Header Size Description Size [bytes] 9: Time Series Header Count (in V 3.0 always 1) 10: Measure Size [bytes] 11: Key Size [bytes] (includes the size of the key name) 12: Key Name Size [bytes] TS Header information - Line starting with an "T": Column Descriptions: 1: Starting character 2: Sequential number of TS Header (starting with 0) 3: Header description 4: Interval of measures in [10ms] 5: Start time in since UTC 1/1/70 6: Warmup time in [10 ms] 7: Measure time in [10 ms] 8: Measure offset - Measures start at this byte of the file 9: Interval count: Last interval - first interval + 1 10: Measure count: Count over all intervals and keys 11: Key offset: Keys start at this byte of file 12: Key count: Number of keys 13: Merged users: Number of users merged to this TS 14: Quality: Number of intervals skipped Key - Line starting with an "K": Column Descriptions: 1: Starting character 2: Sequential key number (starting with 0) 3: MP Class Description: (see User"s Guide for all possible measure groups) 4: Key name 5: Measure Type description: (see User"s Guide for all measures of a measure group) 6: N: count 7: Sum: sum value 8: Min: minimum value 9: Max: maximum value 10: X2: sum of squares 11: MinSum: minimum over sums per interval 12: MaxSum: maximum over sums per interval 13: MinMax: minimum over maxima per interval 14: MaxMin: maximum over minima per interval 15: MinAvg: minimum over averages per interval 16: MaxAvg: maximum over averages per interval 17: MinCnt: minimum over count per interval 18: MaxCnt: maximum over count per interval Measure - Line starting with an "M": Column Descriptions: 1: Starting character 2: MP class description"/"Key name"/"Measure type description: MP class description: (see User"s Guide for all possible measure groups) Key name Measure type description: (see User"s Guide for all measures of a measure group) 3: Time in [10ms] from starting time 4: Key Index: 0 based index in keylist 5: N: count 6: Sum: sum value 7: Min: minimum value 8: Max: maximum value 9: X2: sum of squares

Show more