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: flat file conversion with CDATA section
Author: Taron Barber
Date: 11 Apr 2008 07:42 PM
Originally Posted: 11 Apr 2008 07:41 PM
Hi, I have a csv file and i am trying to get it converted to match a sample xml file. the sample file has a CDATA section in the url. I used the xquery mapper to connect the 2 files but it will not create the CDATA section automatically, so I had to go into the tree tab and add a CDATA section to each URL element by hand. Does anyone know how to get it to do this automatically? I have attached both the csv file and the sample xml file.

Thanks for any feedback.


Imagevonzipper.csv
csv file

Imagevzsample(1).xml
sample xml

Postnext
Alberto MassariSubject: flat file conversion with CDATA section
Author: Alberto Massari
Date: 15 Apr 2008 05:02 AM
Hi,
you can do it automatically by adding the

declare option ddtek:serialize "cdata-section-elements=Url";

declaration at the top of the query. If you are using the Saxon processor, replace the ddtek:serialize option with saxon:output.

Hope this helps,
Alberto

Postnext
Taron BarberSubject: flat file conversion with CDATA section
Author: Taron Barber
Date: 15 Apr 2008 12:05 PM
Thank you so much for the reply. I am happy to hear that it is doable however I am brand new to xml and this program so I am not sure how to do what you told me. Can you outline the process to go about this?

Posttop
Alberto MassariSubject: flat file conversion with CDATA section
Author: Alberto Massari
Date: 15 Apr 2008 01:04 PM
Hi Taron,
when you are in XQuery mapper, you can see in the lower part of the window the text being generated by your drag & drop operations; just click on that text window, move to the beginning and type the line I wrote.

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.