Jon,
looks like you're (just) missing the transformer="RegexTransformer" in
your entity-definition, like documented here:
http://wiki.apache.org/solr/DataImportHandler#RegexTransformer
Regards
Stefan
On Wed, Feb 9, 2011 at 9:16 PM, Jon Drukman <j...@cluttered.com> wrote:
> I am trying to use the regex transformer but it's not returning anything.
> Either my regex is wrong, or I've done something else wrong in the setup of
> the
> entity. Is there any way to debug this? Making a change and waiting 7
> minutes
> to reindex the entity sucks.
>
> <entity name="boxshot"
> query="SELECT GROUP_CONCAT(i.url, ',') boxshot_url,
> GROUP_CONCAT(i2.url, ',') boxshot_url_small FROM games g
> left join image_sizes i ON g.box_image_id = i.id AND i.size_type = 39
> left join image_sizes i2 on g.box_image_id = i2.id AND i2.size_type =
> 40
> WHERE g.game_seo_title = '${game.game_seo_title}'
> GROUP BY g.game_seo_title">
> <field name="main_image" regex="^(.*?)," sourceColName="boxshot_url" />
> <field name="small_image" regex="^(.*?),"
> sourceColName="boxshot_url_small" />
> </entity>
>
> This returns columns that are either null, or have some comma-separated
> strings.
> I want the bit up to the first comma, if it exists.
>
> Ideally I could have it log the query and the input/output
> of the field statements.
>
>
