Use of XML data source with Meta structure in XML

Hi, I'm new in Birt and work on some testings. I try to use XML datasource with xml-files having a meta definition with rows having all data. I can't get the row mapping and column mapping to work in my 2.5 version of Birt. 
 
Have any of you a solution to make it work ? 
 
Look forward to your feedback 
 
Best regards Per 
 
 
 
 
Below is a sample of my xml : 
 
<?xml version="1.0" encoding="UTF-16"?> 
 
<SQLXMLExport> 
<Meta> 
<OutputExpressions> 
<Column tableName="FAKTURA_HODE" tableAlias="Fakturahode" name="AKTOER_NR_EGEN_ORG" pk="Y" alias="FAKTURA_HODE_AKTOER_NR_EGEN_ORG"/> 
<Column tableName="FAKTURA_HODE" tableAlias="Fakturahode" name="BILAG_NR" pk="Y" alias="FAKTURA_HODE_BILAG_NR"/> 
<Column tableName="FAKTURA_HODE" tableAlias="Fakturahode" name="FAKTURA_DATO" alias="FAKTURA_DATO"/> 
<Column tableName="FAKTURA_HODE" tableAlias="Fakturahode" name="FORFALLS_DATO" alias="FORFALLS_DATO"/> 
<Column tableName="FAKTURA_LINJE" tableAlias="Fakturalinje" name="AKTOER_NR_EGEN_ORG" pk="Y" alias="FAKTURA_LINJE_AKTOER_NR_EGEN_ORG"/> 
<Column tableName="FAKTURA_LINJE" tableAlias="Fakturalinje" name="BILAG_NR" pk="Y" alias="FAKTURA_LINJE_BILAG_NR"/> 
<Column tableName="FAKTURA_LINJE" tableAlias="Fakturalinje" name="LINJE_NR" pk="Y" alias="LINJE_NR"/> 
<Column tableName="FAKTURA_LINJE" tableAlias="Fakturalinje" name="PROD_NR" alias="PROD_NR"/> 
<Column tableName="FAKTURA_LINJE" tableAlias="Fakturalinje" name="PROD_NAVN" alias="PROD_NAVN"/> 
<Column tableName="FAKTURA_LINJE" tableAlias="Fakturalinje" name="BESTILT" alias="BESTILT"/> 
<Column tableName="FAKTURA_LINJE" tableAlias="Fakturalinje" name="FAKTURERT" alias="FAKTURERT"/> 
<Column tableName="FAKTURA_LINJE" tableAlias="Fakturalinje" name="REST" alias="REST"/> 
<Column tableName="FAKTURA_LINJE" tableAlias="Fakturalinje" name="ENHET" alias="ENHET"/> 
<Column tableName="FAKTURA_LINJE" tableAlias="Fakturalinje" name="ENHET_PRIS" alias="ENHET_PRIS"/> 
<Column tableName="FAKTURA_LINJE" tableAlias="Fakturalinje" name="NETTO_PRIS" alias="NETTO_PRIS"/> 
<Column tableName="FAKTURA_LINJE" tableAlias="Fakturalinje" name="RABATT" alias="RABATT"/> 
<Column tableName="FAKTURA_LINJE" tableAlias="Fakturalinje" name="KVANTUM" alias="KVANTUM"/> 
<Column tableName="FAKTURA_LINJE" tableAlias="Fakturalinje" name="BELOEP_NETTO" alias="BELOEP_NETTO"/> 
<Column tableName="FAKTURA_LINJE" tableAlias="Fakturalinje" name="REGN_AAR" pk="Y" alias="FAKTURA_LINJE_REGN_AAR"/> 
<Column tableName="FAKTURA_LINJE" tableAlias="Fakturalinje" name="FRITEKST" alias="FRITEKST"/> 
<Column tableName="FAKTURA_LINJE" tableAlias="Fakturalinje" name="PERIODE_TEKST" alias="PERIODE_TEKST"/> 
<Column tableName="FAKTURA_LINJE" tableAlias="Fakturalinje" name="AVTALE_TYPE" alias="AVTALE_TYPE"/> 
<Column tableName="FAKTURA_LINJE" tableAlias="Fakturalinje" name="AVGIFT_KODE" alias="AVGIFT_KODE"/> 
</OutputExpressions> 
</Meta> 
<Rows> 
<Row> 
<Field alias="FAKTURA_HODE_AKTOER_NR_EGEN_ORG">1003</Field> 
<Field alias="FAKTURA_HODE_BILAG_NR">220112</Field> 
<Field alias="FAKTURA_DATO">07.07.2009</Field> 
<Field alias="FORFALLS_DATO">22.07.2009</Field> 
<Field alias="FAKTURA_LINJE_AKTOER_NR_EGEN_ORG">1003</Field> 
<Field alias="FAKTURA_LINJE_BILAG_NR">220112</Field> 
<Field alias="LINJE_NR">3</Field> 
<Field alias="PROD_NR">613023498018</Field> 
<Field alias="PROD_NAVN">Hilti koffert</Field> 
<Field alias="BESTILT">1</Field> 
<Field alias="FAKTURERT">1</Field> 
<Field alias="REST">0</Field> 
<Field alias="ENHET">Stykk</Field> 
<Field alias="ENHET_PRIS">6,00</Field> 
<Field alias="NETTO_PRIS">0,00</Field> 
<Field alias="RABATT">0,00</Field> 
<Field alias="KVANTUM">1,00</Field> 
<Field alias="BELOEP_NETTO">6,00</Field> 
<Field alias="FAKTURA_LINJE_REGN_AAR">2009</Field> 
<Field alias="FRITEKST">Avtale : FL�TE-10831-31</Field> 
<Field alias="PERIODE_TEKST">01.07.2009 - 31.07.2009</Field> 
<Field alias="AVTALE_TYPE">FL�TE</Field> 
<Field alias="AVGIFT_KODE">1</Field> 
</Row> 
<Row> 
<Field alias="FAKTURA_HODE_AKTOER_NR_EGEN_ORG">1003</Field> 
<Field alias="FAKTURA_HODE_BILAG_NR">220112</Field> 
<Field alias="FAKTURA_DATO">07.07.2009</Field> 
<Field alias="FORFALLS_DATO">22.07.2009</Field> 
<Field alias="FAKTURA_LINJE_AKTOER_NR_EGEN_ORG">1003</Field> 
<Field alias="FAKTURA_LINJE_BILAG_NR">220112</Field> 
<Field alias="LINJE_NR">4</Field> 
<Field alias="PROD_NR">7285364</Field> 
<Field alias="PROD_NAVN">Batteridrill Hilti SF121A12v3</Field> 
<Field alias="BESTILT">1</Field> 
<Field alias="FAKTURERT">1</Field> 
<Field alias="REST">0</Field> 
<Field alias="ENHET">Stykk</Field> 
<Field alias="ENHET_PRIS">154,00</Field> 
<Field alias="NETTO_PRIS">0,00</Field> 
<Field alias="RABATT">0,00</Field> 
<Field alias="KVANTUM">1,00</Field> 
<Field alias="BELOEP_NETTO">154,00</Field> 
<Field alias="FAKTURA_LINJE_REGN_AAR">2009</Field> 
<Field alias="FRITEKST">Avtale : FL�TE-10831-31</Field> 
<Field alias="PERIODE_TEKST">01.07.2009 - 31.07.2009</Field> 
<Field alias="AVTALE_TYPE">FL�TE</Field> 
<Field alias="AVGIFT_KODE">1</Field> 
</Row> 
</Rows> 
</SQLXMLExport> 
 
 
 
 
and this is my xsd ; 
<?xml version="1.0" encoding="utf-8" ?> 
 
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema"> 
<xs:element name="SQLXMLExport"> 
<xs:complexType> 
<xs:sequence> 
<xs:element minOccurs="0" name="Meta"> 
<xs:complexType> 
<xs:sequence> 
<xs:element minOccurs="0" name="OutputExpressions"> 
<xs:complexType> 
<xs:sequence> 
<xs:element minOccurs="0" maxOccurs="unbounded" name="Column"> 
<xs:complexType> 
<xs:attribute name="tableName" type="xs:string" use="optional" /> 
<xs:attribute name="tableAlias" type="xs:string" use="optional" /> 
<xs:attribute name="name" type="xs:string" use="optional" /> 
<xs:attribute name="pk" type="xs:string" use="optional" /> 
<xs:attribute name="alias" type="xs:string" use="optional" /> 
</xs:complexType> 
</xs:element> 
</xs:sequence> 
</xs:complexType> 
</xs:element> 
</xs:sequence> 
</xs:complexType> 
</xs:element> 
<xs:element minOccurs="0" name="Rows"> 
<xs:complexType> 
<xs:sequence> 
<xs:element minOccurs="0" maxOccurs="unbounded" name="Row"> 
<xs:complexType> 
<xs:sequence> 
<xs:element minOccurs="0" maxOccurs="unbounded" name="Field"> 
<xs:complexType> 
<xs:simpleContent> 
<xs:extension base="xs:string"> 
<xs:attribute name="alias" type="xs:string" use="optional" /> 
</xs:extension> 
</xs:simpleContent> 
</xs:complexType> 
</xs:element> 
</xs:sequence> 
</xs:complexType> 
</xs:element> 
</xs:sequence> 
</xs:complexType> 
</xs:element> 
</xs:sequence> 
</xs:complexType> 
</xs:element> 
</xs:schema>

Find more posts tagged with

Comments

cosima399

I have tried now to see if others got this problem. I saw a comment on XML datas ource and that it only see flat structures. I then wonder if it manage one xml-file per data source and if the one file is flat it means I only can read data from one table in the Birt report ?

Please help a non skilled in Birt ?