Copy Page

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account. You can also Sign Up for a new account.

<p>This tutorial illustrates is how to generate a stream of SAX events from a CSV stream and how that stream of SAX events feeds into Smooks to generate an XML model that can be transformed further (in this case it is not).</p>
<img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e3RvYzppbmRlbnQ9MjBweHxzdHlsZT1kaXNjfQ&amp;locale=en_GB&amp;version=2" data-macro-name="toc" data-macro-parameters="indent=20px|style=disc">
<p> <br />
<strong><a href="http://svn.codehaus.org/milyn/trunk/smooks-examples/csv-to-xml"><strong>SVN</strong></a></strong> - <strong><a class="confluence-link unresolved" data-content-title="downloads" data-linked-resource-default-alias="downloads" href="#"><strong>Download</strong></a></strong> - <strong><a class="confluence-link" href="/display/MILYN/Tutorials" data-linked-resource-id="49525" data-linked-resource-type="page" data-linked-resource-default-alias="Tutorials" data-base-url="http://docs.codehaus.org"><strong>Other Tutorials</strong></a></strong></p>

<p>Other Relevant Info:</p>
<ul>
	<li><a class="confluence-link" href="/display/MILYN/Smooks+Example+-+edi-to-xml" data-linked-resource-id="24248659" data-linked-resource-type="page" data-linked-resource-default-alias="Smooks Example - edi-to-xml" data-base-url="http://docs.codehaus.org">edi-to-xml</a> tutorial.</li>
	<li><a class="confluence-link" href="http://milyn.codehaus.org/javadoc/smooks-cartridges/csv/org/milyn/csv/CSVParser.html" shortcut-key="milyn_public_html" shortcut-parameter="javadoc/smooks-cartridges/csv/org/milyn/csv/CSVParser.html" data-linked-resource-default-alias="unnamed link" data-base-url="http://docs.codehaus.org">CSVParser Configuration</a>.</li>
	<li><a class="confluence-link" href="http://milyn.codehaus.org/javadoc/smooks/org/milyn/xml/SmooksXMLReader.html" shortcut-key="milyn_public_html" shortcut-parameter="javadoc/smooks/org/milyn/xml/SmooksXMLReader.html" data-linked-resource-default-alias="unnamed link" data-base-url="http://docs.codehaus.org">SmooksXMLReader</a>.  The extension point for Smooks configured stream parsers.</li>
</ul>

<p> <br />
<span style="text-decoration: underline;">To Build</span>: &quot;mvn clean install&quot;<br />
<span style="text-decoration: underline;">To Run</span>: &quot;mvn exec:java&quot;</p>

<h1>Transforming from CSV to XML</h1>

<p>This is a very simple example that illustrates how Smooks to configure in a non-XML stream parser (CSV) into Smooks.</p>

<p>So here's the source csv file that is to be transformed:</p>
<table class="wysiwyg-macro" data-macro-name="noformat" style="background-image: url(/plugins/servlet/confluence/placeholder/macro-heading?definition=e25vZm9ybWF0fQ&amp;locale=en_GB&amp;version=2); background-repeat: no-repeat;" data-macro-body-type="PLAIN_TEXT"><tr><td class="wysiwyg-macro-body"><pre>
Tom,Fennelly,Male,4,Ireland
Mike,Fennelly,Male,2,Ireland
</pre></td></tr></table>
<p>And this is the expected result of our transformation (as generated by the CSVParser):</p>
<table class="wysiwyg-macro" data-macro-name="noformat" style="background-image: url(/plugins/servlet/confluence/placeholder/macro-heading?definition=e25vZm9ybWF0fQ&amp;locale=en_GB&amp;version=2); background-repeat: no-repeat;" data-macro-body-type="PLAIN_TEXT"><tr><td class="wysiwyg-macro-body"><pre>
&lt;csv-set>
	&lt;csv-record>
		&lt;firstname>Tom&lt;/firstname>
		&lt;lastname>Fennelly&lt;/lastname>
		&lt;gender>Male&lt;/gender>
		&lt;age>4&lt;/age>
		&lt;country>Ireland&lt;/country>
	&lt;/csv-record>
	&lt;csv-record>
		&lt;firstname>Mike&lt;/firstname>
		&lt;lastname>Fennelly&lt;/lastname>
		&lt;gender>Male&lt;/gender>
		&lt;age>2&lt;/age>
		&lt;country>Ireland&lt;/country>
	&lt;/csv-record>
