<< Click to Display Table of Contents >> Navigation:  Trend Charts > Trend Chart - CSV Export

 

When exporting a chart or part of a chart to a CSV file there are some options that can be set in the Settings.INI file in the '[TREND]' section (add this section header if it's not already there):

 

To separate Date & Time into 2 separate columns instead of having date and time in one column:

CSVExportDateTimeSeparated=1

 

To disable the MS (Milliseconds) column:

CSVExportSuppressMS=1

 

To set the granularity in seconds, so that the number of rows can be adjusted, for example, setting this to 60 will mean there will be one row every minute.

CSVExportGranularity=

Note that when doing a CSV Export on live data in a Trend Chart check the pixel rate for 'Store this many intermediate values for zooming' as setting the granularity to a faster rate than that will have no effect on the resultant CSV file. Similarly, when in Historical Replay setting the granularity to a faster rate than the Logging Rate will have no effect on the resultant CSV file.

 

 

The reason the MS (Milliseconds) column was added is because when the chart is exported from live data (as opposed to data which has been read from Logged Data) then there is additional data which is stored for zooming which can give greater than 1 second resolution, and which will be in the exported file, hence the need for milliseconds to give a more precise time stamp.

 

 

Whereas, when the chart is exported from data which has been displayed on the chart from previously recorded as Logged Data using Historical Reply or chart backfill then there is no need for milliseconds because the fastest logging rate is once per second.

 

See also Decimal Places