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: 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: 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
|