TrnExportCSV Function Issue (Delayed Data exporting)

Question

Hello all, 
 I have an issue related to TrendExportCSV function, that is when i export data, the data delays an hour without any reason. 
 to be more clear, you can see these 3 photos.

as you see above the value is 496.06 in 11/04/2025 from 19:00 untill 20:00, then it is 497.1 in 11/04/2025 from 20:00 untill 20:30, but the exported data shows the value 496.06 to be at 11/04/2025 20:30 , and if i wait to the hour to end the same thing happens and it is delaying an hour. 
 i use a sample period of 1 minute for trend and trnexportcsv(period argument = 3600 (1 hour), length = 25 , mode = 1 , iDisplaymode = 14) 
 
 Note : when i configure the period to be 1800 the issue will happen if i export before the first 30 minutes of hour, and will not happen if i export after that half hour. 
 and if use a period of 60 the same issue will happen but with first and last 30 seconds of a minute and the data will delay an minute. 
 
 Eric Black Jacky Lang

Mohamed Almansy · Accepted Answer

After AVEVA support contacted me, they have solved this issue by modifying the iDisplayMode argument to be [16777216], this input for iDisplayMode argument can be found in TrnGetTable function help, 
 quotation from Plant SCADA help " 16777216 - Do not synchronize samples to the nearest display period." 
 also i used the arguments 12 and 2 , so the final iDisplayMode argument i used is 16777230 = 16777216+2+12 . 
 and this solved the issue and everything now is working fine.

Jacky Lang · Answer

Please refer to the section of Display Mode in online help for Plant SCADA. Although this section is documented for CtAPI's TrnQuery function, it provides an example to explain how this parameter works. Maybe in your case, you should try the raw data option for data export. However, this option is not mentioned in help for TrnExportCSV . Give a go. If it doesn't work, please reach out to Technical Support.

TrnExportCSV Function Issue (Delayed Data exporting)

Top Replies