Skip to main content
Solved

Convert numeric tag values within OPC-UA Extractor configuration


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? 

View original
Did this topic help you find an answer to your question?

7 replies

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

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


Glen Sykes
Seasoned Practitioner
  • Seasoned Practitioner
  • 123 replies
  • 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
  • 16 replies
  • 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
  • 123 replies
  • 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
  • 16 replies
  • 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
  • 671 replies
  • 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
  • 16 replies
  • August 30, 2024

Hi @Dilini Fernando ,

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

Thank you for your support.

 


Reply


Cookie Policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings