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
Lisa ZhouSubject: Generate CSV from an XML file with child tags
Author: Lisa Zhou
Date: 08 May 2006 06:45 PM
HI
Is there anyway that I could use the stylus studio to generate a csv file based on an xml file supplied? the issue we are having is that the original data is in XML format, and we need to convert it to CSV format for importing to the database.

Thanks

Postnext
Ivan PedruzziSubject: Generate CSV from an XML file with child tags
Author: Ivan Pedruzzi
Date: 08 May 2006 07:00 PM
Stylus Studio ships a built-in bi-direction CSV adapater

http://www.stylusstudio.com/docs/v2006/d_flatfileconversion36.html

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Postnext
Lisa ZhouSubject: Generate CSV from an XML file with child tags
Author: Lisa Zhou
Date: 08 May 2006 07:14 PM
Thanks for you quick response. I am using the Stylus Studio 2006 Release 2 XML Professional Edition.
Here are two questions.
1. Where can I find the open dialog for choosing the adaptor, I followed the instruction and click on file-> open, I cant see the checkbox for Conver to XML using adaptor anywhere.
2. From reading that page, it seems that the instruction is on how to convert to XML from another file format, how would I got about converting to CSV from an XML file?


Imagetemp.JPG
Screen Shot of Open Dialog

Posttop
Minollo I.Subject: Generate CSV from an XML file with child tags
Author: Minollo I.
Date: 08 May 2006 08:27 PM
To access XML adapters, you need Stylus Studio Enterprise Edition; you can download and give it a try from http://www.stylusstudio.com/download

Once you convert the CSV file to XML, take a look at the XML format; you can use the same kind of structure to convert back XML data into CSV.

Minollo

 
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.