Documentation/Examples for OPC Data Transformation

Forum / Questions & Answers

damon_vinciguerra.1
2 mths ago
6replies

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?

- smason
- 2 mths ago
- Reported - view
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-settings

There 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.
- damon_vinciguerra.1
  
  2 mths ago
  
  Reported - view
  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?
- smason
  
  2 mths ago
  
  Reported - view
  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.
- damon_vinciguerra.1
  
  2 mths ago
  
  Reported - view
  Steve Mason thanks for double checking. What is an Axiom transform? Do you have any docs on that? Thanks.
- smason
  
  2 mths ago
  
  Reported - view
  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.
- damon_vinciguerra.1
  
  2 mths ago
  
  Reported - view
  Steve Mason Got it. Thanks!