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
Crissy ShehadehSubject: XML mapping
Author: Crissy Shehadeh
Date: 18 Jan 2005 11:54 AM
Hello-

I am a brand new user to Stylus Studio and XML. I have a
comma-delimited text file that contains most of the info that I need in
the XML document. However, most of the document uses values that never
change. Is there a way to pull bits of info from my .csv file, and to
pull the rest of the info from a template of pre-defined fields and
values?

thanks for your help,
Crissy

Postnext
Ivan PedruzziSubject: XML mapping
Author: Ivan Pedruzzi
Date: 19 Jan 2005 12:02 AM
Crissy,

There is more then one way to do it,
you could use just Convert to XML and tune the converter using
regular expressions to filter out the undesired content or
you could convert the entire file to XML then use XSLT to shape
the final result.

If you show us a sample from your file and the desired ouput, we can
try to provide a solution.

Ivan

Postnext
Crissy ShehadehSubject: XML mapping
Author: Crissy Shehadeh
Date: 19 Jan 2005 08:48 AM
See attached files for samples.

thanks again for the help,
Crissy


Documenthunt.csv
csv file to convert to XML

DocumentXMLSample.txt
Sample XML

Posttop
Ivan PedruzziSubject: XML mapping
Author: Ivan Pedruzzi
Date: 19 Jan 2005 12:00 PM

Here what you could do:

- Crate a new "Convert to XML"
- Use hunt.csv as input file and click on "line oriented"
- When you have the grid on the screen right click and select
"Get field name from this road"
- Save the conversion as hunt.conv
- then click the green triangle,
you have succesfully tranformed your input file to XML

The desired XML output (XMLSample) is very different so what
you can do is to use XML mapper to create an XSLT transformation

- Create new XSLT mapper
- select hunt.conv from the xml adapters as input
- select XMLSample.xml as target
- Map the structure you are interested




 
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.