Thanks Shalin, I tried putting everything under the same document (two different unrelated entities), and got a bit further.
My problem now appears to be both of them stepping on each other due to "id" conflicts. Currently my id is defined in my schema as <field name="id" type="long" indexed="true" stored="true" required="true"/> Do I have to create a new "id" field? Thanks ** julio -----Original Message----- From: Shalin Shekhar Mangar [mailto:[EMAIL PROTECTED] Sent: Thursday, May 29, 2008 11:40 AM To: solr-user@lucene.apache.org Subject: Re: How to describe 2 entities in dataConfig for the DataImporter? Hi Julio, The first data-config is correct. You're running DataImportHandler in debug mode which creates only the first 10 documents by default. You can also add count=N to index only the first N documents. But this is intended only for debugging purposes. If you want to do a full-import just use /dataimport?command=full-import. By default, a full-import automatically cleans and commits. Hope that helps. On Thu, May 29, 2008 at 11:42 PM, Julio Castillo <[EMAIL PROTECTED]> wrote: > I have 2 dB tables unrelated to each other that I want to index. > > I have tried 2 approaches for specifying them in my data-config.xml file. > None of them seem to work (it seems I can only get data for the first > one listed). > > CASE 1) > <dataConfig> > <document name="test"> > <entity name="owners" pk="id" query="...."> > <field column="id" name="id"/> > <field column=name" name="userName"/> > </entity> > <entity name="vets" pk="id" query="...."> > <field column="id" name="id"/> > <field column=name" name="userName"/> > </entity> > </document> > </dataConfig> > > CASE 2) > <dataConfig> > <document name="test-1"> > <entity name="owners" pk="id" query="...."> > <field column="id" name="id"/> > <field column=name" name="userName"/> > </entity> > </document> > <document name="test-2"> > <entity name="vets" pk="id" query="...."> > <field column="id" name="id"/> > <field column=name" name="userName"/> > </entity> > </document> > </dataConfig> > > I ran the dataImporter as follows > http://localhost:2455/solr/dataimport?command=full-import&debug=on&ver > bose=t > rue&clean=true&commit=true > > After running Case 1 the output only shows documents under entity:owners. > And an empty reference to entity:vets (no data). > > After running Case 2, the output only shows documents under entity:owners. > No references to entity:vets. > > In either case, I have commented out the entity:owners and I do see > the entity:vets data then. > > Thanks for your assistance > > Julio Castillo > > -- Regards, Shalin Shekhar Mangar.