Subject: Re: [xsl] csv data to xml From: henry human <henry_human@xxxxxxxx> Date: Thu, 27 Jun 2013 16:28:51 +0100 (BST) |
Hi guys I was able to convert the data from csv to xml. Now I want to build groups of the elements such as the sample bellow. Each 5 elements should be assigned to a clfPackage element: This is the CSV as xml: <?xml version="1.0" encoding="UTF-8"?> <xmlData> <element>EN</element> <element>01</element> <element>text</element> <element>U</element> <element>2013028074426</element> <element>SE</element> <element>06</element> <element>text</element> <element>M</element> <element>2013011234457</element> ....... </xmlData> This is what must be created: <clfPackage> <Country><xsl:value-of select="xmlData/element"/></CountryCode> //must be the first element <number><xsl:value-of select="xmlData/element"/></ClearingNumber> //must be the secound element <Description1><xsl:value-of select="xmlData/element"/></Description> <ChangeMode><xsl:value-of select="xmlData/element"/></ChangeMode> <Modification><xsl:value-of select="xmlData/element"/></Modification> </clfPackage> Best regards Henry ----- Urspr|ngliche Message ----- Von: Michael Kay <mike@xxxxxxxxxxxx> An: xsl-list@xxxxxxxxxxxxxxxxxxxxxx CC: Gesendet: 16:47 Mittwoch, 26.Juni 2013 Betreff: Re: [xsl] csv data to xml On 26 Jun 2013, at 15:21, henry human wrote: > Hi I was not able to run get this xslt sample runing! When I try it with Saxon 9.1.0 and (call it in Stylus Studio) I got the known > error:ontent is not allowed in prolog. That means you're doing it wrong; you're somehow putting the CSV file through an XML parser. Probably because you are supplying it as the main input to the transformation, rather than merely a secondary file to be read with unparsed-text(). Michael Kay Saxonica > ? > This was my csv file test.csv > USA,AA,Comp. 1,U,012345,L987 > USA,BB,Comp.2,Z,034567888888,F098 > USA,CC,Comp 3,M,034847474747,F098 > > > ----- Urspr|ngliche Message ----- > Von: Andrew Welch <andrew.j.welch@xxxxxxxxx> > An: xsl-list@xxxxxxxxxxxxxxxxxxxxxx > CC: > Gesendet: 15:15 Dienstag, 25.Juni 2013 > Betreff: Re: [xsl] csv data to xml > >> Use unparsed-text() to read the csv, then use tokenize() to split it >> into lines, iterate over each line outputting a <Segment>, then >> tokenize() the $line into $tokens, and use fill-in-the-blanks style to >> populate the elements. > > Basically this: > > http://andrewjwelch.com/code/xslt/csv/csv-to-xml_v2.html > > > -- > Andrew Welch > http://andrewjwelch.com/ > > --~------------------------------------------------------------------ > XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list > To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/ > or e-mail: <mailto:xsl-list-unsubscribe@xxxxxxxxxxxxxxxxxxxxxx> > --~-- > > --~------------------------------------------------------------------ > XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list > To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/ > or e-mail: <mailto:xsl-list-unsubscribe@xxxxxxxxxxxxxxxxxxxxxx> > --~--
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] csv data to xml, Michael Kay | Thread | Re: [xsl] csv data to xml, Andrew Welch |
Re: [xsl] csv data to xml, Graydon | Date | Re: [xsl] csv data to xml, Andrew Welch |
Month |