XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Taron BarberSubject: CSV to XML conversion help
Author: Taron Barber
Date: 18 Mar 2008 05:36 PM
Hi,

I have just begun to work with XML and am in the process of trying to convert a csv file to XML but am having trouble. I need to get a CDATA section under one of the field elements. I need to get it setup to import as follows:

<inv>
<inventory>
<sku>
<quantity>
<url><![CDATA [import data from csv file.........
</inventory
</inv>



I can not get it to format in this way. I can only get it to import as follows:

<inv>
<inventory>
<sku>
<quantity>
<url>
</inventory>
</inv>

How do I get that CDATA section under the <url> field element?

I hope this makes a little sense. I just started getting involved in XML so I dont really know the correct terminology.

Thank you for any help


Posttop
Alberto MassariSubject: CSV to XML conversion help
Author: Alberto Massari
Date: 19 Mar 2008 06:19 AM
Hi,
ths CSV to XML converter doesn't allow to specify whether the data should be enclosed in CDATA sections, as in XML the CDATA section is just a syntactic feature that allows a user to freely type any text without the need of escaping the reserved characters (i.e. it's only useful if a human being is actually typing the data).
So an XML-compliant parser should find no difference between <[CDATA[http://www.xxxx.com/some/URL?key=value&key=value]]> and http://www.xxxx.com/some/URL?key=value&amp;key=value (note that & turned into &amp;). As a workaround, if your requirement to use CDATA sections cannot be avoided, you can post process the generated XML with an XSL indentity transformation that specifies the cdata-section-elements="url" attribute in the xsl:output instruction.

Hope this helps,
Alberto

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.