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
Conferences Close Tree View
+ Stylus Studio Feature Requests (1189)
- Stylus Studio Technical Forum (14588)
-> + Cannot create SQL Server datas... (11)
-> + StylusValidator Crashes (2)
-> + XML diff with optimize Change ... (2)
-> + how do I get the .xsl page to ... (3)
-> + Can't Use WYSIWYG from the Fil... (6)
-> + EDI Help (2)
-> + XInclude support (3)
-> + Editor options and customized ... (3)
-> + Licensed version connectes to ... (6)
-> + handling abstract types in the... (5)
-> + XML not validating against its... (4)
-> + SS gets into state where the "... (6)
-> + Download Link from Order email... (2)
-> + Stylus Studio doesn't run (2)
-> + Indent XML Tags uses pretty sh... (2)
-> + Some questions on supported pl... (3)
-> + Apache FOP Border (2)
-> + line numbers, line-wrap.. (11)
-> + Not Able to Load Siebel Web Se... (3)
-> + XSLT node or nodeset as scenar... (4)
-> - tree view parsing error: Expec... (1)
-> + reactivating the license key f... (2)
-> + XSL FO region-body border (2)
-> + WhiteSpace facet default (2)
-> - Web Service Call (1)
-> + DB to XML convertion (6)
-> + Converting: How to handle data... (2)
-> + Toss Character Exception (2)
-> + EDI conversion COM segment (5)
-> - SS passing invalid CALS table ... (1)
-> + Carrier Related EDI SAP questi... (2)
-> + How to generate 1 output XML f... (2)
-> + Urgent Eval: How2 w/ Possibly ... (4)
-> + Preview Problems (7)
-> + Mapping to EDIFACT ORDERS UNT0... (8)
-> + Deploying Conversion XML to ED... (2)
-> + Use EDI Adapter within Sap BC (3)
-> + Uninstall->instal entepr. 2007 (2)
-> - xml data to sql 2000 table (1)
-> - Convert from Oracle DB to XML ... (1)
-> + NTFShardlink broken (5)
-> + Can't get catalog to work (3)
-> + Only One of each EDI segment g... (3)
-> + convert (2)
-> + convert (4)
-> + EDIFACT to XSD problem (3)
-> + quark xpress tags (2)
-> + Duplicating nodes allows to cr... (2)
-> + Duplicated, unused nodes are r... (3)
-> + Converting to XML from a varie... (5)
-> + xsd:import's with escaped char... (8)
-> + Viewing the FO Sample Applicat... (3)
-> + Stylus Studio - Window tiling (3)
-> + Question about XML->Java Objec... (2)
-> + SVG web-based editor (2)
-> + conversion process for the pdf... (2)
-> + GUI Mapper does not create pro... (4)
-> + JavaScript working inside prev... (4)
-> + Stylus Studio Crashes when I a... (4)
-> + SVG ImageReader for FOP (2)
-> + Web Service Call Using HTTPS (8)
-> + Meditech database (2)
-> + How to connect to Informix (5)
-> + long filenames in Berkeley XML... (3)
-> + Opening multiple documents = m... (3)
-> + MySQL Connectivity (2)
-> + using .xsd to create forms (3)
-> + Convert-to-XML Engine could no... (2)
-> + editor questions (2)
-> + Cannot connect to SQL server (7)
-> + Convert Cobol file to XML (2)
-> + XML Diff problem (4)
-> + running XSLT - time + memory m... (7)
-> + New wsdl creation (4)
-> + DB to XML Parameters (2)
-> + Help (html in xml) need to out... (8)
-> + Stylesheet questions (2)
-> + Verion 1.0 XPATH for testing "... (5)
-> + Berkely XML DB file system (2)
-> + WYSIWYG in 2007 demo (2)
-> + EDIFACT code list problem (3)
-> + XQuery over a Berkeley XML DB ... (3)
-> + Href and display linked ref. (2)
-> + How my applications can gener... (11)
-> + CLASSPATH (2)
-> + Fixed order of attributes (2)
-> + merging XML files (13)
-> - The Struzzo.exe hung with no G... (1)
-> + Problem Registering Old Versio... (4)
-> + CHART.XML + CHART.XSL to CHART... (17)
-> + Aplication not loading (6)
-> + Can Stylus Studio be used to s... (2)
-> + Dynamic SVG (2)
-> + How to get Stylus Studio's pre... (3)
-> + XSL & RDBXML : Retrieving mos... (4)
-> - Please Help! Converting CSV t... (8)
-> ->Please Help! Converting ...
-> ->Please Help! Converting ...
-> ->Please Help! Converting ...
-> ->Please Help! Converting ...
-> ->Please Help! Converting ...
-> ->Please Help! Converting ...
-> ->Please Help! Converting ...
-> + Converting a directory of text... (2)
-> + How to use Bookmarks in XSD ? (2)
-> + any feature to create a Flatte... (4)
-> + 3d Pie Chart using SVG (4)
-- Previous [1801-1820] [1821-1840] [1841-1860] Next
+ Website Feedback (247)
+ XSLT Help and Discussion (7619)
+ XQuery Help and Discussion (1976)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Roman HammesSubject: Please Help! Converting CSV to XML with HTML in CDATA is getting escaped
Author: Roman Hammes
Date: 19 Oct 2006 12:32 PM
Hi,

