lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rafael Taboada <kaliman.fore...@gmail.com>
Subject Re: Data Import Handler fields with different values in column and name
Date Fri, 01 Jun 2012 15:54:48 GMT
Hi James,

I'm not duplicating fields. Just using one field asunto:

 <field column="asunto" name="anotherasunto" />

Thanks for your help.

On Fri, Jun 1, 2012 at 9:50 AM, Dyer, James <James.Dyer@ingrambook.com>wrote:

> Are you leaving both mappings in there, like this...
>
> <entity name="documento" query="SELECT iddocumento,nrodocumento,asunto
> FROM documento">
>  <field column="iddocumento" name="iddocumento" />
>  <field column="nrodocumento" name="nrodocumento" />
>  <field column="asunto" name="asunto" />
>  <field column="asunto" name="anotherasunto" />
> </entity>
>
> If so, I'm not sure you can map "asunto" to two different fields like
> this.  For that, you may need to write a transformer that will duplicate
> "asunto" for you.  Although, in most cases all you need to do is add a
> <copyField /> in schema.xml to copy "asunto" to "anotherasunto".  But a DIH
> Transformer would be helpful, for instance, if "asunto" is multi-valued but
> you only want to copy the first value to "anotherasunto" (perhaps you need
> to sort on it, which is not possible with multi-valued fields).
>
> If this doesn't help, let us know exactly why you need to duplicate
> "asunto" and maybe you can get more help from there.
>
> (If you're not trying to duplicate "asunto" and you're sure you've taken
> the duplicate out of data-config.xml, then go ahead and double-check
> spelling and case in all your config files.  Besides a typo somewhere, I'm
> not sure what else would cause this not to map.)
>
> James Dyer
> E-Commerce Systems
> Ingram Content Group
> (615) 213-4311
>
>
> -----Original Message-----
> From: Rafael Taboada [mailto:kaliman.forever@gmail.com]
> Sent: Thursday, May 31, 2012 4:13 PM
> To: solr-user@lucene.apache.org
> Subject: Fwd: Data Import Handler fields with different values in column
> and name
>
> Please,
>
> Can anyone guide me through this issue? Thanks
>
>
>
> ---------- Forwarded message ----------
> From: Rafael Taboada <kaliman.forever@gmail.com>
> Date: Thu, May 31, 2012 at 12:30 PM
> Subject: Data Import Handler fields with different values in column and
> name
> To: solr-user@lucene.apache.org
>
>
> Hi folks,
>
> I'm using Solr 3.6 and I'm trying to import data from my database to solr
> using Data Import Handler. My db-config is like this:
>
> <dataConfig>
>   <dataSource driver="oracle.jdbc.OracleDriver"
> url="jdbc:oracle:thin:@localhost:1521:XE" user="admin" password="admin" />
>   <document>
>      <entity name="documento" query="SELECT
> iddocumento,nrodocumento,asunto FROM documento">
>         <field column="iddocumento" name="iddocumento" />
>         <field column="nrodocumento" name="nrodocumento" />
>         <field column="asunto" name="asunto" />
>      </entity>
>   </document>
> </dataConfig>
>
> My problem is when I'm trying to use a different values in the field tag,
> for example
>
>         <field column="asunto" name="anotherasunto" />
>
> When I use different name from column, this field is omitted. Please can
> you help me with this issue?
>
> My schema.xml is:
>
> <types>
>      <fieldtype name="string" class="solr.StrField" sortMissingLast="true"
> />
>   </types>
>
>   <fields>
>      <!-- general -->
>      <field name="iddocumento" type="string" indexed="true" stored="true"
> required="true" />
>      <field name="nrodocumento" type="string" indexed="true" stored="true"
> />
>      <field name="anotherasunto" type="string" indexed="true"
> stored="true" />
>   </fields>
>
> Thanks in advance!
>
> --
> Rafael Taboada
>
>
>
>
>
>
> --
> Rafael Taboada
>
> /*
>  * Phone >> 992 741 026
>  */
>



-- 
Rafael Taboada

/*
 * Phone >> 992 741 026
 */

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message