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)
-> + XXX maps to XXX system (3)
-> + Help with extracting bookmarks... (2)
-> + Stylus Studio crashes when sou... (2)
-> + WSDL not Displaying properly (5)
-> + How to use fonts other than ba... (5)
-> + Saxon XSLT2 and FOP for XSL:FO... (3)
-> + Converting from XML to EDIFACT (5)
-> + Looping more than one time thr... (2)
-> - Need help with using XQuery in... (1)
-> + Looping - Taking the comma out (3)
-> + xslt mapper is only processing... (4)
-> - Newbie: using Saxon 9.1 with F... (1)
-> + Editing ![CDATA[]]> in the Gr... (2)
-> + Convertic EDI files into XML (7)
-> + Type2 Authentication missing D... (6)
-> - Please help in a simple conver... (5)
-> ->Please help in a simple c...
-> ->Please help in a simple c...
-> ->Please help in a simple c...
-> ->Please help in a simple c...
-> + Doc/Literal Wrapped (4)
-> + Error starting Stylus Studio (9)
-> + WYSIWYG Menu Bar and Tab Missi... (2)
-> + XML file size limits (2)
-> + XML Publisher (2)
-> + cant get namespace declaration... (5)
-> + Fixed Width to XML (3)
-> - file to xml conversion (1)
-> + Create Multiple Page (3)
-> + Flat file conversion with colu... (3)
-> + New Line character problem in ... (2)
-> + need help - stylus doesn't sta... (2)
-> + command line StylusValidator ... (3)
-> + Help unistalling (2)
-> + recurse problem analysis (3)
-> - Newbie: WSAD and file paths (1)
-> - Stylus StudioŽ 2009 XML Enterp... (1)
-> + Help with XSL to transform two... (4)
-> + connect to xhive (2)
-> - element id and name attributes... (1)
-> - http://www.w3.org/2001/XMLSche... (1)
-> + Error message when converting ... (2)
-> + XML id and anyuri datatype (2)
-> - import xml into an ms acces... (1)
-> + Change version (6)
-> + Translate two files into one (3)
-> + invalid relative uri with data... (7)
-> + My table crashes java Runtime (5)
-> + inx to pdf (3)
-> + XSD - multiple similar namespa... (7)
-> + validating many xml files (4)
-> + Stylesheet Parameters (3)
-> + create web service using Stylu... (2)
-> + connect with sql server (4)
-> + License could not be validated... (2)
-> + How to open (or decompress) a ... (3)
-> + Stylus Studio 2009 Home & Java (4)
-> + Connect to Informix DB 7.31.FD... (2)
-> + Unable to download stylus stud... (5)
-> + conversion CSV to XML (2)
-> + Please help to create a XSL to... (2)
-> + Stylus Studio 2009 unresponsiv... (3)
-> + Stylus Studio 2009 and IBM Jav... (2)
-> + separate one record to two lin... (3)
-> + error when running xquery comm... (6)
-> + Convert ebcdic-cp-us to utf-8 (8)
-> - hi urgent plz (1)
-> + Java compile problem (7)
-> + How to set pattern match on th... (3)
-> + Adobe Illustrator CS4 xml not ... (3)
-> + validating XSD with W3c stand... (2)
-> + Count function with condition ... (2)
-> + [Context] variable (4)
-> + Batch process HTML to XML docu... (2)
-> + Need help with adding logiic ... (2)
-> - BUG when editing File Types (1)
-> + Is Stylus Studio XML authoring... (2)
-> + Missing Xpath Query Editor (8)
-> + Error Connecting to DB2 9.5 (3)
-> - Tony (1)
-> + Problem trying to use your sof... (2)
-> + cannot save or associate a sch... (2)
-> + xsd to dtd (2)
-> + Can we use Stylus for our proj... (4)
-> + printing a parent node value i... (2)
-> + How to tell StylusDiff.exe to ... (4)
-> + Pipeline Messages not Consiten... (2)
-> + Custom XML conversion (2)
-> + Format date fields (3)
-> + Can't Connect to iSeries via I... (11)
-> + "application failed to start" ... (5)
-> - Can't connect to an Access DB ... (1)
-> + Unable to attach external JVM (3)
-> + Adding Numbers using XSLT (2)
-> + copy all elements and hardcode... (2)
-> + A bit confused on where to sta... (2)
-> + Application Menu Problem (14)
-> + API to retrieve 'Adapter URL' ... (2)
-> + How do I move my Stylus Studio... (6)
-> + API to retrieve 'Adapter URL' ... (2)
-> + InterPage Linking Problem in .... (2)
-> + xsl - header only once in fore... (7)
-> + StylusDiff.exe crashes when co... (5)
-> + Validation against schemas wan... (5)
-- Previous [781-800] [801-820] [821-840] 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.