Automating trnexportcsv

[Jamiemarburg1]

Hello,

         I'm trying to automate the trnexportcsv() cicode function in Citect Scada 2016 at our plant. The idea being the operations team can easily extract data when needed. Just to clarify I am aware you can do this in process analyst but when they want to extract say a years worth of data you only get the 300 odd data points that are visible in the analyst graph rather than the millions of actual points that are available. Also aware that you can use the trnexportcsv() function with a button but my understanding is you need to specify pens, time, etc when you define the button. I want them to be able to specify whatever pens, time etc they need at the time and also have some sort of feedback on progress as from my experience the export can take a couple of hours. Hoping someone may have already ready written some type of function for this.

[olivier_vallee]

Hi @Jamiemarburg1,

I've not heard of this being implemented before, but in theory should be possible.

I think it is more common to log Trend data into a Historian, then query the Historian DB or SQL Server for the records required (either via automated report or ad-hoc report).

Have a look in the Citect Toolbox (not on GCS Forum): (8) Toolbox - Plant SCADA Community (formerly Citect) - AVEVA Software Community

You may find some sample code that gets you part of what you are trying to achieve.

The tricky bit will be to run it async (since it will be from client side cicode) and have hooks to notify completion of the task.

Kind regards

Olivier

[Jamiemarburg1]

Thanks @olivier_vallee, I'll check it out!