Re: [xsl] csv data to xml

[henry human <henry_human@xxxxxxxx>]

I had some problem to rund the XSLT not localy and working with files but with
on  Web server and working with string.
So I used some java based code and
build the xml! 
Could you tell mme how to modify the XSLT to be able call it
on server(I removed the CSV file reference but did not work? 
brg
henry
----- Urspr|ngliche Message -----
Von: Andrew Welch <andrew.j.welch@xxxxxxxxx>
An: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
CC: 
Gesendet: 17:39 Donnerstag, 27.Juni
2013
Betreff: Re: [xsl] csv data to xml

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/
>>
>>
--~------------------------------------------------------------------
>>
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>
>> --~--
>>
>
>
>
--~------------------------------------------------------------------
>
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>
> --~--
>



-- 
Andrew
Welch
http://andrewjwelch.com/