Skip to main content
Parked

Combine PI point ID and name in external ID

Related products:Extractors
  • February 4, 2025
  • 2 replies
  • 53 views

Øystein Aspøy
Committed
Forum|alt.badge.img+4

 

Is it possible to add support to combine name and SourceID as the external ID.

From a Data management point of view the best solution might be to use PointID. But from a consumer point of view it might be more convenient to use name. However with name we have the possibility to overwrite if there is created a new timeseries with similar name. But how about a combination?

 

external-id-prefix string Enter the external ID prefix to identify the time series in CDF. Leave empty for no prefix. The external ID in CDF will be this prefix followed by either the PI Point name or PI Point ID.
external-id-source either Name or SourceId Enter the source of the external ID. Name means that the PI Point name is used, while SourceID means that the PI Point ID is used. Default value is Name.

2 replies

Forum|alt.badge.img

Hi ​@Øystein Aspøy and thanks for this idea.

I’m - perhaps incorrectly - presuming you’re asking us to extend the PI extractor to support concatenating the name of the time series source + its sourceID and use the concatenated information as the CDF Time Series external Id?

Uncertain what the actual validation rules of the name in the source would be. I.e. does it allow characters other than alphanumeric ascii chars?


Øystein Aspøy
Committed
Forum|alt.badge.img+4

I would like to decouple the key object like name or point id from the actual external id.

So I would like the extractor to listen to pointid and/or name and then write it into the timeseries in CDF.

The best way to cope for name changes is to listen to pointids, but then it makes it hard for the user to automate a 3rd party application or using grafana/powerbi.

If the easy way is to concatenate, then that would at least make it more user friendly than today.