XML data extraction

[girisubhra]

I am sending my pmdata.xml file and data_exporter.yaml in attachment,

<-------------------------->

101 200 300 90 30

files.zip](https://github.com/MicroOps-cn/data_exporter/files/9007573/files.zip)

<------------------------>
I have to extract each values from measResults from the able shown values from pmdata.xml file ,i,e
101
200
300
90
30
Please help how to extract value like this.

[MicroOps-cn]

How to distinguish these values in the indicator?
For example, add an index to label, such as

meas_value{idx="0"} 101
meas_value{idx="1"} 200
meas_value{idx="2"} 300

Or add a suffix to metric_name, such as:

meas_value_0{} 101
meas_value_1{} 200
meas_value_2{} 300

[MicroOps-cn]

It seems that the current logic can not implement your requirements in a friendly way. Only each value of measresults can be generated and configured separately

collects:
  - name: "meas_info"
    data_format: "xml"
    datasource:
      - type: "file"
        url: "pmdata.xml"
    metrics:
      - name: "meas_info"
        match:
          datapoint: "//measData/measInfo/measValue/measResults"
          labels:
            __value__: '{{ .Text|reReplaceAll "^([0-9]+).+$" "$1" }}'
            name: '{{ ((.FindElement "../").SelectAttr "measObjLdn").Value }}'
            meas_info_id: '{{ ((.FindElement "../../").SelectAttr "measInfoId").Value }}'
            # Suppose the value of "begintime" is the real time when the monitoring data is generated
            __time__: '{{ ((.FindElement "../../../../fileHeader/measCollec").SelectAttr "beginTime").Value }}'
            index: 0
      - name: "meas_info"
        match:
          datapoint: "//measData/measInfo/measValue/measResults"
          labels:
            __value__: '{{ .Text|reReplaceAll "^[0-9]+ ([0-9]+).+$" "$1" }}'
            name: '{{ ((.FindElement "../").SelectAttr "measObjLdn").Value }}'
            meas_info_id: '{{ ((.FindElement "../../").SelectAttr "measInfoId").Value }}'
            index: 1
      - name: "meas_info"
        match:
          datapoint: "//measData/measInfo/measValue/measResults"
          labels:
            __value__: '{{ .Text|reReplaceAll "^(?:[0-9]+ ){2}([0-9]+).+$" "$1" }}'
            name: '{{ ((.FindElement "../").SelectAttr "measObjLdn").Value }}'
            meas_info_id: '{{ ((.FindElement "../../").SelectAttr "measInfoId").Value }}'
            index: 2
      - name: "meas_info"
        match:
          datapoint: "//measData/measInfo/measValue/measResults"
          labels:
            __value__: '{{ .Text|reReplaceAll "^(?:[0-9]+ ){3}([0-9]+).+$" "$1" }}'
            name: '{{ ((.FindElement "../").SelectAttr "measObjLdn").Value }}'
            meas_info_id: '{{ ((.FindElement "../../").SelectAttr "measInfoId").Value }}'
            index: 3
      - name: "meas_info"
        match:
          datapoint: "//measData/measInfo/measValue/measResults"
          labels:
            __value__: '{{ .Text|reReplaceAll "^(?:[0-9]+ ){4}([0-9]+).+$" "$1" }}'
            name: '{{ ((.FindElement "../").SelectAttr "measObjLdn").Value }}'
            meas_info_id: '{{ ((.FindElement "../../").SelectAttr "measInfoId").Value }}'
            index: 4
      - name: "meas_info"
        match:
          datapoint: "//measData/measInfo/measValue/measResults"
          labels:
            __value__: '{{ .Text|reReplaceAll "^(?:[0-9]+ ){5}([0-9]+).+$" "$1" }}'
            name: '{{ ((.FindElement "../").SelectAttr "measObjLdn").Value }}'
            meas_info_id: '{{ ((.FindElement "../../").SelectAttr "measInfoId").Value }}'
            index: 5

The results are as follows:

meas_info{index="0",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-11"} 10 1647511200000
meas_info{index="0",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-21"} 11 1647511200000
meas_info{index="0",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-31"} 101 1647511200000
meas_info{index="0",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-11"} 1 1647511200000
meas_info{index="0",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-21"} 9 1647511200000
meas_info{index="0",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-31"} 6 1647511200000
meas_info{index="0",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-11"} 60 1647511200000
meas_info{index="0",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-21"} 50 1647511200000
meas_info{index="0",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-31"} 10 1647511200000
meas_info{index="0",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-11"} 10 1647511200000
meas_info{index="0",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-21"} 90 1647511200000
meas_info{index="0",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-31"} 40 1647511200000
meas_info{index="1",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-11"} 20
meas_info{index="1",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-21"} 12
meas_info{index="1",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-31"} 200
meas_info{index="1",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-11"} 2
meas_info{index="1",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-21"} 8
meas_info{index="1",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-31"} 7
meas_info{index="1",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-11"} 70
meas_info{index="1",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-21"} 40
meas_info{index="1",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-31"} 20
meas_info{index="1",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-11"} 20
meas_info{index="1",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-21"} 20
meas_info{index="1",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-31"} 30
meas_info{index="2",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-11"} 30
meas_info{index="2",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-21"} 13
meas_info{index="2",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-31"} 300
meas_info{index="2",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-11"} 3
meas_info{index="2",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-21"} 7
meas_info{index="2",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-31"} 8
meas_info{index="2",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-11"} 80
meas_info{index="2",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-21"} 30
meas_info{index="2",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-31"} 30
meas_info{index="2",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-11"} 20
meas_info{index="2",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-21"} 30
meas_info{index="2",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-31"} 20
meas_info{index="3",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-11"} 40
meas_info{index="3",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-21"} 14
meas_info{index="3",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-31"} 90
meas_info{index="3",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-11"} 4
meas_info{index="3",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-21"} 6
meas_info{index="3",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-31"} 9
meas_info{index="3",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-11"} 9
meas_info{index="3",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-21"} 2
meas_info{index="3",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-31"} 4
meas_info{index="3",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-11"} 3
meas_info{index="3",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-21"} 1
meas_info{index="3",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-31"} 1
meas_info{index="4",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-11"} 5
meas_info{index="4",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-21"} 1
meas_info{index="4",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-31"} 3
meas_info{index="4",meas_info_id="FDDL",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-31"} 1

[MicroOps-cn]

I will consider implementing a more elegant way to process this data in subsequent versions. In addition, I hope to use your pmdata XML in my code as an example, is it possible?

[girisubhra]

collects:

• name: "meas_info"
  data_format: "xml"
  datasource:
  • type: "file"
    url: "pmdata.xml"
    metrics:
  • name: "meas_info"
    match:
    datapoint: "//measData/measInfo/measValue/measResults"
    labels:
    value: '{{ .Text|reReplaceAll "^([0-9]+).+$" "$1" }}'
    name: '{{ ((.FindElement "../").SelectAttr "measObjLdn").Value }}'
    meas_info_id: '{{ ((.FindElement "../../").SelectAttr "measInfoId").Value }}'
    # Suppose the value of "begintime" is the real time when the monitoring data is generated
    time: '{{ ((.FindElement "../../../../fileHeader/measCollec").SelectAttr "beginTime").Value }}'
    index: 0
  • name: "meas_info"
    match:
    datapoint: "//measData/measInfo/measValue/measResults"
    labels:
    value: '{{ .Text|reReplaceAll "^[0-9]+ ([0-9]+).+$" "$1" }}'
    name: '{{ ((.FindElement "../").SelectAttr "measObjLdn").Value }}'
    meas_info_id: '{{ ((.FindElement "../../").SelectAttr "measInfoId").Value }}'
    index: 1
  • name: "meas_info"
    match:
    datapoint: "//measData/measInfo/measValue/measResults"
    labels:
    value: '{{ .Text|reReplaceAll "^(?:[0-9]+ ){2}([0-9]+).+$" "$1" }}'
    name: '{{ ((.FindElement "../").SelectAttr "measObjLdn").Value }}'
    meas_info_id: '{{ ((.FindElement "../../").SelectAttr "measInfoId").Value }}'
    index: 2
  • name: "meas_info"
    match:
    datapoint: "//measData/measInfo/measValue/measResults"
    labels:
    value: '{{ .Text|reReplaceAll "^(?:[0-9]+ ){3}([0-9]+).+$" "$1" }}'
    name: '{{ ((.FindElement "../").SelectAttr "measObjLdn").Value }}'
    meas_info_id: '{{ ((.FindElement "../../").SelectAttr "measInfoId").Value }}'
    index: 3
  • name: "meas_info"
    match:
    datapoint: "//measData/measInfo/measValue/measResults"
    labels:
    value: '{{ .Text|reReplaceAll "^(?:[0-9]+ ){4}([0-9]+).+$" "$1" }}'
    name: '{{ ((.FindElement "../").SelectAttr "measObjLdn").Value }}'
    meas_info_id: '{{ ((.FindElement "../../").SelectAttr "measInfoId").Value }}'
    index: 4
  • name: "meas_info"
    match:
    datapoint: "//measData/measInfo/measValue/measResults"
    labels:
    value: '{{ .Text|reReplaceAll "^(?:[0-9]+ ){5}([0-9]+).+$" "$1" }}'
    name: '{{ ((.FindElement "../").SelectAttr "measObjLdn").Value }}'
    meas_info_id: '{{ ((.FindElement "../../").SelectAttr "measInfoId").Value }}'
    index: 5

Yes Please implement it as an example. I will give suggestions to make it better for the benefit of all in next comment.

[girisubhra]

This xml data is a standard format given by 3GPP for KPI reporting(3GPP TS 32.435 V9.0.0: Performance measurement eXtensible Markup Language (XML) file format definition). Ref:https://www.dialogic.com/webhelp/Vision/Release5.2/64-0403-05/kpi_reporting.htm)
Consider the attached xml file as sample data. Expected output should be as shown below
XML data parsing example

If data point is RRC
Output will be

{"VS.RRC.RedirEutranSuccNbr”,,name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-31"} 10
{“VS.RRC.RedirEutranAttA2Nbr”, ,name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-31"} 20
{“VS.RRC.EutrantoNRRedirAttNbr”,,name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-31"} 30
{“VS.RRC.RedirEutranAttUnknownPlmnNbr”,,name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-31"} 40

{“VS.RRC.RedirEutranSuccNbr”,,name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-11"} 60
{“VS.RRC.RedirEutranAttA2Nbr”, ,name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-11"} 70
{“VS.RRC.EutrantoNRRedirAttNbr”,,name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-11"} 80
{“VS.RRC.RedirEutranAttUnknownPlmnNbr”,,name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-11"} 90

{“VS.RRC.RedirEutranSuccNbr”,,name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-21"} 50
{“VS.RRC.RedirEutranAttA2Nbr”, ,name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-21"} 40
{“VS.RRC.EutrantoNRRedirAttNbr”,,name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-21"} 30
{“VS.RRC.RedirEutranAttUnknownPlmnNbr”,,name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-21"} 20

If data point is FDDL
Output will be
{"VS.FDDL.TrnsmssnMode2Nbr",,name="ENBFunction=ORAN-NEC-TB,EUtranCellFDD=TL08-123456-31")101
{"VS.FDDL.TrnsmssnMode2Nbr",,name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-11")10
{"VS.FDDL.TrnsmssnMode2Nbr",,name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-21")11
files.zip

[MicroOps-cn]

@girisubhra
The length of "measTypes" and "measResults" in the FDDL area in the attachment you uploaded for the first time is inconsistent. There is only one value in "measTypes", but there are five values in "measResults".

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<measCollecFile xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.3gpp.org/ftp/specs/archive/32_series/32.435#measCollec http://www.3gpp.org/ftp/specs/archive/32_series/32.435#measCollec" xmlns="http://www.3gpp.org/ftp/specs/archive/32_series/32.435#measCollec">
   <fileHeader fileFormatVersion="32.435 V7.0" vendorName="XXXX XXXX.">
      <fileSender localDn="SubNetwork=ANIEMS"/>
      <measCollec beginTime="2022-03-17T10:00:00+00:00"/>
   </fileHeader>
   <measData>
      <managedElement localDn="ManagedElement=ORAN-XXXX-TB" swVersion="V4.0.4g_132_oran.1"/>
      <measInfo measInfoId="FDDL">
         <measTypes>VS.FDDL.TrnsmssnMode2Nbr</measTypes>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-31">
            <measResults>101 200 300 90 30</measResults>
         </measValue>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-11">
            <measResults>10 20 30 40 50</measResults>
         </measValue>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-21">
            <measResults>11 12 13 14 15</measResults>
         </measValue>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-11">
            <measResults>1 2 3 4 5</measResults>
         </measValue>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-31">
            <measResults>6 7 8 9 10</measResults>
         </measValue>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-21">
            <measResults>9 8 7 6 5</measResults>
         </measValue>
      </measInfo>
      <measInfo measInfoId="RRC">
         <measTypes>VS.RRC.RedirEutranSuccNbr VS.RRC.RedirEutranAttA2Nbr VS.RRC.EutrantoNRRedirAttNbr VS.RRC.RedirEutranAttUnknownPlmnNbr</measTypes>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-31">
            <measResults>10 20 30 40</measResults>
         </measValue>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-11">
            <measResults>60 70 80 90</measResults>
         </measValue>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-21">
            <measResults>50 40 30 20</measResults>
         </measValue>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-11">
            <measResults>10 20 20 30</measResults>
         </measValue>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-31">
            <measResults>40 30 20 10</measResults>
         </measValue>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-21">
            <measResults>90 20 30 10</measResults>
         </measValue>
      </measInfo>
</measCollecFile>

[girisubhra]

@girisubhra The length of "measTypes" and "measResults" in the FDDL area in the attachment you uploaded for the first time is inconsistent. There is only one value in "measTypes", but there are five values in "measResults".

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<measCollecFile xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.3gpp.org/ftp/specs/archive/32_series/32.435#measCollec http://www.3gpp.org/ftp/specs/archive/32_series/32.435#measCollec" xmlns="http://www.3gpp.org/ftp/specs/archive/32_series/32.435#measCollec">
   <fileHeader fileFormatVersion="32.435 V7.0" vendorName="XXXX XXXX.">
      <fileSender localDn="SubNetwork=ANIEMS"/>
      <measCollec beginTime="2022-03-17T10:00:00+00:00"/>
   </fileHeader>
   <measData>
      <managedElement localDn="ManagedElement=ORAN-XXXX-TB" swVersion="V4.0.4g_132_oran.1"/>
      <measInfo measInfoId="FDDL">
         <measTypes>VS.FDDL.TrnsmssnMode2Nbr</measTypes>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-31">
            <measResults>101 200 300 90 30</measResults>
         </measValue>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-11">
            <measResults>10 20 30 40 50</measResults>
         </measValue>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-21">
            <measResults>11 12 13 14 15</measResults>
         </measValue>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-11">
            <measResults>1 2 3 4 5</measResults>
         </measValue>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-31">
            <measResults>6 7 8 9 10</measResults>
         </measValue>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-21">
            <measResults>9 8 7 6 5</measResults>
         </measValue>
      </measInfo>
      <measInfo measInfoId="RRC">
         <measTypes>VS.RRC.RedirEutranSuccNbr VS.RRC.RedirEutranAttA2Nbr VS.RRC.EutrantoNRRedirAttNbr VS.RRC.RedirEutranAttUnknownPlmnNbr</measTypes>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-31">
            <measResults>10 20 30 40</measResults>
         </measValue>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-11">
            <measResults>60 70 80 90</measResults>
         </measValue>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-21">
            <measResults>50 40 30 20</measResults>
         </measValue>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-11">
            <measResults>10 20 20 30</measResults>
         </measValue>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-31">
            <measResults>40 30 20 10</measResults>
         </measValue>
         <measValue measObjLdn="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL21-123456-21">
            <measResults>90 20 30 10</measResults>
         </measValue>
      </measInfo>
</measCollecFile>

First time the sample data i shared is not correct, Please consider the latest shared xml file. Idea behind is each measInfoId will have 1 or more MeasType and it will have respective measResult, so based on measInfoId it will select the measType and map its corresponding measResult.

[MicroOps-cn]

@girisubhra refer to:
https://github.com/MicroOps-cn/data_exporter/tree/master/examples/xml_3gpp_ts

[girisubhra]

It is working, and giving output like as shown below. What is this extra value 164751120000, can we stop printing this value
meas_info{index="VS.RRC.EutrantoNRRedirAttNbr",meas_info_id="RRC",name="ENBFunction=ORAN-XXXX-TB,EUtranCellFDD=TL08-123456-11"} 80 164751120000

[MicroOps-cn]

You can try to delete this line:

data_exporter/examples/xml_3gpp_ts/xml_exporter.yaml

Line 20 in cfc46d8

__time__: '{{ ((.FindElement "../../../../fileHeader/measCollec").SelectAttr "beginTime").Value }}'

__ time__ It is used to expose the real acquisition time to Prometheus when the data contains the real acquisition time.
refer to honor_timestamps:
https://prometheus.io/docs/prometheus/latest/configuration/configuration/#scrape_config

[girisubhra]

Now i build it using
make common-build && docker build -t data_exporter:0.4.1 .
and exuceuted
docker run -itd -p 9116:9116 -v /home/subhra/data_exporter/examples:/etc/data_exporter/ --name data_exporter microops/data_exporter:0.3.2 --config.path=/etc/data_exporter/data_exporter.yaml

But i am not getting the sameout put given by below steps
git clone https://github.com/MicroOps-cn/data_exporter
cd data_exporter/examples/xml_3gpp_ts/
docker run --rm -it -v ${PWD}:/etc/data_exporter/ microops/data_exporter debug --config.path=/etc/data_exporter/

[MicroOps-cn]

data_exporter/examples/xml_3gpp_ts/

Because the configuration files used are different,
In the example: data_ exporter/examples/xml_ 3gpp_ ts/
And you use data_exporter/examples/

[girisubhra]

It will be more useful, if you will explain the data extraction logic and mapping in README file. Suppose there may be case where we may have to add new field in the pmdata.xml where length of mmeasTypes" and "measResults are more then what changes we should make.

for example if below mentioned new value is added, then what changes will be required to extract the corresponding meaValue for measTypes

==============================

VS.RLC.TxAmPdus VS.RLC.RxAmPdusDrppdNbr VS.RLC.RxUmPdus VS.RLC.RxUmByts VS.RLC.TxUmByts VS.RLC.RlcReTxNbr VS.RLC.RxAmPdus VS.RLC.AmWndwStallNbr VS.RLC.TxUmPdus VS.RLC.RxAmByts VS.RLC.RlcUlReTxNbr VS.RLC.TxAmByts 10 20 30 40 50 60 70 80 90 10 10 10 11 20 30 42 50 60 70 83 90 10 10 10 15 24 30 40 50 60 70 87 90 16 10 19 13 20 30 40 50 60 70 84 90 10 10 19 17 20 30 48 50 60 70 80 95 10 10 16 18 28 37 40 50 60 70 80 90 10 10 111

[MicroOps-cn]

I don't see any regularity in your example. You can understand this by assuming that there are two sets of data in your XML. For example, "A B C D E" and "1 2 3 4 5", then ultimately you want to get A->1, B->2, C->3, D->4, E->5. So do you have to grab two sets of data first. Here is through __ values__ And __ values_ index__ To search for values and indexes.

Then, you need to split the index and value obtained through the separator(__values_separator__ and __values_index_separator__). For example, here, you use spaces to split these two groups of data. Then, the program will segment the two groups of data (array / list), and the elements in them correspond to each other (of course, the premise is that the length of the segmented data is equal).

A   B   C   D    E
|   |   |   |    |
1   2   3   4    5