AnsweredAssumed Answered

Can PI Interface for UFL read this XML file?

Question asked by PLeão on Oct 13, 2020
Latest reply on Oct 20, 2020 by PLeão

Hi Everyone! I need some help here, Please!

 

Does anynone knows if PI Inteface UFL can relate attributes by position? In the example below I need read basicaly 3 informations:

TagName = <TitleString1>ELEMENTO</TitleString1>  & <ColumnTitle>Sensor 1 </ColumnTitle>                     <TitleString1>ELEMENTO</TitleString1>  & <ColumnTitle>Sensor 2 </ColumnTitle>

                    <TitleString1>ELEMENTO</TitleString1>  & <ColumnTitle>Sensor 3 </ColumnTitle>

                                                                                        .

                                                                                        .

                                                                                        .

                     <TitleString1>ELEMENTO</TitleString1>  & <ColumnTitle>Sensor N </ColumnTitle>

 

Timestamp = <Time>2020-09-15 13:06:26</Time> and others that appear.

 

Values = First Value that appears should be realated to Sensor 1, second Sensor 2...

 

In this case, my problem is that all sensors are inside <Column Title> and all values are inside <Cell> and I don't know how to relate this informations.

 

<?xml version="1.0" encoding="UTF-8"?>
<Event>
<FileVersion>8.0</FileVersion>
<EventType>Full Histogram</EventType>
<SampleRate>1024 sps</SampleRate>
<Channels>
<Channel>Tran</Channel>
<Channel>Vert</Channel>
<Channel>Long</Channel>
</Channels>
<Units>in/s</Units>
<TitleString1>ELEMENTO</TitleString1>
<HistogramData>
<HistogramDataColumnTitle>
<ColumnTitle>Sensor 1 </ColumnTitle>
<ColumnTitle>Sensor 2 </ColumnTitle>
<ColumnTitle>Sensor 3 </ColumnTitle>
<ColumnTitle>Sensor 4 </ColumnTitle>
<ColumnTitle>Sensor 5 </ColumnTitle>
<ColumnTitle>Sensor 6 </ColumnTitle>
<ColumnTitle>Sensor 7 </ColumnTitle>
</HistogramDataColumnTitle>
<HistogramDataIntervals>
<Time>2020-09-15 13:06:26</Time>
<Row>
<Cell>0.0019</Cell>
<Cell>73.1</Cell>
<Cell>0.0034</Cell>
<Cell>&amp;lt;1</Cell>
<Cell>0.0019</Cell>
<Cell>&amp;gt;100</Cell>
<Cell>0.0036</Cell>
</Row>
</HistogramDataIntervals>
<HistogramDataIntervals>
<Time>2020-09-15 13:06:41</Time>
<Row>
<Cell>0.0019</Cell>
<Cell>32.0</Cell>
<Cell>0.0034</Cell>
<Cell>1.6</Cell>
<Cell>0.0019</Cell>
<Cell>85.3</Cell>
<Cell>0.0035</Cell>
</Row>
</HistogramDataIntervals>

</HistogramData>
</Event>

 

 

Thanks a lot.

Outcomes