AnsweredAssumed Answered

Can UFL be configured to read a csv in a particular format as below?

Question asked by anirkul07 on May 2, 2017
Latest reply on May 10, 2017 by gristock

My data is as below. How can the UFL be configured to get data into PI?

The columns of interest are A,C (combination of two will give tag name), G2 will have the time stamp and other rows in G will have the value.

 

data.JPG

 

Reference (on site location),Sample Date,Analyte,Unit,LOR,Qualifier,Result,Guideline,Lower Control Limit,Lower Warning Limit,Upper Warning Limit,Upper Control Limit,Guideline Status

Cooling Tower 1,,Date & Time Sampled,No unit,0,,11/04/2017 14:15,,,,,,NA

Cooling Tower 1,,Sampled By,No unit,0,SGS (DC),,,,,,,NA

Cooling Tower 1,,Field Temperature,°C,0,,27,,,,,,NA

Cooling Tower 1,,Date & Time Processed,No unit,0,,12/04/2017 10:30,,,,,,NA

Cooling Tower 1,,HPC at 37 degrees C,CFU/mL,1,,10000,,,,,,NA

Cooling Tower 1,,Legionella species,CFU/mL,10,,100,,,,,,NA

Cooling Tower 1,,Legionella pneumophila sg 1,CFU/mL,10,<,10,,,,,,PASS

Cooling Tower 1,,Legionella pneumophila sg 2-14,CFU/mL,10,,200,,,,,,NA

Cooling Tower 2,,Date & Time Sampled,No unit,0,,11/04/2017 14:15,,,,,,NA

Cooling Tower 2,,Sampled By,No unit,0,SGS (DC),,,,,,,NA

Cooling Tower 2,,Field Temperature,°C,0,,26,,,,,,NA

Cooling Tower 2,,Date & Time Processed,No unit,0,,12/04/2017 10:30,,,,,,NA

Cooling Tower 2,,HPC at 37 degrees C,CFU/mL,1,,66000,,,,,,NA

Cooling Tower 2,,Legionella species,CFU/mL,10,<,10,,,,,,PASS

Cooling Tower 2,,Legionella pneumophila sg 1,CFU/mL,10,<,10,,,,,,PASS

Cooling Tower 2,,Legionella pneumophila sg 2-14,CFU/mL,10,,100,,,,,,NA

Cooling Tower 3,,Date & Time Sampled,No unit,0,,11/04/2017 14:40,,,,,,NA

Cooling Tower 3,,Sampled By,No unit,0,SGS (DC),,,,,,,NA

Cooling Tower 3,,Field Temperature,°C,0,,26,,,,,,NA

Cooling Tower 3,,Date & Time Processed,No unit,0,,12/04/2017 10:30,,,,,,NA

Cooling Tower 3,,HPC at 37 degrees C,CFU/mL,1,,42000,,,,,,NA

Cooling Tower 3,,Legionella species,CFU/mL,10,<,10,,,,,,PASS

Cooling Tower 3,,Legionella pneumophila sg 1,CFU/mL,10,<,10,,,,,,PASS

Cooling Tower 3,,Legionella pneumophila sg 2-14,CFU/mL,10,<,10,,,,,,PASS

Cooling Tower 4,,Date & Time Sampled,No unit,0,,11/04/2017 14:40,,,,,,NA

Cooling Tower 4,,Sampled By,No unit,0,SGS (DC),,,,,,,NA

Cooling Tower 4,,Field Temperature,°C,0,,26,,,,,,NA

Cooling Tower 4,,Date & Time Processed,No unit,0,,12/04/2017 10:30,,,,,,NA

Cooling Tower 4,,HPC at 37 degrees C,CFU/mL,1,,15000,,,,,,NA

Cooling Tower 4,,Legionella species,CFU/mL,10,<,10,,,,,,PASS

Cooling Tower 4,,Legionella pneumophila sg 1,CFU/mL,10,<,10,,,,,,PASS

Cooling Tower 4,,Legionella pneumophila sg 2-14,CFU/mL,10,,10,,,,,,NA

Fire & General Service,,Date & Time Sampled,No unit,0,,11/04/2017 14:30,,,,,,NA

Fire & General Service,,Sampled By,No unit,0,SGS (DC),,,,,,,NA

Fire & General Service,,Field Temperature,°C,0,,25,,,,,,NA

Fire & General Service,,Date & Time Processed,No unit,0,,12/04/2017 10:30,,,,,,NA

Fire & General Service,,HPC at 37 degrees C,CFU/mL,1,,1100,,,,,,NA

Fire & General Service,,Legionella species,CFU/mL,10,<,10,,,,,,PASS

Fire & General Service,,Legionella pneumophila sg 1,CFU/mL,10,<,10,,,,,,PASS

Fire & General Service,,Legionella pneumophila sg 2-14,CFU/mL,10,<,10,,,,,,PASS

Outcomes