&lt;/csv-set>

</pre></td></tr></table>
<p><img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e2FuY2hvcjpjb25maWd1cmF0aW9ufQ&amp;locale=en_GB&amp;version=2" data-macro-name="anchor" data-macro-default-parameter="configuration"></p>

<h1>The Smooks Configuration</h1>

<p>We simply specify the <a class="confluence-link" href="http://milyn.codehaus.org/javadoc/smooks-cartridges/csv/org/milyn/csv/CSVParser.html" shortcut-key="milyn_public_html" shortcut-parameter="javadoc/smooks-cartridges/csv/org/milyn/csv/CSVParser.html" data-linked-resource-default-alias="unnamed link" data-base-url="http://docs.codehaus.org">CSVParser</a> as the stream parser.  More transformation configurations could be added to transform this message further.</p>

<p>Here's the configuration (&quot;smooks-config.xml&quot;):</p>
<table class="wysiwyg-macro" data-macro-name="noformat" style="background-image: url(/plugins/servlet/confluence/placeholder/macro-heading?definition=e25vZm9ybWF0fQ&amp;locale=en_GB&amp;version=2); background-repeat: no-repeat;" data-macro-body-type="PLAIN_TEXT"><tr><td class="wysiwyg-macro-body"><pre>
&lt;?xml version="1.0"?>
&lt;smooks-resource-list xmlns="http://www.milyn.org/xsd/smooks-1.0.xsd">

&lt;!--Configure the CSVParser to parse the message into a stream of SAX events. -->
	&lt;resource-config selector="org.xml.sax.driver">
		&lt;resource>org.milyn.csv.CSVParser&lt;/resource>
		&lt;param name="fields" type="string-list">firstname,lastname,gender,age,country&lt;/param>
	&lt;/resource-config>

&lt;/smooks-resource-list>
</pre></td></tr></table>
<p><img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e2FuY2hvcjpleGVjdXRpb259&amp;locale=en_GB&amp;version=2" data-macro-name="anchor" data-macro-default-parameter="execution"></p>

<h1>Executing The Transformation</h1>

<p>Again, it's exactly the same as with the <a class="confluence-link" href="/display/MILYN/Smooks+Example+-+java-basic" data-linked-resource-id="78566" data-linked-resource-type="page" data-linked-resource-default-alias="Smooks Example - java-basic" data-base-url="http://docs.codehaus.org">java-basic</a> tutorial:</p>
<table class="wysiwyg-macro" data-macro-name="noformat" style="background-image: url(/plugins/servlet/confluence/placeholder/macro-heading?definition=e25vZm9ybWF0fQ&amp;locale=en_GB&amp;version=2); background-repeat: no-repeat;" data-macro-body-type="PLAIN_TEXT"><tr><td class="wysiwyg-macro-body"><pre>
Smooks smooks = new Smooks("smooks-config.xml");
StringResult result = new StringResult();

smooks.filter(new StreamSource(messageIn), result);
</pre></td></tr></table>
<p>Of course, you'd typically cache the <a class="confluence-link" href="http://milyn.codehaus.org/javadoc/smooks/org/milyn/Smooks.html" shortcut-key="milyn_public_html" shortcut-parameter="javadoc/smooks/org/milyn/Smooks.html" data-linked-resource-default-alias="unnamed link" data-base-url="http://docs.codehaus.org">Smooks</a> instance.</p>

<p>See the <a href="http://svn.codehaus.org/milyn/trunk/smooks-examples/csv-to-xml/src/main/java/example/Main.java">example/Main.java</a> in the example source.</p>