Integration of csv files in citect

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 ????

Patrick over 5 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel