Re: data import with transformer

2009-10-29 Thread Shalin Shekhar Mangar
On Thu, Oct 29, 2009 at 9:48 PM, Joel Nylund wrote: > Hi, I have been reading the solr book and wiki, but I cant find any similar > examples to what Im looking for. > > I have a database field called category, this field needs some text > manipulation before it goes in the index > > here is the j

Re: data import with transformer

2009-10-29 Thread Chantal Ackermann
Another option is the RegexTransformer in DIH: http://wiki.apache.org/solr/DataImportHandler?highlight=%28regex%29#RegexTransformer Chantal William Pierce schrieb: I'd recommend two ways: The way I do it in my app is that I have written a MySql function to transform the column as part of the

Re: data import with transformer

2009-10-29 Thread William Pierce
I'd recommend two ways: The way I do it in my app is that I have written a MySql function to transform the column as part of the select statement. In this approach, your select query would like so: select col1, col2, col3, spPrettyPrintCategory(category) as X, col4, col5, from table