Importing data into point and accumulator histories from diverse databases, including all relevant historic data properties.

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.

https://community.se.com/t5/Geo-SCADA-Knowledge-Base/Importing-History-Using-LoadDataValue-and-LoadDataFile/ba-p/278728

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:

1. Run the program.
2. Fill in the connection details and the data you want to export.
3. Click "Export to Files."

The program conveniently saves your settings between uses in an .ini file, making repeated exports and imports a breeze.

發佈於: 施耐德電機Taiwan