Thanks - but my schema.xml is not recognizing field names specified in the data-config.xml.
For example - and I just tested this now - if I have in my data-config.xml: <field column="product_id" name="pid" /> And then in my schema.xml: <field name="pid" type="int" indexed="true" stored="true" required="true" /> Then no documents are processed (e.g. I get rows queried, but <str name="Total Documents Processed">0</str> in the data handler UI). But if I change that to: <field name="product_id" type="int" indexed="true" stored="true" required="true" /> ... now documents are processed (e.g. <str name="Total Documents Processed">313</str>). Which, quite frankly, confuses me. I may be doing something else wrong (I changed my SQL as well, so I'm getting another failure, but I think it's separate to this one). -----Original Message----- From: Lance Norskog [mailto:goks...@gmail.com] Sent: Tuesday, July 27, 2010 8:25 PM To: solr-user@lucene.apache.org Subject: Re: Indexing Problem: Where's my data? Solr respects case for field names. Database fields are supplied in lower-case, so it should be 'attribute_name' and 'string_value'. Also 'product_id', etc. It is easier if you carefully emulate every detail in the examples, for example lower-case names. On Tue, Jul 27, 2010 at 2:59 PM, kenf_nc <ken.fos...@realestate.com> wrote: > > for STRING_VALUE, I assume there is a property in the 'select *' > results called string_value? if so I'm not sure why it wouldn't work. > If not, then that's why, it doesn't have anything to put there. > > For ATTRIBUTE_NAME, is it possibly a case issue? you called it > 'Attribute_Name' in your query, but ATTRIBUTE_NAME in your > schema...just something to check I guess. > > Also, not sure why you are using name= in your fields, for example, > <field column="PARENT_FAMILY" name="Parent Family" /> I thought > 'column' was the source field name and 'name' was supposed to be the > schema field name and if not there it would assume 'column' name. You > don't have a schema field called "Parent Family" so it looks like it's > defaulting to column name too which is lucky for you I suppose. But > you may want to either remove 'name=' or make it match the schema. > (and I may be completely wrong on this, it's been a while since I got DIH > going). > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Indexing-Problem-Where-s-my-data-tp > 1000660p1000843.html Sent from the Solr - User mailing list archive at > Nabble.com. > -- Lance Norskog goks...@gmail.com
