Re: [xsl] csv data to xml

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