SSDN - Urgent Eval: How2 w/ Possibly Unique Conversion Needs

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Joe Weder

Subject: 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.

Ivan Pedruzzi

Subject: 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

Joe Weder

Subject: 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?

Ivan Pedruzzi

Subject: 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

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.