verarbeiten von XML Daten

Ich kriege es einfach nicht hin, dass gewisse Attribute in XML ausgelesen werden und ebenfalls wie die anderen Attribute durch Semikolon getrennt werden. Das Feld EAN, KEYWORD.... hängen alle ungetrennt beieinander.

Ich weiss einfach nicht, wo der Fehler liegt.

Hier einmal die XML und XSL Datei

<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="C:\Dokumente und Einstellungen\markus\Desktop\fahrplan\csv-template-new-line.xsl"?>
<BME>
<ARTICLE>
<SUPPLIER_AID>40603150</SUPPLIER_AID>
<ARTICLE_DETAILS>
<DESCRIPTION_SHORT>Schraubend.-Eins.1/4" 6kt 3x30mm FORUM</DESCRIPTION_SHORT>
<DESCRIPTION_LONG>Schraubendrehereinsatz 1/4" für Innensechskantschrauben, Forum

Innensechskant, aus Chrom-Vanadium-Stahl, matt verchromt, Bit-Einsatz matt grau.
* Nicht genormte Größen.</DESCRIPTION_LONG>
<EAN>4317784847476</EAN>
<KEYWORD>FORUM</KEYWORD>
<KEYWORD>Innensechskantschrauben</KEYWORD>
<KEYWORD>Schraubendreher-Einsätze</KEYWORD>
<KEYWORD>1/4 Zoll</KEYWORD>
<KEYWORD>1/4"</KEYWORD>
<KEYWORD>Steckschlüssel-Programm</KEYWORD>
</ARTICLE_DETAILS>
<ARTICLE_FEATURES>
<REFERENCE_FEATURE_SYSTEM_NAME>ECLASS-5.1</REFERENCE_FEATURE_SYSTEM_NAME>
<REFERENCE_FEATURE_GROUP_ID>21040402</REFERENCE_FEATURE_GROUP_ID>
<FEATURE>
<FNAME>Schlüsselweite</FNAME>
<FVALUE>3</FVALUE>
<FUNIT>mm</FUNIT>
<FORDER>2</FORDER>
</FEATURE>
<FEATURE>
<FNAME>Länge</FNAME>
<FVALUE>30</FVALUE>
<FUNIT>mm</FUNIT>
<FORDER>3</FORDER>
</FEATURE>
<FEATURE>
<FNAME>WG-Nr.</FNAME>
<FVALUE>939</FVALUE>
<FORDER>16</FORDER>
</FEATURE>
</ARTICLE_FEATURES>
<ARTICLE_ORDER_DETAILS>
<ORDER_UNIT>C62</ORDER_UNIT>
<PRICE_QUANTITY>1</PRICE_QUANTITY>
<QUANTITY_MIN>1</QUANTITY_MIN>
<QUANTITY_INTERVAL>1</QUANTITY_INTERVAL>
</ARTICLE_ORDER_DETAILS>
<ARTICLE_PRICE_DETAILS>
<ARTICLE_PRICE price_type="net_list">
<PRICE_AMOUNT>2.51</PRICE_AMOUNT>
<PRICE_CURRENCY>EUR</PRICE_CURRENCY>
</ARTICLE_PRICE>
</ARTICLE_PRICE_DETAILS>
<MIME_INFO>
<MIME>
<MIME_TYPE>image/jpeg</MIME_TYPE>
<MIME_SOURCE>qwz109163.jpg</MIME_SOURCE>
<MIME_DESCR>42 40603...</MIME_DESCR>
<MIME_PURPOSE>normal</MIME_PURPOSE>
<MIME_ORDER>1</MIME_ORDER>
</MIME>
<MIME>
<MIME_TYPE>image/jpeg</MIME_TYPE>
<MIME_SOURCE>pre308048.jpg</MIME_SOURCE>
<MIME_PURPOSE>logo</MIME_PURPOSE>
<MIME_ORDER>2</MIME_ORDER>
</MIME>
<MIME>
<MIME_TYPE>image/jpeg</MIME_TYPE>
<MIME_SOURCE>wzk309614.jpg</MIME_SOURCE>
<MIME_PURPOSE>others</MIME_PURPOSE>
<MIME_ORDER>3</MIME_ORDER>
</MIME>
</MIME_INFO>
</ARTICLE>
<ARTICLE>
<SUPPLIER_AID>40603153</SUPPLIER_AID>
<ARTICLE_DETAILS>
<DESCRIPTION_SHORT>Schraubend.-Eins.1/4" 6kt 4x30mm FORUM</DESCRIPTION_SHORT>
<DESCRIPTION_LONG>Schraubendrehereinsatz 1/4" für Innensechskantschrauben, Forum

