Hi Kalpa, Did you try the with csv:reader in Smooks mediator instead of resource-config?
<?xml version="1.0" encoding="UTF-8"?> <localEntry xmlns="http://ws.apache.org/ns/synapse"; key="smooks-csv"> <smooks-resource-list xmlns="http://www.milyn.org/xsd/smooks-1.1.xsd"; xmlns:csv=" http://www.milyn.org/xsd/smooks/csv-1.2.xsd";> <csv:reader fields="Book,ISBN,Author,Comments" separator="	" quote="~" rootElementName="Books" recordElementName="Book"/> </smooks-resource-list> <description/> </localEntry> Thanks, Lakmali On 17 February 2015 at 09:22, Kalpa Welivitigoda <[email protected]> wrote: > Hi, > > Smooks has " character as the default for quotes. According to smooks > documentation [1], smooks configuration has a "quote" attribute we can use > to set the quote character. > > I tried with the following local entry in esb as the smooks configuration > and the "quote" param has no effect over the output. My csv file has > records with " character, and without the quote param, the output is wrong > (some records are dropped). Also with setting the "quote" param to > something else like ~ character, the result is the same. > > What could have gone wrong here? > > On a side note, I tried the same with the Smooks csv-to-xml sample and it > works fine (by setting the "quote" attribute in csv:reader). > > <?xml version="1.0" encoding="UTF-8"?> > <localEntry xmlns="http://ws.apache.org/ns/synapse"; key="smooks-csv"> > <smooks-resource-list xmlns="http://www.milyn.org/xsd/smooks-1.1.xsd"; > xmlns:csv=" > http://www.milyn.org/xsd/smooks/csv-1.2.xsd";> > <resource-config selector="org.xml.sax.driver"> > <resource>org.milyn.csv.CSVReader</resource> > <param name="fields">Book,ISBN,Author,Comments</param> > <param name="separator">	</param> > <param name="quote">~</param> > <param name="rootElementName">Books</param> > <param name="recordElementName">Book</param> > </resource-config> > </smooks-resource-list> > <description/> > </localEntry> > > > [1] > http://www.smooks.org/mediawiki/index.php?title=V1.5:Smooks_v1.5_User_Guide > > <?xml version="1.0"?> > <smooks-resource-list xmlns="http://www.milyn.org/xsd/smooks-1.1.xsd"; > xmlns:csv="http://www.milyn.org/xsd/smooks/csv-1.5.xsd";> > > <!-- > Configure the CSV to parse the message into a stream of SAX events. > --> > <csv:reader fields="firstname,lastname,gender,age,country" separator="|" > quote="'" skipLines="1" /> > > </smooks-resource-list> > > > > -- > Best Regards, > > Kalpa Welivitigoda > Software Engineer, WSO2 Inc. http://wso2.com > Email: [email protected] > Mobile: +94776509215 > -- Lakmali Baminiwatta Senior Software Engineer WSO2, Inc.: http://wso2.com lean.enterprise.middleware mobile: +94 71 2335936 blog : lakmali.com
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
