F-Script

Auslesen einer xml-Datei mit Adressdaten

<?xml version="1.0" encoding="utf-8"?>
<root>
  <quality>CERTIFIED</quality>
  <expires>20141118T110056+0100</expires>
   <address>
    <id>034ce086-c9bb-49df-9ed1-1b674e6d5717</id>
    <type>DOMICILE</type>
  <addresse>
    <title>MISTER</title>
    <firstName>Hans</firstName>
    <lastName>Muster</lastName>
  </addresse>
   <geographicalInfo>
     <house>
       <street>Musterstrasse</street>
       <houseNumber>1</houseNumber>
       <houseKey>76439798</houseKey>
     </house>
     <zip>
       <zip>6000</zip>
       <city>Luzern</city>
     </zip>
   </geographicalInfo>
  </address>
   <address>
    <id>034ce086-c9bb-49df-9ed1-1b674e6d5717</id>
    <type>DOMICILE</type>
  <addresse>
    <title>COMPANY</title>
    <firstName></firstName>
    <lastName>Opacc Software AG</lastName>
  </addresse>
   <geographicalInfo>
     <house>
       <street>Industriestrasse</street>
       <houseNumber>13</houseNumber>
     <houseKey>123456789</houseKey>
     </house>
     <zip>
       <zip>6010</zip>
       <city>Kriens</city>
     </zip>
   </geographicalInfo>
  </address>
</root>

Common.XmlQuery
SourceFile=mytest.xml
Rows=/root/address
Column=Title,addresse/title
Column=FirstName,addresse/firstName
Column=LastName,addresse/lastName
Column=Street,geographicalInfo/house/street
Column=HouseNumber,geographicalInfo/house/houseNumber
Column=Zip,geographicalInfo/zip/zip
Column=City,geographicalInfo/zip/city