XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » Please Help! Converting CSV to XML with HTML in CDATA is getting escaped
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Disabled Watch and Variable Vi... (4)
-> + Accessing Filemaker DB via ODB... (2)
-> + About XML Graphs (2)
-> + Error when generate java bindi... (2)
-> + Formatting a number to always ... (2)
-> + Bug with graphical mapper (2)
-> + Back Map to XML does not work (2)
-> + Floating Instruction Graphics (2)
-> + Mapping XSD (4)
-> + Output has dashes (Hyphens) th... (7)
-> + Fwd: Error Message (2)
-> + Error Message (5)
-> + EPG XML Generation (2)
-> + Connection to DB2 UDB (8)
-> + Instructions In Mapper (6)
-> + using oracle's orcl:right-trim... (2)
-> + xsl fo, generate links in pdf... (3)
-> + Documentation (annotations) in... (4)
-> + Linking to RDBMS to Applicatio... (2)
-> + Stylus build 653c // Metainfor... (3)
-> + namesspacing external entities (6)
-> + Suppress namespace on every no... (5)
-> + xpath: how do I get what I wan... (6)
-> + Still can't remove SS!! (2)
-> + Convert to XML (3)
-> + EDI Error (10)
-> + (500) internal server error wh... (2)
-> + Space formatting with   (4)
-> + UDDI Browser and WS Call Compo... (4)
-> + cursor weirdness (2)
-> + Open XML files in IE, edit wit... (3)
-> + Generate XML from schema (2)
-> + Line-oriented region problem i... (4)
-> + Using local DB2 database Alias... (2)
-> + Small but annoying display bug... (3)
-> + Blank values in lookup lists (11)
-> + xsd problem in mapper (2)
-> + Deployment License (2)
-> + XML post and web service (2)
-> + Stylus just wont start? (2)
-> - Can'rt remove SS from Windows ... (1)
-> + SenseX stops working on second... (4)
-> + dodgy(non-ascii) characters ca... (8)
-> + Optional values (ZZ1) causes e... (3)
-> + Have problems with displaying ... (9)
-> + Can Stylus Studio be used to m... (3)
-> + Erratic behaviour in EDIFACT a... (2)
-> + Year Calculation (2)
-> + How to ouput a real XLS (3)
-> + EDI 856 to XML - java.io.IOExc... (3)
-> + Problem transform EDI to XML (... (2)
-> + SS becomes unusable... (6)
-> + SS Enterprise 735f under WinXP... (7)
-> + Call Web Service, Nothing retu... (12)
-> + Error while debugging xslt wit... (2)
-> + DESADV D96A Schema vs XML inco... (4)
-> + Das Programm mit mysql ? (4)
-> + RegEx Search and Replace (6)
-> + SequeLink Server - Do I need a... (6)
-> + faultString: (401)Unauthorized... (7)
-> + Previewing XSL with javascript... (2)
-> + removing formating from XML (6)
-> + removing formating from XML (2)
-> + Custom EDI to XML conversion (2)
-> + Getting "Type not found" error... (4)
-> - Converting file and customize ... (1)
-> + formatting problem with xml ex... (2)
-> + Using DTD Entities and XSD (7)
-> + XML Schema (XSD), Adding comme... (2)
-> + DTD schema generation problem (2)
-> + How do i generate a schema fro... (4)
-> + Incomplete request message gen... (2)
-> + Installation issue for Stylus ... (2)
-> + DTD "ANY" isn't honored by val... (2)
-> + Replacing carriage returns wit... (3)
-> + WS with SOAP - problem with pa... (5)
-> + problem converting CSV to XML (2)
-> + validating xml with multiple s... (4)
-> + SOAP problems ! (2)
-> + mapping csv columns to schema (2)
-> - Access DB to XML doc using an ... (1)
-> - DataDirect SequelLink w/MS Acc... (1)
-> + Problem with DB to XML Source ... (3)
-> + problems to work from the comm... (3)
-> + Stylus Studio Enterprise WScal... (4)
-> + Erratic behaviour in EDIFACT a... (14)
-> + XML Pipeline Question (7)
-> + Stylus Studio reports invalid ... (4)
-> - Is there a way to generate a G... (1)
-> + Stylus produced XSLT not trans... (2)
-> + XML Editor spell check - bug w... (4)
-> + API unlocks OK, but fails in n... (4)
-> + EDI to XML conversion for UNOC... (11)
-> + Stylus crashed with recurence ... (2)
-> + terrible perfomance using the ... (4)
-> + XSD to RDBMS, e.g. SQL Server,... (3)
-> + relational database (7)
-> + Stylus Studio 6 wrongfully det... (6)
-> + Having trouble with schema val... (5)
-> + Stylus Studio 2007 Home Editio... (2)
-- Previous [1681-1700] [1701-1720] [1721-1740] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ 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.