1. XML import

    Article: AN0001933Updated:

    There are examples of xml imports described on this page.

    Import of elements according to attribute name

    In some cases we need to read values of xml elements depending on attribute name. ObjectGears supports that without need to perform xslt transformation.

    Example xml file:

    <?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>

    We will set in the import definition following settings in order to import above stated file:

    XML path to item:

    /Objects/Object

    Import columns:

    Property[@Name="LoginWithDomain"]

    Property[@Name="Login"]

    Property[@Name="Displayname"]

    etc...

    Import by using namespace

    ObjectGears supports to import data from xml file of below stated structure.

    <?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>

    We will set in the import definition following settings in order to import above stated file:

    XML path to item:

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

    Import columns:

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

    ../..@@guid

    ../../a:Name

    ../../a:Severity

    @@guid

    a:Name

    a:Value

    Namespace on tab Xml:

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

×