Multiple techniques exist for loading data values into Historic aggregate class to populate point and accumulator histories. In addition to the LoadDataValue
method, which is limited to specifying Quality and Reason parameters, the LoadDataValuesEx
method provides a more comprehensive approach by allowing the inclusion of optional parameters such as Status, State, Reason, and MSState.
The referenced article provides an overview of the methods within the Historic Aggregate class, which can be employed to populate both point and accumulator histories with data values.
While the previous methods focus on in-system data manipulation, situations may arise where you need to export historic data to a file and then import it into a different database.
The link below provides a tool known as the Export and Import History Tool. This tool allows you to export your historic data to text files, named by the corresponding points. You can then modify these file names to import the data into different points within a new database. The source code for these tools is available in both .NET and Visual Basic 6 programming languages.
https://community.se.com/t5/Geo-SCADA-Knowledge-Base/Tools-amp-Samples/ba-p/279123#toc-hId
Here's how to use these tools:
- Run the program.
- Fill in the connection details and the data you want to export.
- Click "Export to Files."
The program conveniently saves your settings between uses in an .ini file, making repeated exports and imports a breeze.