1. XML import

    Import
    Článek: AN0001933Aktualizováno::

    Na této stránce jsou zobrazeny příklady xml importů.

    Import elementů podle názvu atributu

    V některých případech potřebujeme načítat hodnoty xml elementů v závislosti na názvu atributu. ObjectGears toto umožňuje bez nutnosti provádět xslt transformaci.

    Příklad xml souboru:

    <?xml version="1.0"?>
    <Objects>
       <Object>
          <Property Name="Login">Miller</Property>
          <Property Name="LoginWithDomain">objectgears\majer</Property>
          <Property Name="Displayname">Miller David</Property>
          <Property Name="Firstname">David</Property>
          <Property Name="Lastname">Miller</Property>
          <Property Name="Email">miller@objectgears.com</Property>
          <Property Name="Enabled (Yes/No)">Yes</Property>
          <Property Name="Phone" /><Property Name="Fax">Yes</Property>
          <Property Name="SID">S-1-5-24-1432678235-875345213-874234965-43999</Property>
          <Property Name="Description">CIO</Property>
          <Property Name="Office">New York, 5th Avenue</Property>
       </Object>
       <Object>
          <Property Name="Login">Metz</Property>
          <Property Name="LoginWithDomain">objectgears\semerad</Property>
          <Property Name="Displayname">Metz Peter</Property>
          <Property Name="Firstname">Petr</Property>
          <Property Name="Lastname">Metz</Property>
          <Property Name="Email">metz@objectgears.com</Property>
          <Property Name="Enabled (Yes/No)">Yes</Property>
          <Property Name="Phone" /><Property Name="Fax">Yes</Property>
          <Property Name="SID">S-1-5-24-234842432-874237976-324856234-76534</Property>
          <Property Name="Description">Unix administrator</Property>
          <Property Name="Office">Frankfurt, Bernerstrasse</Property>
       </Object>
    </Objects>

    Pro výše uvedený importní soubor v definici importu nastavíme:

    XML cesta k položce:

    /Objects/Object

    Importní sloupce:

    Property[@Name="LoginWithDomain"]

    Property[@Name="Login"]

    Property[@Name="Displayname"]

    atd...

    Import při využití namespace

    ObjectGears umožňuje importovat data z xml souboru níže uvedené struktury.

    <?xml version="1.0" encoding="UTF-8"?>
    -<EnergyReport xmlns="http://schemas.microsoft.com/energy/2007">
      -<ReportInformation>
          <ReportGuid>61c5664e-9ba1-4a7e-8b35-64e62e8b9918</ReportGuid>
          <ReportVersion>1.0</ReportVersion>
          <ScanTime>2014-10-07T06:32:02Z</ScanTime>
          <ScanDuration>PT60S</ScanDuration>
       </ReportInformation>
      -<Troubleshooter guid="c78b52e3-9cd7-4802-979c-57ca1283dafa">
          <Name>System information</Name>
         -<AnalysisLog>
            -<LogEntry guid="3d053cee-9926-4ac0-a4e1-63ab80c63af0">
               <Name>System information</Name>
               <Severity>Informational</Severity>
               <Description>Detailed system information</Description>
              -<Details>
                 -<Detail guid="300b5d9f-434e-45b0-80d2-4bd55b168ef3">
                     <Name>Computer name</Name>
                     <Value>NYGU9SAN7Q3</Value>
                  </Detail>
                 -<Detail guid="a49d84bf-a8c7-4c26-8f54-eefccac2f084">
                     <Name>Vendor</Name>
                     <Value>Dell Inc.</Value>
                  </Detail>
                 -<Detail guid="ceddb6e2-626c-4efe-ae58-c7b241693909">
                     <Name>Product name</Name>
                     <Value>Latitude E6420</Value>
                  </Detail>
                 -<Detail guid="b586008a-e3ca-457a-8f48-30fe0de3facf">
                     <Name>Datum systému BIOS</Name>
                     <Value>06/24/2013</Value>
                  </Detail>
                 -<Detail guid="c85bfef6-93e7-4f1a-a35d-20655dab095d">
                     <Name>BIOS version</Name>
                     <Value>A19</Value>
                  </Detail>
                 -<Detail guid="31dc51fd-a872-4546-a54f-ae0da74cdf9f">
                     <Name>Number of operationg system build</Name>
                     <Value>9600</Value>
                  </Detail>
                 -<Detail guid="8838163d-e78c-4858-9432-9b034382e9f6">
                     <Name>Platform role</Name>
                     <Value>PlatformRoleMobile</Value>
                  </Detail>
                 -<Detail guid="d64ab9ff-6978-4c37-ac17-9494347b673b">
                     <Name>Process count</Name>
                     <Value>113</Value>
                  </Detail>
                 -<Detail guid="375cbf0f-61d5-42b8-a0fd-16c198b7b32f">
                     <Name>Thread count</Name>
                     <Value>1616</Value>
                  </Detail>
                 -<Detail guid="9fd5343d-fcb1-42ac-9566-8a8e8409a60b">
                     <Name>Power supply</Name>
                     <Value>true</Value>
                  </Detail>
                  </Details>
             </LogEntry>
          </AnalysisLog>
       </Troubleshooter>
    </EnergyReport>

    Pro výše uvedený importní soubor v definici importu nastavíme:

    XML cesta k položce:

    /a:EnergyReport/a:Troubleshooter/a:AnalysisLog/a:LogEntry/a:Details/a:Detail

    Importní sloupce:

    ../../../..@@guid

    ../..@@guid

    ../../a:Name

    ../../a:Severity

    @@guid

    a:Name

    a:Value

    Namespace na záložce Xml:

    a http://schemas.microsoft.com/energy/2007

    V tomto článku
    ×