Innensechskant, aus Chrom-Vanadium-Stahl, matt verchromt, Bit-Einsatz matt grau.
* Nicht genormte Größen.</DESCRIPTION_LONG>
<EAN>4317784847483</EAN>
<KEYWORD>FORUM</KEYWORD>
<KEYWORD>Innensechskantschrauben</KEYWORD>
<KEYWORD>Schraubendreher-Einsätze</KEYWORD>
<KEYWORD>1/4 Zoll</KEYWORD>
<KEYWORD>1/4"</KEYWORD>
<KEYWORD>Steckschlüssel-Programm</KEYWORD>
</ARTICLE_DETAILS>
<ARTICLE_FEATURES>
<REFERENCE_FEATURE_SYSTEM_NAME>ECLASS-5.1</REFERENCE_FEATURE_SYSTEM_NAME>
<REFERENCE_FEATURE_GROUP_ID>21040402</REFERENCE_FEATURE_GROUP_ID>
<FEATURE>
<FNAME>Schlüsselweite</FNAME>
<FVALUE>4</FVALUE>
<FUNIT>mm</FUNIT>
<FORDER>2</FORDER>
</FEATURE>
<FEATURE>
<FNAME>Länge</FNAME>
<FVALUE>30</FVALUE>
<FUNIT>mm</FUNIT>
<FORDER>3</FORDER>
</FEATURE>
<FEATURE>
<FNAME>WG-Nr.</FNAME>
<FVALUE>939</FVALUE>
<FORDER>16</FORDER>
</FEATURE>
</ARTICLE_FEATURES>
<ARTICLE_ORDER_DETAILS>
<ORDER_UNIT>C62</ORDER_UNIT>
<PRICE_QUANTITY>1</PRICE_QUANTITY>
<QUANTITY_MIN>1</QUANTITY_MIN>
<QUANTITY_INTERVAL>1</QUANTITY_INTERVAL>
</ARTICLE_ORDER_DETAILS>
<ARTICLE_PRICE_DETAILS>
<ARTICLE_PRICE price_type="net_list">
<PRICE_AMOUNT>2.51</PRICE_AMOUNT>
<PRICE_CURRENCY>EUR</PRICE_CURRENCY>
</ARTICLE_PRICE>
</ARTICLE_PRICE_DETAILS>
<MIME_INFO>
<MIME>
<MIME_TYPE>image/jpeg</MIME_TYPE>
<MIME_SOURCE>qwz109163.jpg</MIME_SOURCE>
<MIME_DESCR>42 40603...</MIME_DESCR>
<MIME_PURPOSE>normal</MIME_PURPOSE>
<MIME_ORDER>1</MIME_ORDER>
</MIME>
<MIME>
<MIME_TYPE>image/jpeg</MIME_TYPE>
<MIME_SOURCE>pre308048.jpg</MIME_SOURCE>
<MIME_PURPOSE>logo</MIME_PURPOSE>
<MIME_ORDER>2</MIME_ORDER>
</MIME>
<MIME>
<MIME_TYPE>image/jpeg</MIME_TYPE>
<MIME_SOURCE>wzk309614.jpg</MIME_SOURCE>
<MIME_PURPOSE>others</MIME_PURPOSE>
<MIME_ORDER>3</MIME_ORDER>
</MIME>
</MIME_INFO>
</ARTICLE>
<ARTICLE>
<SUPPLIER_AID>40603156</SUPPLIER_AID>
<ARTICLE_DETAILS>
<DESCRIPTION_SHORT>Schraubend.-Eins.1/4" 6kt 5x30mm FORUM</DESCRIPTION_SHORT>
<DESCRIPTION_LONG>Schraubendrehereinsatz 1/4" für Innensechskantschrauben, Forum

