Subject: Re: [xsl] csv data to xml From: Andrew Welch <andrew.j.welch@xxxxxxxxx> Date: Thu, 27 Jun 2013 16:39:57 +0100 |
You appear to have changed the output from the xslt I linked to? You should have rows wrapping your elements, once you reinstate them then how to achieve the 2nd part of your process becomes clearer. On 27 June 2013 16:28, henry human <henry_human@xxxxxxxx> wrote: > 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/ > -- Andrew Welch http://andrewjwelch.com
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] csv data to xml, henry human | Thread | Re: [xsl] csv data to xml, henry human |
Re: [xsl] csv data to xml, henry human | Date | Re: [xsl] csv data to xml, henry human |
Month |