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
Calum HartleySubject: Custom XML Conversion
Author: Calum Hartley
Date: 19 Dec 2013 07:09 AM
I am trying to create an xml file using the Custom XML Conversion. My source is a CSV file.

At the center you can see your data in a grid format and then to the right you can see the structure represented as a tree view. To start with the structure is flat so for example it is:

<root>
<Region>
<row1>
<Element1/>
<Element2/>
<Element3/>
<Element4/>
<Element5/>

However, I want to be able to change the structure of the xml file so that it has multiple levels:

<root>
<Region>
<row1>
<Element1/>
<Element2/>
<NewLevel>
<Element3/>
<Element4/>
<NewLevel2>
<Element5/>
</NewLevel2>
</NewLevel>
</row1>

So far I can't find any way to add these extra levels using the custom xml conversion into the XML structure and I wondered whether anyone knows of a way to do it using this software? I have thought of using SSIS to do this but it seems like it should be really straight forward using Stylus Studio.

The version that I am using is Stylus Studio X15 XML Enterprise Suite (build 1910n).

Posttop
Ivan PedruzziSubject: Custom XML Conversion
Author: Ivan Pedruzzi
Date: 19 Dec 2013 10:39 AM
Hi Calum,

Such task in Stylus Studio is accomplished in two passes.

After you turned you data in XML in may use XSLT or XQuery to produce the final result.

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

 
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.