I do not see any logging statements in the code, so I don't think there's anything on that end that can be done.
It would be easy, though, if he is using multiple mappings to remove the duplicate and see if that solves it. From a more-thorough review of the code, though, I think my intial hunch was wrong. It does seem as if you can have multiple mappings. Then again, I didn't check for a unit test on this so even if the code is designed to allow it, it might not work (it doesn't seem like a feature people would expect to work either). In troubleshooting this one, I'd definitely try it without multiple mappings to see if it fixes it. James Dyer E-Commerce Systems Ingram Content Group (615) 213-4311 -----Original Message----- From: Jack Krupansky [mailto:j...@basetechnology.com] Sent: Friday, June 01, 2012 10:34 AM To: solr-user@lucene.apache.org Subject: Re: Data Import Handler fields with different values in column and name James: Is there some particular DIH logging he can turn on to see what is really happening with his field name mapping? In other words, if DIH/Solr really is ignoring that field mapping, to find out exactly why. -- Jack Krupansky -----Original Message----- From: Dyer, James Sent: Friday, June 01, 2012 10:50 AM To: solr-user@lucene.apache.org Subject: RE: Data Import Handler fields with different values in column and name 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 */
