Hi Michael,
Thanks for the alternative, but for now I want to stick with XSLT as I need
to run a second transform on the XML produced from the CSV transform to
create a specially formatted XML file that I can import into a module on a
clients dynamic website.
I have step-by-step instructions on how to do the second bit, so as I am
brand new to the world of programming (no Perl knowledge unfortunatley) I
will stick with what I have.
Thanks again,
Marney
On 4/4/08 1:09 AM, "Michael Ludwig" <mlu(_at_)as-guides(_dot_)com> wrote:
Marney Cotterill schrieb:
Hi Listers,
I have modified an XSLT orgignally developed by Andrew Welch to
transform a CSV to an XML for importing data into a dynamic website. I
am brand new to XSL and XSLT and have hit a small snag with the
transform.
Maybe XSL is not the best tool for this job. I'd use a general-purpose
programming language like Perl to process CSV to generate XML. Perl has
modules designed to deal with practically everything, including CSV. I
think this would be much easier, while at the same time taking the
discussion off-topic.
Well, you could then process the resulting XML in XSL to tailor it to
your needs, and that would bring the discussion back on topic. The
result would look something like this:
<File>
<Row>
<Col>30358201</Col>
<Col>Das VIERTE</Col>
<Col>2008-04-06</Col>
</Row>
<Row>
<Col>30376055</Col>
<Col>n-tv</Col>
<Col>2008-04-05</Col>
</Row>
<Row>
<Col>30332822</Col>
<Col>Premiere Krimi</Col>
<Col>2008-04-05</Col>
</Row>
</File>
This could then easily be processed using XSL.
If you can handle Perl, I can mail you a script to do the job.
I've done some testing and I think it comes down to the inclusion of
special characters in my CSV, which essentially breaks the transform,
giving a blank result - it does not even display the error messege.
This problem would be dealt with - unless your CSV data is invalid.
Michael
--~------------------------------------------------------------------
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(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
Marney Cotterill
graphic designer
cracker//brandware
6 Bourke Street
Queens Park
NSW 2022
Telephone 02 9387 2001
Facsimile 02 9387 2006
marney(_at_)crackerbrandware(_dot_)com
www.crackerbrandware.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(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--