Import Citect Trends Into WW Historian

Requirements

Citect SCADA 2015 (v7.50) SP1, Citect SCADA 8.00, PowerSCADA Expert v8.1, Wonderware Historian 2014

Description

The Vijeo Citect Wonderware Historian Connector logs Citect tags/trends/alarms to Wonderware Historian. If it gets disconnected it will backfill the last 24 hours of data (by default) when it is re-connected. However, it is not designed to backfill large amounts of Citect trend data, such as when first connecting a new Wonderware Historian to a Citect system with years of history. There is another tool in the toolbox (Wonderware Historian Trend History Bulk Import Tool) to backfill Citect trends to WW Historian, but I was not able to get it to work in my case and it is no longer supported by the author. So, I wrote this Cicode to do the same thing.

This Cicode function is designed to export any amount of data from Citect's trend history for any number of trend tags. It exports to FastLoad style CSV files (one per trend tag) that Wonderware Historian can automatically import. You can specify the start and end dates as well as a filter for the tags to export. You can export directly to the FastLoad folder on the Historian, where the data files will be automatically imported, or export to a local folder then manually move the files to the Historian (good for slow WANs).

You need to set the Historize: TRUE field on the trends in Citect, then start the Historian Connector so it creates the trends in the Historian, then you need to set Historian to allow imported original values before you run this tool. See the documentation in the Cicode file for more details.

Updates

v1.02b  Added documentation
v1.01b  Modified log messages
v1.00b  Original release
 

Author
Eric Black

Submitter
Eric Black