VarbanVarbanov

Question about possibilities for importing SFI or other format XML elements structure into AF

Discussion created by VarbanVarbanov on Sep 18, 2012
Latest reply on Sep 19, 2012 by MIPAC

Hi 

 

Is there a way to import elements into AF from XML with schema different than the schema used in AF (OSIsoft.AF.xsd) ? As far as I can see it is not, but anyway i'm asking, bacause we have XML documents in SFI format - here is some small example - part of the XML :

 
        <CELL Width="431" Align="left" StyleClass="3">Chain blocks and slings</CELL>
    </LINE>
    <LINE>
      <CELL Width="15" Align="left" StyleClass="11">.</CELL>
      <CELL Width="573" Align="left" ColSpan="2" StyleClass="9">
        <LINES ColCount="2" RowCount="51">
          <LINE>
            <CELL Width="198" Height="0">
            </CELL>
            <CELL Width="390" Height="0">
            </CELL>
          </LINE>
          <LINE>
            <CELL Width="198" Align="left" StyleClass="7">960.0001</CELL>
            <CELL Width="390" Align="left" StyleClass="7">CHAIN BLOCK, ENGINE ROOM</CELL>
          </LINE>
          <LINE>
            <CELL Width="198" Align="left" StyleClass="7">960.0002</CELL>
            <CELL Width="390" Align="left" StyleClass="7">CHAIN BLOCK ENGINE E2 0,5 T</CELL>
          </LINE>
          <LINE>
            <CELL Width="198" Align="left" StyleClass="7">960.0003</CELL>
            <CELL Width="390" Align="left" StyleClass="7">CHAIN BLOCK ENGINE E3 1,0 T</CELL>
          </LINE>
          <LINE>
            <CELL Width="198" Align="left" StyleClass="7">960.0004</CELL>
            <CELL Width="390" Align="left" StyleClass="7">CHAIN BLOCK ENGINE E4 1,0 T</CELL>
          </LINE>
          <LINE>
            <CELL Width="198" Align="left" StyleClass="7">960.0005</CELL>
            <CELL Width="390" Align="left" StyleClass="7">CHAIN BLOCK ENGINE E5 2,0 T</CELL>
          </LINE>
          <LINE>
            <CELL Width="198" Align="left" StyleClass="7">960.0006</CELL>
            <CELL Width="390" Align="left" StyleClass="7">CHAIN BLOCK ENGINE E6 0,5 T</CELL>
          </LINE>
          <LINE>
            <CELL Width="198" Align="left" StyleClass="7">960.0007</CELL>
            <CELL Width="390" Align="left" StyleClass="7">CHAIN BLOCK ENGINE E7 0,5 T</CELL>
          </LINE>
          <LINE>
            <CELL Width="198" Align="left" StyleClass="7">960.0008</CELL>
            <CELL Width="390" Align="left" StyleClass="7">CHAIN BLOCK ENGINE E8 0,5 T</CELL>
          </LINE>  

What could be the best way to transform this structure and import it into AF - is parsing our existing xml document and reading its elements and using AF SDK to write the elements into AF the way to do this?

Thank You and Best Regards!

Outcomes