• Replies 1 reply
  • Subscribers 582 subscribers
  • Views 142 views
  • Users 0 members are here
Options
Related

Integration of csv files in citect

Yuri

I have the following task: daily information from the flowmeter comes in the form of a csv file to the mail containing information about the instantaneous and cumulative consumption. You need to transfer the data on the instantaneous flow rate and the total flow rate to Citect 2018 and declare it as a tag. Tell me the most convenient procedure for data extraction and transfer to scada. Will it be correct to transfer data using Microsoft office as an intermediary to solve this problem ????

Parents
  • If you are familiar with cicode, you could import the csv file directly, without office.
    For the actual value you would define a variable tag (persistent memory tag) and write the last known value to that using TagWrite().
    For the historic values you would define a trend tag with a sample period that represents the interval of the samples in the csv. You can then use the TrnSetTable() function to write historic data in Citect's trend system.
Reply
  • If you are familiar with cicode, you could import the csv file directly, without office.
    For the actual value you would define a variable tag (persistent memory tag) and write the last known value to that using TagWrite().
    For the historic values you would define a trend tag with a sample period that represents the interval of the samples in the csv. You can then use the TrnSetTable() function to write historic data in Citect's trend system.
Children
No Data
© 2025 AVEVA Group Limited or its subsidiaries. All Rights Reserved.