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
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Can SS do this? (14)
-> - CargoImp support (1)
-> + No Preview Displayed - File is... (3)
-> - Stylus Studio X16 build 1974l ... (1)
-> + Help! Help!Help! Regading form... (2)
-> + FileNotFoundException generati... (6)
-> + FO External Graphic Producing ... (2)
-> + Use of Java methodes (4)
-> + get generated XQuery output on... (2)
-> - right construct for involving ... (1)
-> + SS JRE Version has "Stylus Stu... (3)
-> + Trying to validate an XSD: co... (3)
-> + Disable "Output" windows (4)
-> + Stylus Studio V16 X64 update d... (2)
-> + Could not load the Java Virtua... (2)
-> + .NET XslCompileTransform strip... (6)
-> + XML Report Preview and Save Ev... (8)
-> + X16 Enterprise 32bit crash on ... (5)
-> - MSXML6.0 SAX Parser, "Index re... (1)
-> + MSXML6.0 DOM Parser stops afte... (4)
-- Previous [61-80] [81-100] [101-120] 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
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

   
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.