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 » Custom XML Conversion
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + X16 - XPath 3.0, XQuery 3.0, X... (2)
-> - Test (1)
-> + XSLT debugger shows [symbol u... (3)
-> - How do i use *.conv to process... (1)
-> - How do i use *.conv to process... (1)
-> + Not able to configure JVM in ... (5)
-> + Converting Cobol flat file to ... (2)
-> + Problem with uninstall - Windo... (2)
-> + Function current() is not reco... (6)
-> + API or web version (2)
-> + How to use Saxon for X16 on WI... (9)
-> + Error in SS X14 syntax highlig... (2)
-> + Option not available (2)
-> + XML Diff functionality and sor... (3)
-> + Convert Oagis XML file to TXT (4)
-> + DataDirect xqresultsequence is... (2)
-> - xfile Legacy file format suppo... (1)
-> + TPFDF (3)
-> + Help needed with SLSRPT - EDIF... (2)
-> - keeps crashing after I try and... (1)
-- 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.