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
Kristina BarronSubject: New user to Stylus Studio XML Professional
Author: Kristina Barron
Date: 30 Mar 2005 09:43 AM
I have downloaded a trial version of the XML Professional. This is what I need it to do and i'm not sure how to do it. I need to open an existing document, which in this case is going to be a text file, and each field in the file is separated with a '|'. I take this file and run an Excel macro that pulls the text file from a server and places it into Excel. After I open the text file I need to be able to load a XML schema file that I have created and associate the fields in the schema with fields in the txt file. After this has been done I need to create the XML file. Can someone tell me step by step how I need to go about doing this? I have been trying for over an hour without any luck. Please help. Thank you.

Postnext
Alberto MassariSubject: New user to Stylus Studio XML Professional
Author: Alberto Massari
Date: 31 Mar 2005 04:47 AM
Hi Kristina,
if Excel can be removed from the loop, here is what I would do:
- create a new "XSLT Mapper" document
- click on "Add Source Document"
- select the flat file you want to process, check the "Convert to XML using adapter"
checkbox and press OK
- in the "Select XML Converter" dialog, select on the left the converter
named "Comma-separated values"
- on the right pane you will see its properties: change the "Separator" from
"," to "|"
- click OK
- click on "Set Target Document"
- select the XML Schema that models the final XML document
- at this point, drag the fields from the left tree to the right tree, and
the XSL stylesheet will be built for you
- click on the green arrow to preview the transformation

Hope this helps,
Alberto

Posttop
Kristina BarronSubject: New user to Stylus Studio XML Professional
Author: Kristina Barron
Date: 31 Mar 2005 07:52 AM
Hi Alberto,

Thank you for your feedback. I tired what you said and it worked perfectly. Thank you very much. BTW, you have a beautiful child in the picture with you.

 
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.