1 Reply Latest reply on Jul 11, 2018 1:02 PM by Mike-Matthews-Oracle

    xml and stylesheet data store

    user10719205

      Hi Mike/everyone,

       

      I am trying to import an xml file into a data store using xml and stylesheet data store,

       

      I have the following xml, and I would like to re-write in a way that EDQ understands. I am absolutely confused on how to start it off. Can you please help? Do you have complex examples that I can follow to get this done? This is the only format to use, one plant name -> units (multiple units) -> and BOps (multiple), -> generation -> stationServiceusage at the end of the file. Do you have an example that handles loops, in my case, I need a loop for unit and a loop for BOps.

      thanks.

       

      <?xml version="1.0" encoding="us-ascii"?>
      <Plant name="Red Sea" schemaVersion="1.2">
         <Unit name="G #01">
          <BOps event_type="U1" cause_code="7110" amp_code="C0" begin_time="2018-06-01T07:08:00">XXXXXXXX</BOps>
          <BOps event_type="GE" cause_code="0001" begin_time="2018-06-01T11:20:33" />
          <BOps event_type="PO" cause_code="7110" amp_code="C0" begin_time="2018-06-20T10:01:00">YTYYYYYYYY</BOps>
          <BOps event_type="GE" cause_code="0001" begin_time="2018-06-20T14:48:46" />
          <Generation begin_time="2018-06-01T00:00:00" end_time="2018-06-30T23:59:59" xxx_produced="50592.90" yyy_consumed="0.00" zzzz_delivered="0.00" />
      </Unit>
      <Unit name="G #02">
          <Generation begin_time="2018-06-01T00:00:00" end_time="2018-06-30T23:59:59" xxx_produced="0.00" yyy_consumed="0.00" zzzz_delivered="0.00" />
      </Unit>
      <Unit name="G #03">
          <BOps event_type="GE" cause_code="0001" begin_time="2018-06-27T12:20:00">Something off grid</BOps>
          <BOps event_type="RS" cause_code="0000" begin_time="2018-06-27T12:21:00">open grid</BOps>
          <BOps event_type="GE" cause_code="0001" begin_time="2018-06-27T12:32:00">closed grid</BOps>
          <BOps event_type="RS" cause_code="0000" begin_time="2018-06-27T12:53:58" />
          <Generation begin_time="2018-06-01T00:00:00" end_time="2018-06-30T23:59:59" xxx_produced="25.34" yyy_consumed="0.00" zzzz_delivered="0.00" />
      </Unit>
      <StationServiceUsage begin_time="2018-06-01T00:00:00" end_time="2018-06-30T23:59:59" xxx="1944.30" />
      </Plant>