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 in a simple convert xml to csv
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + External Cascading Style Sheet... (2)
-> + Need help with XML mapping - P... (2)
-> + Convert image to base64 in xsl... (2)
-> + Automation (2)
-> - Changing Default Property valu... (1)
-> + Help in reading cdata using xs... (4)
-> + Ok, I can programatically conv... (2)
-> + How do I prevent the previewer... (2)
-> + Can I programatically convert ... (2)
-> + XML To Flat File - Reverse Eng... (3)
-> + Check for valid attribute valu... (3)
-> + Java.lang.OutOfMemory - when I... (3)
-> + How to convert text in EBCDIC ... (8)
-> + First steps in XSLT mapping (4)
-> + Option to build XSL-FO is not ... (3)
-> + using Adaptor convert XML to e... (2)
-> + Using XML Converter on a Compl... (2)
-> + Java built-in processor needed... (3)
-> + XSL to draw a table (2)
-> - Stylus Studio in c# solutions (1)
-> + entities within schemaLocation... (4)
-> + java runtime error during xslt... (2)
-> + Conversion of XML Doc for RSS ... (2)
-> + Does anyone know how to upgrad... (2)
-> + XML editor corrupts my file (5)
-> + Stylus Studio & Berkeley DB XM... (4)
-> + XSLT for page breakout (2)
-> + How to avoid creating empty el... (2)
-> + Error in converting 945 EDI us... (4)
-> + XML to X12 (invoice 810 edi) (2)
-> - Stylus Studio 2009 Enterprise ... (1)
-> + Stylus Studio 2007 - license d... (2)
-> + XML to X12 conversion error (6)
-> + How to reset JVM (to another j... (2)
-> + How to generate XML sample dat... (2)
-> + Document Path reference after ... (4)
-> + concatenate with xquery (6)
-> + i want to capture the xml tag ... (3)
-> + "View Sample XML" in schema an... (2)
-> + Can't get to Toolbar settings ... (2)
-> + SOAPException (3)
-> + how to patch xml files with wr... (2)
-> + wysiwug xslt editor (2)
-> + XML to Google Charts (10)
-> + XML to HL7 (2)
-> - Outputting this XML (1)
-> + Interpreting XSD Error Message... (2)
-> + converter EDI --> typ = no (8)
-> + License issue (7)
-> + One of the simplest questions ... (3)
-> + xQuery transformation encounte... (2)
-> + Schema Evolution (2)
-> + Preview in Browser button gray... (4)
-> + converter:EDI:val=no AND chr=.... (4)
-> + [XQuery][DB2 JDBC Driver]Unsu... (2)
-> + Need Help Create XML file thro... (4)
-> + Flat file to XML conversion in... (5)
-> + How to set delimiters if it's ... (4)
-> + XSD Validation failing (4)
-> + XSD Validation failing (2)
-> + Web Service Call cannot retrie... (7)
-> + Flat file conversion to XML (2)
-> + Stylus Studio crash (5)
-> + Stylus Studio No Longer loads (2)
-> + How do I print in color? (2)
-> + Integrating Documentum WebPubl... (2)
-> + Stylus Studio crashes on openi... (4)
-> + Change format of XML output fo... (3)
-> + XSLT mapper / Source file not ... (7)
-> + Stylus Studio crashes on start... (3)
-> + Loading GML3.1 (3)
-> + NullPointerException when runn... (5)
-> + Can not open Stylus Studio (3)
-> + macros for custom validation e... (6)
-> + Does Stylus Studio generate XM... (4)
-> + another csv conversion (7)
-> + ADD CVS to Source Control drop... (2)
-> + Automate xquery (6)
-> + Correcting multiple XML docume... (2)
-> + Unable to locate Components\Da... (5)
-> + Runtime Error, Struzzo.exe, Ab... (11)
-> + Convert XML to EDIfact (3)
-> + I don't have the Mapper tab (6)
-> + CSV conversion with null field (3)
-> + Converting a Complex Flat File... (2)
-> - installion in batch mode (1)
-> + Complete Custom Validation Lis... (2)
-> + creating xml from csv flat fil... (9)
-> - need Help Regarding XBRL (1)
-> + Exception FODC0004: file or di... (2)
-> + Activation (2)
-> + java runtime error (2)
-> + connection problem with AS 400... (4)
-> + XML to 837I EDI -- multiple NM... (3)
-> + WYSIWYG in SSv7 (2)
-> - Write into < head /> tags us... (1)
-> + Maximum recursion depth exceed... (2)
-> - Code coverage testing (1)
-> - Passing JavaScript with multip... (1)
-> + preserving white space in XML ... (8)
-- Previous [721-740] [741-760] [761-780] 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
bart van HeesSubject: Please help in a simple convert xml to csv
Author: bart van Hees
Date: 09 Apr 2009 05:09 AM
hello all,

please assist me in first time use of stylus studio:
I want to convert an xml to a csv.
the xml looks like this:

<?xml version="1.0" ?>
- <eExact xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="eExact-Schema.xsd">
- <Orders>
- <Order type="B" number="20026510">
- <OrderLine lineNo="1">
<Description>testarticle1</Description>
<Quantity>10</Quantity>
</OrderLine>
- <OrderLine lineNo="2">
<Description>testarticle2</Description>
<Quantity>8</Quantity>
</OrderLine>
</Order>
</Orders>
</eExact>

( to make it readable, I deleted a lot of lines, which are not relevant now, but the actual file is a lot bigger with more tags)

What I want to create is a flat file (csv)

I must look like this:

10;testarticle1
8;testarticle2

So, what I'd really appriciate if someone can give me like a step-to-step guido of how to tackle this issue.

The final use must be that I can select a XML with every time the above mentioned structure. After selecting this XML and processing by Stylus Studio, the goal is that a flat file (.csv) is stored at my local drive. Maybe a hint for this too?

Thanks for your help!!

regards,
Bart

Postnext
John BamptonSubject: Please help in a simple convert xml to csv
Author: John Bampton
Date: 10 Apr 2009 06:09 AM
Just write some xslt to do the transformation
Postnext
Tony LavinioSubject: Please help in a simple convert xml to csv
Author: Tony Lavinio
Date: 10 Apr 2009 06:29 AM
1. File > New > XSLT Stylesheet
2. Choose the XML file as the source
3. In the tree that appears on the right, drag the "OrderLine" node
to within the <xsl:template> block, and choose "apply-templates" from
the menu.
4. Before the final </xsl:stylesheet>, again drag the "OrderLine" node
but this time as a "template".
5. Drag the "Quantity" and "Description" nodes into the newly-created
template as value-of's.
6. Insert <xsl:text> blocks for the ; and the linefeed
7. Set the output method to "text" (you can do that on the "Params/Other"
tab at the bottom of the window).

The finished transform should look something like this:

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>
<xsl:template match="/">
<xsl:apply-templates select="eExact/Orders/Order/OrderLine"/>
</xsl:template>
<xsl:template match="OrderLine">
<xsl:value-of select="Quantity"/>
<xsl:text>;</xsl:text>
<xsl:value-of select="Description"/>
<xsl:text>&#x10;</xsl:text>
</xsl:template>
</xsl:stylesheet>

You might need &#13;&#10; for your line ending, depending on your
target platform.

When you preview, make sure you use the "Preview Text" view and not
the "Preview in Browser" view, to see what your output will really
look like.

Postnext
bart van HeesSubject: Please help in a simple convert xml to csv
Author: bart van Hees
Date: 10 Apr 2009 08:13 AM
Hello! thanks a lot for your post. It was really helpful. I managed to get the output!!
Now I only need some support in the 'last step'.

I need to be able to transfer seperate files, and create new files with converted data.
I really don't know how to tackle this.

So I got the output in the preview window, but want to store it in some textfile. And beond: I want to be able to select individual files to be converted, preferably with every created file with a unique name.

Can someone point me out in the right direction???

Regards, Bart
Posttop
Tony LavinioSubject: Please help in a simple convert xml to csv
Author: Tony Lavinio
Date: 10 Apr 2009 08:32 AM
You can use the bundled executable, StylusXslt.exe, to run the
transforms outside of Stylus Studio. This will let you control
the input and output filenames.

Alternatively, you can use another transform engine. Saxon,
from www.saxonica.com, includes both Java and .net engines of
very high quality, and can be used for no cost.
   
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.