Documentation/Examples for OPC Data Transformation
We have an OPC DA Collector and an OPC UA Collector. Both are pointed to control systems that use digital states (i.e., 0 = off, 1 = on). In Canary, we'd like to store the string representation instead of the integer, so people don't have to remember. I see in the DA and UA documentation, it says you can use the Data Transformation property to do this. But there's almost now details on how to use. Does anyone have a good resource, or repository or examples, for learning to use Data Transformation on these 2 collectors?
6 replies
-
Hi Damon Vinciguerra ,
Here is the documentation for OPC UA Collector regarding the various functions for the TRANSFORM column:
https://helpcenter.canarylabs.com/t/h7y8gza/opc-collector-tile-version-24#tag-settingsThere isn't a specific example, but based upon your scenario, you would use:
if(value==0,'OFF',if(value==1,'ON',value))
I don't believe you can convert an integer to a string within the OPC DA Collector.
-
Steve Mason Thanks for the assist on UA, that helps a little. But unfortunately the bulk of the tags we need this on (~5,000) are DA. We're reading tags from an old Emerson Ovation control system and there's no way to get them UA without asking our customer to buy additional software (like Kepserver), which we'd like to avoid. How sure are you this is impossible with the DA Collector?
-
Damon Vinciguerra I confirmed with development that the OPC DA Collector will not support this. If you don't want to go the route of getting Kepserver, you'd have to do a transform in Axiom for applications or with calculations, but that will be additional tags.
-
Steve Mason thanks for double checking. What is an Axiom transform? Do you have any docs on that? Thanks.
-
Damon Vinciguerra See https://helpcenter.canarylabs.com/t/h7y8gfa/using-the-valuetransform-property-version-24. Since it is a string you want to convert it to, you'd probably use a ValueBox to display it. I think you could use the same syntax as you would with the OPC Collector.
-
Steve Mason Got it. Thanks!
-
Print this page