Re: Solr Faceting & DIH

2011-08-30 Thread Alexei Martchenko
I had the same problem with a database here, and we discovered that every item had its own product page, its own url. So, we decided that our unique id had to be the url instead of using sql ids and id concatenations. sometimes it works. You can store all ids if u need them for something, but for u

Re: Solr Faceting & DIH

2011-08-30 Thread Erick Erickson
I'd really think carefully before disabling unique IDs. If you do, you'll have to manage the records yourself, so your next delta-import will add more records to your search result, even those that have been updated. You might do something like make the uniqueKey the concatenation of productid and

Re: Solr Faceting & DIH

2011-08-29 Thread Way Cool
I think you need to setup entity hierarchy with product as a top level entity and attribute as another entity under product, otherwise the record #2 and 3 will override the first one. On Mon, Aug 29, 2011 at 3:52 PM, Aaron Bains wrote: > Hello, > > I am trying to setup Solr Faceting on products

Solr Faceting & DIH

2011-08-29 Thread Aaron Bains
Hello, I am trying to setup Solr Faceting on products by using the DataImportHandler to import data from my database. I have setup my data-config.xml with the proper queries and schema.xml with the fields. After the import/index is complete I can only search one productid record in Solr. For examp