Creates FastLoad CSV Files
Version:
1.03
Requirements:
Requirements:
Requirements: Citect 7.40 and later, Citect Historian 4.4 and later, Wonderware Historian 2014 and later
Description:
This Cicode function exports all historized tag samples from Vijeo Historian/CitectHistorian to CSV files that can be imported by Aveva Historian/Wonderware Historian's FastLoad feature. No data or configuration information is taken from the Citect project. This has been tested with Vijeo Historian 2016, 4.5, and 4.4 and Aveva Historian 2020 R2 and Wonderware Historian 2014 R2. See the comments in the Cicode for instructions. If all your trend history is still available in the Citect Trend data files, check out the Wonderware Historian Trend History Bulk Import Tool.
Description:
This Cicode function exports all historized tag samples from Vijeo Historian/CitectHistorian to CSV files that can be imported by Aveva Historian/Wonderware Historian's FastLoad feature. No data or configuration information is taken from the Citect project. This has been tested with Vijeo Historian 2016, 4.5, and 4.4 and Aveva Historian 2020 R2 and Wonderware Historian 2014 R2. See the comments in the Cicode for instructions. If all your trend history is still available in the Citect Trend data files, check out the Wonderware Historian Trend History Bulk Import Tool.
Updates:
1.03 2/12/2021 Modified to export one month per file to avoid errors from Historian importing too much at a time (recommended by support)
1.02 1/20/2021 Fixed null value/invalid quality errors from importing Citect Historian's extended quality values. Fixed incorrect time format errors because of default format returned by SQL
1.01 3/25/2020 Renamed StrReplace() for compatibility with Citect 2018R2. Fixed error exporting databases with invalid sample times
Author:
Eric Black
