EcoStruxure Geo SCADA Expert Forum
Schneider Electric support forum about installation, configuration, integration and troubleshooting of EcoStruxure Geo SCADA Expert (ClearSCADA, ViewX, WebX).
Link copied. Please paste this link to share this article on your social media post.
Posted: 2022-09-20 02:33 AM . Last Modified: 2023-05-02 11:52 PM
Hello,
Can we merge or copy of historic files of the last 2 years from backup into the current database of GEOSCADA?
If yes, How?
Appreciate any hint
Thanks in advance
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2022-09-20 09:14 PM
Given the hrd files are just chunks of 32-byte records in theory you could just copy two files together into one and that could work. I've never tried it, it is probably not supported, just throwing it out there given your other post about extract historic from backups. It would also be very fast to run, which might be relevant if you have a million or so points to merge,
The proper way to do this would be use to use LoadDataValue, LoadDataValues and LoadDataFile on the CHistoryBase table. This allows you to insert data into the historic. You'll have to read the current historic data, work out what is extra, then insert that back using the relevant method (probably using LoadDataValues)
Link copied. Please paste this link to share this article on your social media post.
Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.