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.d...@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.fore...@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.fore...@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 */
