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
Joe WederSubject: Urgent Eval: How2 w/ Possibly Unique Conversion Needs
Author: Joe Weder
Date: 12 Dec 2006 10:35 AM
I am evaluating the latest StylusStudio Enterprise for our current development.

I have, I think, a unique need and wanted to know if anyone could help expidite the solution during our short eval time.

Problem:
I need to be able to convert a single CSV row at at time to XML. I see how to convert files using the XQuery mapping tools. Is there a way to to generate code that can map a row at a time programatically?


OurProprietaryService ourService = BusinessServices.getBean("customerHandler");
String csv = "1, \"Bob's Bar\", 1234, 98767";
String xml = StylusStudioGeneratedCodeThingy.convert(csv);
ourService.insert(xml);


I can supply the xsd. But will not have a column names line.

Thanks in advance. Any help at all would be greatly appreciated.

Postnext
Ivan PedruzziSubject: Urgent Eval: How2 w/ Possibly Unique Conversion Needs
Author: Ivan Pedruzzi
Date: 13 Dec 2006 09:46 PM

Hi Joe,

Here is a quick eexample that shows how to convert a CSV passed in as String to XML

StylusFileFactory.unlockAPI("Installation ID Here");

String csv = "1, \"Bob's Bar\", 1234, 98767";

ConverterFactory.newInstance().newConvertToXML("adapter:CSV").convert(
new StreamSource(new ByteArrayInputStream(csv.getBytes())),
new StreamResult(System.out));

Hope this helps.
Ivan Pedruzzi
Stylus Studio Team

Postnext
Joe WederSubject: Urgent Eval: How2 w/ Possibly Unique Conversion Needs
Author: Joe Weder
Date: 14 Dec 2006 08:13 AM
Ivan,

Thanks. But that does not include the mapping right? Thats just straight csv to generic XML which is not hard to do.

Is there a way to do that and get transformation? ie, the mappings to a schema?

Posttop
Ivan PedruzziSubject: Urgent Eval: How2 w/ Possibly Unique Conversion Needs
Author: Ivan Pedruzzi
Date: 14 Dec 2006 02:03 PM

If you need to connect the converter into XSL Transformation, see the following solution

// configure the XSLT to receive SAX events from the converter
TransformerHandler th = ((SAXTransformerFactory)TransformerFactory.newInstance()).newTransformerHandler(new StreamSource("simple.xsl"));
th.setResult(new StreamResult(System.out));
SAXResult convToXMLSAXResult = new SAXResult(th);

// run the converter
String csv = "1, \"Bob's Bar\", 1234, 98767";
StreamSource streamSource = new StreamSource(new ByteArrayInputStream(csv.getBytes()));
ConverterFactory.newInstance().newConvertToXML("adapter:CSV").convert(streamSource, convToXMLSAXResult);

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

 
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.