3 Replies Latest reply on Apr 24, 2014 7:16 AM by jensing

    UFL interface - Dynamic number of columns

    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?