Skip to main content
Answer

Convert numeric tag values within OPC-UA Extractor configuration

  • July 22, 2024
  • 7 replies
  • 80 views

Forum|alt.badge.img+6

Hello,

Is there a way to use a parameter from OPC-UA Extractor config.yml file in order to make a conversion of some numeric tags (i.e. conversion on the measurement unit from grams to pounds)? As I have not yet found any relatable parameter that would do this and using transformations as the data is pushed in CDF is not efficient on performance as I need to filter out the datapoints already converted.

Thanks,

Raluca

Best answer by Dilini Fernando

Hi @Raluca Bala,

We are following up to see whether you're satisfied with the responses you've received? 

7 replies

Forum|alt.badge.img+6
  • Author
  • Seasoned
  • July 31, 2024

I've managed the conversions directly at the server side.


Glen Sykes
Seasoned Practitioner
  • Seasoned Practitioner
  • July 31, 2024

Hi Raluca, 

Are you aware that we introduced Unit support in CDF recently?  You can store your data points with a unit of grams, but specify the output of a query to be in pounds if you wish (conversions are calculated at query time and are not persisted).

This approach allows you to preserve the integrity of the original source data.

Here’s a link to the developer guide, if this is useful https://developer.cognite.com/dev/concepts/resource_types/units/


Forum|alt.badge.img+6
  • Author
  • Seasoned
  • July 31, 2024

Thank you, @Glen Sykes , I'm aware of this, but we need to account for some decimal offsets too during conversion.

 


Glen Sykes
Seasoned Practitioner
  • Seasoned Practitioner
  • August 1, 2024

Ah ok.  I’m glad you were aware of the feature then at least. 

Just for reference, I believe you could accomplish the goal using a combination of a synthetic time series query with units and unit conversion.

https://developer.cognite.com/dev/concepts/resource_types/synthetic_timeseries.html

This would allow you to keep the data points in their original format in CDF and have a more visible audit trail as to how the data point values are what they are, within CDF.

Hope this is helpful? 

Best wishes from the CDF product team!

Glen
 



 


Forum|alt.badge.img+6
  • Author
  • Seasoned
  • August 1, 2024

Thank you, @Glen Sykes , very helpful! Will look into it.

Regards,

Raluca


Dilini Fernando
Seasoned Practitioner
Forum|alt.badge.img+2
  • Seasoned Practitioner
  • Answer
  • August 30, 2024

Hi @Raluca Bala,

We are following up to see whether you're satisfied with the responses you've received? 


Forum|alt.badge.img+6
  • Author
  • Seasoned
  • August 30, 2024

Hi @Dilini Fernando ,

I've managed the conversions directly at the server side.

Thank you for your support.