jensing

UFL interface - Dynamic number of columns

Discussion created by jensing on Apr 22, 2014
Latest reply on Apr 24, 2014 by jensing

Hi guys,

 

 I’m new to PI and we (my colleague and I) are facing an interesting problem in regard to implementing UFL.

 

We are implementing UFL for a new data source. The data source provides files in a sort of table-format, with tab-separated columns that represent each tag, and then the row contains a timestamp and the value for the tag in the corresponding column.

 

Our problem is: this number of tags/columns can vary.

 

And the last column is always a “comment” column.

 

 

 

Experiment name

 

Date: (of data extraction)

 

Time: (of data extraction)

 


Date

Time

Tagname1:unit1

Tagname2:unit2

Comment

2014-04-01

09:17:42

5463.6546

56.653

 

2014-04-01

09:18:00

6852.8462

86.56

 

 

 

Can also be:

 

 

 

Experiment name

 

Date: (of data extraction)

 

Time: (of data extraction)

Date

Time

Tagname1:unit1

Tagname2:unit2

Tagname3:unit3

…Tagnamex:unitx

Comment

2014-04-01

09:17:42

5463.6546

56.653

32.9465

6847.87

 

2014-04-01

09:18:00

6852.8462

86.56

32.6896

6888.36

 

 

 

We currently have it set up with a different variable for each tag name/value, with, what we think, is a maximum number of columns the data source will produce in the file.

 

(tagname1, value1, tagname2, value2….tagname10,value10)

 

 

 

We want to set up a generic UFL interface that can be applied to each of the PI clients, no matter how many columns the ASCIII files has, i.e. the number of tags present. Would any of you have any idea how to set something like that up? Or is UFL not really able to handle dynamic columns in this way?

Outcomes