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 » Converting XML to CSV
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + What Pipeline standard do you ... (4)
-> + How can i increase sylus memor... (2)
-> - Tutorial & Tech support needed (1)
-> + Generate HTML Documentation fr... (3)
-> + Use of saxonsa outside stylus ... (2)
-> + Schema to DTD (6)
-> + Trial version requires interne... (4)
-> - APACHE FOP text box (1)
-> + 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)
-- Previous [1801-1820] [1821-1840] [1841-1860] 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
Grant BeeversSubject: Converting XML to CSV
Author: Grant Beevers
Date: 22 Aug 2006 07:43 AM
Can someone tell me how I could use this product to convert an XML file to a CSV file?

Thanks,
GB
Postnext
Ivan PedruzziSubject: Converting XML to CSV
Author: Ivan Pedruzzi
Date: 22 Aug 2006 08:58 AM

It depends on how your XML document is shaped.
If you post an example we will show you how.

Hope this helps
Ivan Pedruzzi
Stylus Studio Team
Postnext
Grant BeeversSubject: Converting XML to CSV
Author: Grant Beevers
Date: 22 Aug 2006 04:36 PM
Here is a sample xml file...


UnknownClassroom.xml
Sample xml file
Postnext
Ivan PedruzziSubject: Converting XML to CSV
Author: Ivan Pedruzzi
Date: 22 Aug 2006 05:08 PM

Could you please post the output sample you are expecting?

Thanks
Ivan Pedruzzi
Stylus Studio Team
Postnext
Grant BeeversSubject: Converting XML to CSV
Author: Grant Beevers
Date: 23 Aug 2006 05:11 AM
I need a simple CSV file which I can convert to excel and then add data row by row. The application I am using requires input by csv and not xml, but this xml file indicates the elements I need to include in the csv
Postnext
Ivan PedruzziSubject: Converting XML to CSV
Author: Ivan Pedruzzi
Date: 25 Aug 2006 10:47 AM

The attached XSLT should do what you are looking for

Ivan Pedruzzi
Stylus Studio Team


Unknownclassroom.xsl
Postnext
Grant BeeversSubject: Converting XML to CSV
Author: Grant Beevers
Date: 27 Aug 2006 01:26 AM
Hi Ivan,

Thanks for thsi, however, I am new to all of this. How do I use this file?
Postnext
Tony LavinioSubject: Converting XML to CSV
Author: Tony Lavinio
Date: 28 Aug 2006 05:50 PM
Start Stylus Studio
Do File|New|XSLT
Use the .xml file as the input source and press OK.
Insert the .xsl file attached.
Then execute the XSLT program.

You might want to look at the XSLT videos
at http://www.stylusstudio.com/xml_videos.html

Postnext
Grant BeeversSubject: Converting XML to CSV
Author: Grant Beevers
Date: 29 Aug 2006 10:52 PM
Originally Posted: 29 Aug 2006 10:50 PM
Thanks Tony and Ivan for your help to date. Can I explain what I am trying to get this tool to help to achieve:

We have an application which will allow bulk upload of date via a web UI, and supports 2 types of import; csv or xml. The csv is a little messy and doesn't give us as much information as an XML would.

Also, we want to provide end users with a simple excel spreadsheet like the one attached for courses (saved as a csv). The end user would then add their rows of data, then send it back to us and we would use your tool to convert this to an xml file which we would load into the application. We have a series of these spreadsheets which we would provie to the end user to fill with the relevant data.

My question is: what would be the complete process I would go through to end up with a fully populated xml file to laod into our application. I have also provided a sample xml file of what the xml for this course data should look like (ie. what format of xml our application is expecting to see).

Appreciate any help you can give me here.

Regards,
Grant


DocumentCourses_completed.csv
Course completed csv file

DocumentOfferingTemplate.xml
Course xml file
Posttop
Tony LavinioSubject: Converting XML to CSV
Author: Tony Lavinio
Date: 14 Sep 2006 11:31 PM
The scope of this might be a little outside of the forum.
We can help you with specific questions about using the
tool, but not knowing more about how your whole environment
is set up makes it hard for us to give deployment advice.
   
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.