I just downloaded Sylus Studio yesterday, so this may be total user error.

I have a CSV field that is encompassed in a CDATA element that also contains HTML markup, like so:
"<[CDATA[<b>test</b>]]>"

I expect (and need) this to come over unescaped, like:
<field><[CDATA[<b>test</b>]]></field>

But what I get is:
<field>&lt;![CDATA[&lt;b>test&lt;/b>]]></field>

How can I get the convert from CSV to XML to honor the CDATA and eliminate the escapes?

Thank you - so far Stylus looks very good!

Postnext
Tony LavinioSubject: Please Help! Converting CSV to XML with HTML in CDATA is getting escaped
Author: Tony Lavinio
Date: 20 Oct 2006 02:18 AM
The adapter won't help with this, since CSV files have no notion
of CDATA.

You could try running the output from the adapter through a XSLT
program and using disable-output-escaping, although it's kind of
a yucky (meaning non-elegant, not necessarily wrong) solution.

See http://www.dpawson.co.uk/xsl/sect2/N2215.html for details.

Postnext
Roman HammesSubject: Please Help! Converting CSV to XML with HTML in CDATA is getting escaped
Author: Roman Hammes
Date: 20 Oct 2006 10:56 AM
Thank you for your help!

I would rather that the tool do this, but it is good to know that it won't and I appreciate the info on disable-output-escaping.

Thanks again,
Roman

Postnext
Ivan PedruzziSubject: Please Help! Converting CSV to XML with HTML in CDATA is getting escaped
Author: Ivan Pedruzzi
Date: 20 Oct 2006 11:26 AM
Hi Roman,

Out of curiosity could you please tell us which product is generating such format?

Thank You for your help
Ivan Pedruzzi
Stylus Studio Team

Postnext
Roman HammesSubject: Please Help! Converting CSV to XML with HTML in CDATA is getting escaped
Author: Roman Hammes
Date: 21 Oct 2006 12:47 AM
I'm not sure what you are asking - I downloaded Stylus Studio Enterprise 2007, ran the File >> New >> Convert to XML, accepted defaults and ran the conversion.
It did a great job of conversion, except for the escaping everything contained in CDATA.
Anything in CDATA should not be touched... Is there a setting which would allow me to turn off escaping based on CSV field?

Postnext
Ivan PedruzziSubject: Please Help! Converting CSV to XML with HTML in CDATA is getting escaped
Author: Ivan Pedruzzi
Date: 21 Oct 2006 10:55 AM

What I am asking is which software is creating CSV files with embedded CDATA sections?

Thanks
Ivan

Postnext
Tony LavinioSubject: Please Help! Converting CSV to XML with HTML in CDATA is getting escaped
Author: Tony Lavinio
Date: 23 Oct 2006 10:19 AM
The point is that CDATA is not a part of CSV - it's an XML thing.
A parser for CDATA wouldn't know what CDATA is - since it really
doesn't know what anything is.

However, your problem is intriguing to us, and we'd like to know
more so that we can find a way to help you and others.

We could change things so that we pass through a field unaltered,
but that would still put a CDATA section in your output, and what's
in it would be character content and not elements.

Understanding who (that is, what program) is generating this odd
content and how you need it is key to our understanding this
issue and potentially implementing a solution.

Posttop
Roman HammesSubject: Please Help! Converting CSV to XML with HTML in CDATA is getting escaped
Author: Roman Hammes
Date: 23 Oct 2006 03:31 PM
Originally Posted: 23 Oct 2006 03:24 PM
I am converting data from one source to another.
Coming in, I have an Excel spreadsheet. I massage this data with various functions (one of which wraps some cells in CDATA tags) and then "save as" CSV.
There is nothing magic to the input file - I just want Sylus to honor the CDATA tag when it finds it or provide a means to override output escaping by field.
So, it is nice that Stylus CSV to XML will correctly escape troubleshome characters as a default, but it would be an extremely strong selling point if:
a) it could either pick up a valid CDATA section and leave it alone
b) you could check / uncheck "disable-output-escaping" per field
c) or if it had some kind of extensibility that allowed the option of editing what gets sent out to the xml file (say if it was VBA, it would look something like onConvertField(DataIn) as string, where the user could intercept the automatic conversion and massage DataIn and then send it out to get the change captured.

Oh - just to make this clear - the CDATA fields in the input CSV is not escaped (viewing in Notepad shows < verses &lt;)

Thank you again for your time,
Roman

   
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.