Download the Solution Example here: HistorianToCSV.dbsln

  • Solution Name: Historian to CSV
  • Software Version: v10
  • Keywords: Historian, Export

Summary

This solution example shows how to Export Historical data to a CSV file.

Technical Information

This project uses the TrendChart for visualizing tag values that change over time when the solution is running. Each Pen (Tag value) has a different color in the graph, which you can configure as you like, including a legend whose position you can modify. All the graph information will be saved in a file with the default extension as .csv.
In TWebBrowser, it is possible to view the content of the file, and in the settings, you can configure the URL of the exported file. Through this URL, the WebBrowser can access the path of the file and display its content. Additionally, the file will be saved in the same path as your solution, but you can change that by going to Displays → MainPage → CodeBehind, and modifying the lines of code as in the example below:


@Tag.SelectedFileName = "";

@Tag.SelectedFileName = @"Path" + @Tag.OutputFilename;



bool ret = @Historian.Table.Table2.SaveToTextFile(@Tag.StartDateTime.LocalDateTime, @Tag.EndDateTime.LocalDateTime, @Tag.SelectedFileName, ',', true, true, true, 6, null);

References Information

→ Learn more at Historian (Time-Series Data).

In this section:

  • No labels