Innensechskant, aus Chrom-Vanadium-Stahl, matt verchromt, Bit-Einsatz matt grau.
* Nicht genormte Größen.</DESCRIPTION_LONG>
<EAN>4317784847490</EAN>
<KEYWORD>FORUM</KEYWORD>
<KEYWORD>Innensechskantschrauben</KEYWORD>
<KEYWORD>Schraubendreher-Einsätze</KEYWORD>
<KEYWORD>1/4 Zoll</KEYWORD>
<KEYWORD>1/4"</KEYWORD>
<KEYWORD>Steckschlüssel-Programm</KEYWORD>
</ARTICLE_DETAILS>
<ARTICLE_FEATURES>
<REFERENCE_FEATURE_SYSTEM_NAME>ECLASS-5.1</REFERENCE_FEATURE_SYSTEM_NAME>
<REFERENCE_FEATURE_GROUP_ID>21040402</REFERENCE_FEATURE_GROUP_ID>
<FEATURE>
<FNAME>Schlüsselweite</FNAME>
<FVALUE>5</FVALUE>
<FUNIT>mm</FUNIT>
<FORDER>2</FORDER>
</FEATURE>
<FEATURE>
<FNAME>Länge</FNAME>
<FVALUE>30</FVALUE>
<FUNIT>mm</FUNIT>
<FORDER>3</FORDER>
</FEATURE>
<FEATURE>
<FNAME>WG-Nr.</FNAME>
<FVALUE>939</FVALUE>
<FORDER>16</FORDER>
</FEATURE>
</ARTICLE_FEATURES>
<ARTICLE_ORDER_DETAILS>
<ORDER_UNIT>C62</ORDER_UNIT>
<PRICE_QUANTITY>1</PRICE_QUANTITY>
<QUANTITY_MIN>1</QUANTITY_MIN>
<QUANTITY_INTERVAL>1</QUANTITY_INTERVAL>
</ARTICLE_ORDER_DETAILS>
<ARTICLE_PRICE_DETAILS>
<ARTICLE_PRICE price_type="net_list">
<PRICE_AMOUNT>2.51</PRICE_AMOUNT>
<PRICE_CURRENCY>EUR</PRICE_CURRENCY>
</ARTICLE_PRICE>
</ARTICLE_PRICE_DETAILS>
<MIME_INFO>
<MIME>
<MIME_TYPE>image/jpeg</MIME_TYPE>
<MIME_SOURCE>qwz109163.jpg</MIME_SOURCE>
<MIME_DESCR>42 40603...</MIME_DESCR>
<MIME_PURPOSE>normal</MIME_PURPOSE>
<MIME_ORDER>1</MIME_ORDER>
</MIME>
<MIME>
<MIME_TYPE>image/jpeg</MIME_TYPE>
<MIME_SOURCE>pre308048.jpg</MIME_SOURCE>
<MIME_PURPOSE>logo</MIME_PURPOSE>
<MIME_ORDER>2</MIME_ORDER>
</MIME>
<MIME>
<MIME_TYPE>image/jpeg</MIME_TYPE>
<MIME_SOURCE>wzk309614.jpg</MIME_SOURCE>
<MIME_PURPOSE>others</MIME_PURPOSE>
<MIME_ORDER>3</MIME_ORDER>
</MIME>
</MIME_INFO>
</ARTICLE>
<ARTICLE>
<SUPPLIER_AID>40603159</SUPPLIER_AID>
<ARTICLE_DETAILS>
<DESCRIPTION_SHORT>Schraubend.-Eins.1/4" 6kt 6x30mm FORUM</DESCRIPTION_SHORT>
<DESCRIPTION_LONG>Schraubendrehereinsatz 1/4" für Innensechskantschrauben, Forum

Innensechskant, aus Chrom-Vanadium-Stahl, matt verchromt, Bit-Einsatz matt grau.
* Nicht genormte Größen.</DESCRIPTION_LONG>
<EAN>4317784847506</EAN>
<KEYWORD>FORUM</KEYWORD>
<KEYWORD>Innensechskantschrauben</KEYWORD>
<KEYWORD>Schraubendreher-Einsätze</KEYWORD>
<KEYWORD>1/4 Zoll</KEYWORD>
<KEYWORD>1/4"</KEYWORD>
<KEYWORD>Steckschlüssel-Programm</KEYWORD>
</ARTICLE_DETAILS>
<ARTICLE_FEATURES>
<REFERENCE_FEATURE_SYSTEM_NAME>ECLASS-5.1</REFERENCE_FEATURE_SYSTEM_NAME>
<REFERENCE_FEATURE_GROUP_ID>21040402</REFERENCE_FEATURE_GROUP_ID>
<FEATURE>
<FNAME>Schlüsselweite</FNAME>
<FVALUE>6</FVALUE>
<FUNIT>mm</FUNIT>
<FORDER>2</FORDER>
</FEATURE>
<FEATURE>
<FNAME>Länge</FNAME>
<FVALUE>30</FVALUE>
<FUNIT>mm</FUNIT>
<FORDER>3</FORDER>
</FEATURE>
<FEATURE>
<FNAME>WG-Nr.</FNAME>
<FVALUE>939</FVALUE>
<FORDER>16</FORDER>
</FEATURE>
</ARTICLE_FEATURES>
<ARTICLE_ORDER_DETAILS>
<ORDER_UNIT>C62</ORDER_UNIT>
<PRICE_QUANTITY>1</PRICE_QUANTITY>
<QUANTITY_MIN>1</QUANTITY_MIN>
<QUANTITY_INTERVAL>1</QUANTITY_INTERVAL>
</ARTICLE_ORDER_DETAILS>
<ARTICLE_PRICE_DETAILS>
<ARTICLE_PRICE price_type="net_list">
<PRICE_AMOUNT>2.51</PRICE_AMOUNT>
<PRICE_CURRENCY>EUR</PRICE_CURRENCY>
</ARTICLE_PRICE>
</ARTICLE_PRICE_DETAILS>
<MIME_INFO>
<MIME>
<MIME_TYPE>image/jpeg</MIME_TYPE>
<MIME_SOURCE>qwz109163.jpg</MIME_SOURCE>
<MIME_DESCR>42 40603...</MIME_DESCR>
<MIME_PURPOSE>normal</MIME_PURPOSE>
<MIME_ORDER>1</MIME_ORDER>
</MIME>
<MIME>
<MIME_TYPE>image/jpeg</MIME_TYPE>
<MIME_SOURCE>pre308048.jpg</MIME_SOURCE>
<MIME_PURPOSE>logo</MIME_PURPOSE>
<MIME_ORDER>2</MIME_ORDER>
</MIME>
<MIME>
<MIME_TYPE>image/jpeg</MIME_TYPE>
<MIME_SOURCE>wzk309614.jpg</MIME_SOURCE>
<MIME_PURPOSE>others</MIME_PURPOSE>
<MIME_ORDER>3</MIME_ORDER>
</MIME>
</MIME_INFO>
</ARTICLE>
</BME>

