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
Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
chris johnsonSubject: convert files to xml
Author: chris johnson
Date: 14 May 2006 07:48 PM
I have a text which I would like to convert a specific xml output. I am having problem creating my specific xml output. I’m not sure if it’s even possible with stylus studio. If it is, please let me know. If I can get stylus studio to convert to this specific xml output, I will purchase a copy of the software.

I am trying to create child nodes under a specific node.

My text file looks like this

H10120060126BBS000010000345670000987
S00000001ChrisSmith1234parkrd1234565700004595
G00000001A6800099
G00000001C8700032
A00000001B7800000
T0000000200000001000000001


I need my xml to look like this.

<Root>
<Header>
<Type>H</Type>
<Element>101</Element>
<Element>20060126</Element>
<Element>BBS</Element>
<Element>00001</Element>
<Element>000034567</Element>
<Element>0000987</Element>
</Header>
<Student>
<Number>00000001</Number>
<Name> ChrisSmith </Name>
<Address>1234parkrd </Address>
<Student_Number>12345657</Student_Number>
<ISN>00004595</ISN>
<Grade>
<Number>00000001</Number>
<Letter_Grade>A</Letter_Grade>
<Numeric_Grade>68</Numeric_Grade>
<Course>00099</Course>

</Grade>
<Grade>
<Number>00000001</Number>
<Letter_Grade>C</Letter_Grade>
<Numeric_Grade>87</Numeric_Grade>
<Course>00099</Course>
</Grade>
<Additional_Info>
<Number>00000001</Number>
<Letter_Grade>B</Letter_Grade>
<Numeric_Grade>78</Numeric_Grade>
<Course>00000</Course>
</Additional_Info>
</Student>
<Total>
<Number>00000002</Number>
<Count1>00000001</Count1>
<Count2>000000001</Count2>
</Total>

Can you please show me how to create such a specific output using the converttoXML feature in stylus Studio 2006.

Posttop
Ivan PedruzziSubject: convert files to xml
Author: Ivan Pedruzzi
Date: 14 May 2006 10:57 PM

Please do not cross post.

Thank You
Ivan Pedruzzi
Stylus Studio Team

 
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.