Cicode - Citect V15.

Hi everybody I'm new here and I hope you're all very well. 

I started working with Citect a couple of days ago and I was wondering if someone understands very well the cicode fonction: "TrnExportCSV()".

I was asked to create a cicode program to create a CSV file for 1500 tags (in average). Those CSV files needs to have the value and date data of 1 year, for each tag. 

The program needs to create them simultaneously.

Thank you very much for those who'll take time for this. 

Best rewards. 

Parents
  • Julio,

    I have used TrnExportCSV, but a limitation that will affect you is that can only be used for 8 trend tags at a time. 

    I'm wondering whether the standalone tool "Batch TrnExportCSV" might suit your needs better.  It can be found here in the Toolbox:

     Batch TrnExportCSV - Toolbox - Plant SCADA Community (formerly Citect) - AVEVA Software Community

  • Thank so much for your help, I'll try your way in order to see. 

    By the way, do you know if there's the possibility to migrate from Citect V15 to Aveva System Platform ? I'm talking about the data bases, the projets and more.

    I think Citect 2015 is too old for what my company wants to do with. 

  • For trends, Batch TrnExportCSV may work for you, but it exports all history from the selected trends, which may be much more than the 1 year you wanted.

    Another option is TrnExportCSVMulti() which is a Cicode function that exports up to 32 trend tags per file, and it allows you to specify the date range. You could edit the code to do more tags per file, but I don't think you'll want to put 1500 tags in one file.

    Depending on the format you need the data, you could just write a short function to call TrnExportCSV() or TrnExportCSVMulti() one time for each trend tag in your list. That way each file is very simple with just one tag, and it's easy to do the export. Note that TrnExportCSVMulti() has several optimizations that should make it much faster to do the exports than TrnExportCSV().

    I assume you have Citect 2015 (v7.5). You can upgrade that to 2023 (v8.40) with a much better grid-based editor and some support for Industrial Graphics. The product is now called Aveva Plant SCADA, but it is really just Citect.

    Citect can push data to Aveva Historian. You just need to install and configure the Aveva Historian Plant SCADA Connector. There's also a TrendsToWWHist function to allow you to backfill years of Citect Trend history to Aveva Historian after you connect it.

    I don't know of a way to convert your project to System Platform other than manually re-creating everything. You can export alarms/tags/trends to CSV files.

Reply
  • For trends, Batch TrnExportCSV may work for you, but it exports all history from the selected trends, which may be much more than the 1 year you wanted.

    Another option is TrnExportCSVMulti() which is a Cicode function that exports up to 32 trend tags per file, and it allows you to specify the date range. You could edit the code to do more tags per file, but I don't think you'll want to put 1500 tags in one file.

    Depending on the format you need the data, you could just write a short function to call TrnExportCSV() or TrnExportCSVMulti() one time for each trend tag in your list. That way each file is very simple with just one tag, and it's easy to do the export. Note that TrnExportCSVMulti() has several optimizations that should make it much faster to do the exports than TrnExportCSV().

    I assume you have Citect 2015 (v7.5). You can upgrade that to 2023 (v8.40) with a much better grid-based editor and some support for Industrial Graphics. The product is now called Aveva Plant SCADA, but it is really just Citect.

    Citect can push data to Aveva Historian. You just need to install and configure the Aveva Historian Plant SCADA Connector. There's also a TrendsToWWHist function to allow you to backfill years of Citect Trend history to Aveva Historian after you connect it.

    I don't know of a way to convert your project to System Platform other than manually re-creating everything. You can export alarms/tags/trends to CSV files.

Children
No Data