Respected Sir, Please consider below SmooksConfig file , while reading the mail instead the one in previous mail
<?xml version="1.0" encoding="UTF-8"?> <smooks-resource-list xmlns="http://www.milyn.org/xsd/smooks-1.1.xsd"; xmlns:ftl="http://www.milyn.org/xsd/smooks/freemarker-1.1.xsd";> <params> <param name="stream.filter.type">SAX</param> <!-- <param name="inputType">input.xml</param> <param name="input.xml" type="input.type.actived">File:/C:\Work\2016\09_ESB_Auto_Mail_rpts\TestFiles\TestFileXMLCSVMap.xml </param> --> <param name="default.serialization.on">true</param> </params> <resource-config selector="book"> <resource>org.milyn.delivery.DomModelCreator</resource> </resource-config> <ftl:freemarker applyOnElement="library"> <ftl:template><!--author;title <?TEMPLATE-SPLIT-PI?> --> </ftl:template> </ftl:freemarker> <ftl:freemarker applyOnElement="book"> <ftl:template> <!--${book.name},${book.title} --> </ftl:template> </ftl:freemarker> <ftl:freemarker applyOnElement="library1"> <ftl:template><!--<#ftl > <?TEMPLATE-SPLIT-PI?> --> </ftl:template> </ftl:freemarker> <ftl:freemarker applyOnElement="book"> <ftl:template> <!--<#ftl >*${book.author},${book.title}* --> </ftl:template> </ftl:freemarker> </smooks-resource-list> With Regards, Aditya On Sun, Jul 15, 2018 at 10:34 PM, aditya shivankar < [email protected]> wrote: > Respected Sir, > > I have to use smooks mediator to convert large xml to csv format. But > getting errors. Please Guide. > Here I have book structure(mmodel) inside two tags library and library1. > > Below is the sample example with less data : > > *My input is :* > > <?xml version="1.0"?> > <catalog> > <library> > <book id="bk101"> > <name>a</name> > <title>b</title> > </book> > <book id="bk102"> > <name>c</name> > <title>d</title> > </book> > </library> > <library1> > <book id="bk103"> > <author>e</author> > <title>f</title> > </book> > <book id="bk104"> > <author>g</author> > <title>h</title> > </book> > </library1> > </catalog> > > > *SmooksConfig.xml :* > <?xml version="1.0" encoding="UTF-8"?> > <smooks-resource-list xmlns="http://www.milyn.org/xsd/smooks-1.1.xsd"; > xmlns:ftl="http://www.milyn.org/xsd/smooks/freemarker-1.1.xsd";> > <params> > <param name="stream.filter.type">SAX</param> > <!-- <param name="inputType">input.xml</param> > <param name="input.xml" type="input.type.actived"> > File:/C:\Work\2016\09_ESB_Auto_Mail_rpts\TestFiles\TestFileXMLCSVMap.xml > </param> --> > <param name="default.serialization.on">true</param> > </params> > <resource-config selector="book"> > <resource>org.milyn.delivery.DomModelCreator</resource> > </resource-config> > > <ftl:freemarker applyOnElement="library"> > <ftl:template> > <!--author;title > <?TEMPLATE-SPLIT-PI?> > --> > </ftl:template> > </ftl:freemarker> > > <ftl:freemarker applyOnElement="book"> > <ftl:template> > <!--${book.name},${book.title} > --> > </ftl:template> > > </ftl:freemarker> > <ftl:freemarker applyOnElement="library1"> > <ftl:template> > <!--<#ftl > > <?TEMPLATE-SPLIT-PI?> > --> > </ftl:template> > </ftl:freemarker> > > <ftl:freemarker applyOnElement="book"> > <ftl:template> > <!--<#ftl > > --> > </ftl:template> > > </ftl:freemarker> > </smooks-resource-list> > > *desired output :* > > author;title > a,b > c,d > e,f > g,h > > > *Actual Exception :* > > 018-07-15 21:59:03,584] [EI-Core] ERROR - SmooksMediator Failed to filter > source. > org.milyn.SmooksException: Failed to filter source. > at org.milyn.delivery.sax.SmooksSAXFilter.doFilter( > SmooksSAXFilter.java:97) > > Caused by: org.milyn.delivery.sax.SAXWriterAccessException: Illegal > access to the element writer for element 'book' by SAX visitor > 'org.milyn.templating.freemarker.FreeMarkerTemplateProcessor'. Writer > already acquired by SAX visitor > 'org.milyn.templating.freemarker.FreeMarkerTemplateProcessor'. > See SAXElement javadocs (http://milyn.codehaus.org/Smooks). Change > Smooks visitor resource configuration. > at org.milyn.delivery.sax.SAXHandler$WriterManagedSAXElement. > throwSAXWriterAccessException(SAXHandler.java:632) > at org.milyn.delivery.sax.SAXHandler$WriterManagedSAXElement. > getWriter(SAXHandler.java:597) > ... 19 more > [2018-07-15 21:59:03,589] [EI-Core] ERROR - SequenceMediator Failed to > filter source. Caused by Failed to filter source. > org.wso2.carbon.mediator.service.MediatorException: Failed to filter > source. Caused by Failed to filter source. > at org.wso2.carbon.mediator.transform.SmooksMediator.handleException( > SmooksMediator.java:265) > *Actual output : *No file is getting generated. > > With Regards, > Aditya >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