So wird es im Klartext angezeigt


40603150;Schraubend.-Eins.1/4" 6kt 3x30mm FORUMSchraubendrehereinsatz 1/4" für Innensechskantschrauben, Forum Innensechskant, aus Chrom-Vanadium-Stahl, matt verchromt, Bit-Einsatz matt grau. * Nicht genormte Größen.4317784847476FORUMInnensechskantschraubenSchraubendreher-Einsätze1/4 Zoll1/4"Steckschlüssel-Programm;ECLASS-5.121040402Schlüsselweite3mm2Länge30mm3WG-Nr.93916;C62111;2.51EUR;image/jpegqwz109163.jpg42 40603...normal1image/jpegpre308048.jpglogo2image/jpegwzk309614.jpgothers3 40603153;Schraubend.-Eins.1/4" 6kt 4x30mm FORUMSchraubendrehereinsatz 1/4" für Innensechskantschrauben, Forum Innensechskant, aus Chrom-Vanadium-Stahl, matt verchromt, Bit-Einsatz matt grau. * Nicht genormte Größen.4317784847483FORUMInnensechskantschraubenSchraubendreher-Einsätze1/4 Zoll1/4"Steckschlüssel-Programm;ECLASS-5.121040402Schlüsselweite4mm2Länge30mm3WG-Nr.93916;C62111;2.51EUR;image/jpegqwz109163.jpg42 40603...normal1image/jpegpre308048.jpglogo2image/jpegwzk309614.jpgothers3 40603156;Schraubend.-Eins.1/4" 6kt 5x30mm FORUMSchraubendrehereinsatz 1/4" für Innensechskantschrauben, Forum Innensechskant, aus Chrom-Vanadium-Stahl, matt verchromt, Bit-Einsatz matt grau. * Nicht genormte Größen.4317784847490FORUMInnensechskantschraubenSchraubendreher-Einsätze1/4 Zoll1/4"Steckschlüssel-Programm;ECLASS-5.121040402Schlüsselweite5mm2Länge30mm3WG-Nr.93916;C62111;2.51EUR;image/jpegqwz109163.jpg42 40603...normal1image/jpegpre308048.jpglogo2image/jpegwzk309614.jpgothers3 40603159;Schraubend.-Eins.1/4" 6kt 6x30mm FORUMSchraubendrehereinsatz 1/4" für Innensechskantschrauben, Forum Innensechskant, aus Chrom-Vanadium-Stahl, matt verchromt, Bit-Einsatz matt grau. * Nicht genormte Größen.4317784847506FORUMInnensechskantschraubenSchraubendreher-Einsätze1/4 Zoll1/4"Steckschlüssel-Programm;ECLASS-5.121040402Schlüsselweite6mm2Länge30mm3WG-Nr.93916;C62111;2.51EUR;image/jpegqwz109163.jpg42 40603...normal1image/jpegpre308048.jpglogo2image/jpegwzk309614.jpgothers3

DIE XSL DATEI schaut so aus

<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:eek:utput method="text" encoding="iso-8859-1"/>

<xsl:strip-space elements="*" />

<xsl:template match="/*/child::*">
<xsl:for-each select="child::*">
<xsl:if test="position() != last()"><xsl:value-of select="normalize-space(.)"/>;</xsl:if>
<xsl:if test="position() = last()"><xsl:value-of select="normalize-space(.)"/><xsl:text>
</xsl:text>
</xsl:if>
</xsl:for-each>
</xsl:template>

</xsl:stylesheet>


Wer weiss, wo der Haken ist?
 
Hi

Mal eine kurze Frage: Findest du das lesbar, was du da gepostet hast?
Nein! oder?

Bitte bearbeite deinen Post noch einmal und setz die Xml- /Xsl-Daten in Code-Tags. ;-)
Danke :)
 

Neue Beiträge

Zurück